Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Assuming I have the following aggregated data:
Date | Hour | # of Objects |
06/25/19 | 06:00 | 10 |
06/25/19 | 07:00 | 15 |
06/25/19 | 08:00 | 20 |
06/25/19 | 09:00 | 25 |
To retrieve the maximum "# of objects" by date and hour, I'm using this expression:
=Max(aggr(count(ObjectID),Date,[Hour (hh)]))
It gives me the correct value (25), but I also want to find the relevant hour (09:00).
Can you assist me with this expression?
Thanks in advance,
Eli.
HI
this should do the trick
=firstsortedvalue(aggr([Hour (hh)],Date,[Hour (hh)]),-aggr(count(ObjecID),Date,[Hour (hh)]))
HI
this should do the trick
=firstsortedvalue(aggr([Hour (hh)],Date,[Hour (hh)]),-aggr(count(ObjecID),Date,[Hour (hh)]))
Toda 🙂
על לא דבר