6 Replies Latest reply on Mar 6, 2017 2:14 AM by Dimitris Mitrodimas

    Group values of a ranked field

    Dimitris Mitrodimas

      Hi everyone,


      I have a graph where I show the number of users per country (split by their gender), as per below:



      Since the number of countries is quite large (you only see a small fraction here), I would like for the graph to only show the top 9 countries + 1 group including "all others". So I need to somehow group countries according to their ranking.


      Now, in "normal" fields, I know you can just right-click on them and create your own custom groups, as shown below for field "Packaging" for example.



      The thing is, I need to do the same with a calculated field that computes the ranking of each country according to its number of users, i.e.

      When I right-click on "Rank", Tableau doesn't offer a "Group" option like it does with other fields. So I cannot find a way to make this work...



      Any suggestions?


      Thanks in advance,