How to return the Dimension of Aggr()

[Anonymous]

Hi friends,

I have a histogram as per below, which shows the number of calls by day of week:

Dimension: WeekDay

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?

Thank you.

[dplr-rn · Accepted solution]

try

FirstSortedValue(  WeekDay, -Aggr ( Sum(Calls) , WeekDay)  )

[Anonymous]

Great Dilip.

Thank you very much for your quick help.

i appreciate it.