Grouping dimensions by ranked measure

[nate_eyster]

All,

I am trying to make a simple bar chart that has one dimension, "Top 10 Sites", which averages the top ten sites by measure (utilization rate), and then have another date point that would include all sites outside the Top 10 by Utilization rate. I would assume it would be an aggr(if(rank(avg))) or something along those lines.. Any input? see visual I'm trying to derive below.

[lironbaram · Accepted solution]

hi

you are correct

your dimension should be

aggr(if(rank(avg(utilization rate))<=10,'Top 10','Other Sites'),Site)

[MK_QSL]

Create a bar chart without dimension

Use below two expressions

SUM({<Site = {"=Rank(Avg(Sales),4)<=10"}>}Sales)

SUM({<Site = {"=Rank(Avg(Sales),4)>10"}>}Sales)

Change Sales field with your respective measure field..