Bar chart: how to show limit data to top 10

[#1]

Hi,

I have bar chart that shows way too many data points on the x axis. How can I only show the top 5 or 10?

Thanks,

Mat

[#2]

Hi

you can create a new dimension as

if( aggr( rank( sum(Value) , Idcustomer ) <= 10 ) , Idcustomer )

it displays the top 10 of customer sorted by sum(Value)

JJ

[#3]

Sweet. Love the aggr function. Is there documentation that covers all the functions. The help menu doesn't.

thnx

[#4]

Agree AGGR is the most important function of QV.

I also agree the reference guide is not very clear about the use of some functions. The best way to understand how to use function is to search in the forum where there's a lot of post with good examples.

JJ