Histogram counting multiple occurrences

Hi,

I have a histogram counting multiple case keys.
I have put the KPI in the dimension box and specified the bucket count. When i check the histogram the number of occurrences are more than the total number of cases.Not sure what is happening behind the scenes.Any idea what should i do in these cases.?

Thanks,
Sravan

Hi Sravan,

could you please show us your formula?

Are you using something like

YEAR("_CEL_P2P_ACTIVITIES".“EVENTTIME”)

but need

YEAR(PU_FIRST(“EKPO”, “_CEL_P2P_ACTIVITIES”.“EVENTTIME”))

Best regards,

Kay

1 Like