Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Firas,
try this
=Count({<City={"=Rank(Count(DISTINCT Customer)) <= 10"}>} DISTINCT Customer)
Regards,
Antonio
Hi
IN addition to Antonio's solution try this
sum(if(Rank(expression) <= 10,expression,0)
regards
Pradosh
=if(
Aggr(Rank(count(customer)), City)<=10,
City,
'Others'
)
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!
The above expression, gives syntax error