This content has been marked as final. Show 2 replies
I have a histogram as per below, which shows the number of calls by day of week:
Measure: Sum( Calls)
Now, I want to write an automated commentary. In the commentary, I want to refer to the largest dimension.
I want to say: " Saturday was the busiest day "
How can I write a script which returns Saturday ?
This function Max ( Aggr ( Sum(Calls) , WeekDay) ) returns 82, but I want to get its corresponding dimension (Sat).
Could you please help?