Skip to main content
Hi,everyone,
I created an analysis using boxplot, but the filter didnt work well.
PQL statement
Column chart
DimensionHOURS(PU_FIRST(casetable,activityTable.EVENTTIME))
KPICase Count TPTAvg. AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES)))
Boxplot
Distribution AxisCALC_THROUGHPUT(FIRST_OCCURRENCE[<%= From %>] TO FIRST_OCCURRENCE[<%= To %>], REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES)) From,To Activity name
Dimension AxisHOURS(PU_FIRST(casetable,activityTable.EVENTTIME))
image20641236 131 KB

If I selected 11 on the column chart, I assumed that the boxplot also shows 11.
However, it is displayed 0.Same for other values
image20631246 136 KB
Is it IBCs specification? Or something wrong with my PQL statement?
Best regards,
Marie
Hi Marie
Your formulas seem to be correct. Could you please check if there are any component filters applied to the boxplot chart?
Thanks and best regards,
Data Science Service Desk
Thank you for your reply
I checked this, but there werent any component filters applied to.
Anyway, now it works well .
Best regards,
Marie

Reply