2 Replies Latest reply: Oct 8, 2018 7:30 PM by David Bayani RSS

    How to return the Dimension of Aggr()

    David Bayani

      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.