6 Replies Latest reply: Dec 19, 2016 12:48 AM by anni zhang RSS

    List top n nationalities in a text box

    anni zhang

      Hi everyone,

       

      I have a problem with listing top n values in a text object.

       

      The scenario is to list top 5 nationalities for student enrollment (count(studentID)).

      I tried rank and firstsortedvalue, none of it work. Because firstsortedvalue does not accept nested aggregation so I cannot put count(studentID). Besides, it only provide the top 1 value.

       

      Anybody could help please? Thank you very much in advanced!

       

      Regards,

       

      Anni