Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Top N and a specific value

Hello, I need to include in a line chart the top 8 of the data and an additional data to be able to make the comparison. For example, the top 8 universities in Latin America and the University of Sao Paulo.

Is it possible to do this?

Thanks for the help.

2 Replies

  • Hello!

     

    I made a example database for this case, where the "REF" is the one for comparison:

     

    First:

    The "top n" you can use a righ filter on the visual:

     

     

    Then, for reference, you can use a simple solution (hope this works on your case):

     

     

     

    Then, this is the final result:

     

     

  • Hello, thanks for the help! If it served me, I only have one doubt, I want to divide the results by year but for that I need to have a legend to divide the results plus the top previously selected. However it did not work for me and the graph looks like this:

    I don't know if it's possible to do this? Thanks for the help!