2 Replies Latest reply on Jul 31, 2016 11:13 PM by Martin Kuhne

    Rank over all segments of a stacked or side by side chart

    Martin Kuhne

      Let's say I want to show variables Country and Success (yes/no). I set up a stacked bar chart with Columns as Country, Rows as Percent of SUM(Number ot Records) Partitioning Country, over Success. Success as Color.

       

      This is cool, but now I have 50 countries. I want to go down to the TOP 20 Countries by SUM(Number of Records). Something like RANK_UNIQUE(COUNT([Country]) / TOTAL(COUNT([Country]))). However, any way I try to shape it, it always ranks the individual segments of the stacked bar chart, never the entire bar.

       

      I have been reading and searching posts about this, but I haven't been able to identify a solution that works. Help?