topic Re: Grouping dimensions by ranked measure in App Development

Grouping dimensions by ranked measure

nate_eyster — Thu, 23 Feb 2017 14:59:39 GMT

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.

Re: Grouping dimensions by ranked measure

lironbaram — Thu, 23 Feb 2017 15:12:05 GMT

you are correct

your dimension should be

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

Re: Grouping dimensions by ranked measure

MK_QSL — Thu, 23 Feb 2017 15:16:28 GMT

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..