Chart sort on different value

[jmgardn2]

Hello,
I have a datasource with the following information:

Code: Select all

Name    Count   Average
Blue    57      7.6162
Kai     53      10.03795455
Ant     32      9.0490625
Aet     30      10.77823529
Hnet    30      10.449
UC      16      6.140666667
No      11      0
Wes     2       9
Cig     1       0
Hea     1       7.7

I would like to have a chart where the Value column is "Average" and Argument column is "Name", but I would like to use the "Sort By" on count in order to show the top 5 based on count. For instance, right now the chart would show Aet, Hnet, Kai, Ant, and Wes because those have the top Averages. But instead I would like it to show Blue, Kai, Ant, Aet, and Hnet because those have the top Counts. Is it possible to show the "Top N" of a given field? Thank you for your help!

[HighAley]

Hello.

You should set next properties of the Chart:

• Data Source
• Filters
• Sort

Please, look at the attached report template with sample data.

Report.mrt

(12.27 KiB) Downloaded 291 times

Book1.csv

(167 Bytes) Downloaded 316 times

Thank you.

[jmgardn2]

That worked perfectly, thank you very much Aleksey!!!

[Andrew]

Hello,

Have a great weekend!