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!