Top 10 Count of Category

[#1]

Hi Team,

Like we do in Bar Charts - sort Descending on Count of Calls & in presentation tab, restrict only top 10 counts with "Max Visible Number".

I want to do the same in Pivot and Straight Chart.

How to achieve this? Pls Suggest!!

[tabletuner]

On the sort tab choose sort by expression and enter:

=
 count(fieldname)

and choose descending.

In the presentation tab choose your max amount.

[#3]

Create a Calculated dimension

if(aggr(rank(expression),dimension)<=10,dimension)

If your dimension is product then your calculated dimension would be

if(aggr(rank(sum(val)),product)<=10,product)

Make sure the expression is sorted desc by y value and that you suppress when value is null

[#4]

Thanks carneyfm.

Its working.