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)

      Capture.PNG

      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.