topic Re: Get Top 10 Total in Bar Chart Title in App Development

Get Top 10 Total in Bar Chart Title

Anonymous — Tue, 10 Oct 2017 12:53:03 GMT

Hello Everyone!

I have a bar chart of top 10 cities, I reached this by setting the dimension as City_name and by changing the setting in the bar chart dimension's "Limitation" option to 10 without showing others. Now, in the Chart's title i'd like to count the total customers of those 10 cities only. My question is, how can I get the total customers pf those cities?

waiting for your kind cooperation, Thanks!

Re: Get Top 10 Total in Bar Chart Title

antoniotiman — Tue, 10 Oct 2017 13:34:51 GMT

Hi Firas,

try this

=Count({<City={"=Rank(Count(DISTINCT Customer)) <= 10"}>} DISTINCT Customer)

Regards,

Antonio

Re: Get Top 10 Total in Bar Chart Title

pradosh_thakur — Tue, 10 Oct 2017 13:42:07 GMT

IN addition to Antonio's solution try this

sum(if(Rank(expression) <= 10,expression,0)

regards

Pradosh

Re: Get Top 10 Total in Bar Chart Title

Anonymous — Tue, 10 Oct 2017 13:57:31 GMT

=if(

Aggr(Rank(count(customer)), City)<=10,

City,

'Others'

)

Re: Get Top 10 Total in Bar Chart Title

Anonymous — Wed, 11 Oct 2017 04:53:54 GMT

Thanks for your fast reply. This have given me the closet result; however, its not quite what I am looking for. This gives the top 10 cities perfectly, but the count is incorrect. Any ideas?

Thanks!

Re: Get Top 10 Total in Bar Chart Title

Anonymous — Wed, 11 Oct 2017 04:54:44 GMT

The above expression, gives syntax error