"All time high" KPI with value and date

danabb — Fri, 26 Nov 2021 13:50:37 GMT

Hello,

I have my data in the following format:

I would like to show a a "Max events in one day" KPI together with the date of the (first) occurrence.

I figured I can find the maximum number of events with the following formula:

=Max(Aggr(Count(DISTINCT event_Id), day, month, year))

However, how do I find the date (as year & month & day) where the "all time high" was reached?

Re: "All time high" KPI with value and date

AshutoshBhumkar — Fri, 26 Nov 2021 14:50:57 GMT

Hello,

Try using,

=FirstSortedValue(timestamp,-Aggr(Count(DISTINCT event), day, month, year)) in KPI.

Thanks,
Ashutosh