Top 10 and Bottom 20

[joancasellasvega]

Hi,
I have the following expression:
count(INSTANCIA)/(count( distinct if( INSTANCIA > 0 , [LastModified.autoCalendar.Date])))
Which gives me the average number of "instanicas" made per day.
I would like to get the top 10 and bottom 20 in two different charts.
Any help will be really appreciated.
Thanks,
Joan

[TarekHajji]

You can specify the top 20 or bottom 10 in the parameter of the chart
for example, in bar chart you can set the dimension limitation as fix number and specify the lower or bottom number
Regards