Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys - I have some set analysis:
=max( aggr( count({<Activity_or_Demand={'Demand'}, Financial_Year_Week-={'2099-41'}, Room-={'CTSIM','CTSIM2'}>} Event_Key]), [Calendar_Year_Month]))
This shows me the MAX value within my data. What I now need to show is the corresponding date (Calendar_Year_Month) that this applies to. I have this data as a bar chart, spanning 5 years, so I am adding a text box next to it to show our users during which date (Calendar_Year_Month) the MAX value occurred in.
Thank you!
Hi Jlampard40
Have you found the solution for that need ? I hope so.
It seems a case for using the FIRSTSORTEDVALUE function, doesn't it?
Personally, I got to understand this in this worth reading article: https://www.analyticsvidhya.com/blog/2014/02/aggr/#:~:text=AGGR
Best regards,
Marcos