0 Replies Latest reply: Feb 5, 2018 9:38 AM by Mandi Hu RSS

    Get the "FirstSortedValue" with aggregation calculation

    Mandi Hu

      I have a table like below

       

      DateWeedkayHourCount
      2018-01-01Mon1100
      2018-01-01Mon2200
      2018-01-01Mon350
      2018-01-02Tue1120
      2018-01-02Tue

      2

      80
      2018-01-02Tue355
      2018-01-03Wed1200
      2018-01-03Wed2100
      2018-01-03Wed3105

       

       

      I would like to have 2 text objects to show the Weekday with most count (Wed in the example) and hour with most count (Hour 1 in the example).

       

      I have tried FirstSortedValue but it doesn't allow nested aggregation.

       

      Anyone can help? Thank you in advance!