Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 13, 2013 9:02 pm**

Hello,
I have a datasource with the following information:

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!

Posted: **Fri Nov 15, 2013 6:53 am**

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.

Posted: **Fri Nov 15, 2013 1:51 pm**

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

Posted: **Sun Nov 17, 2013 5:57 am**

Hello,

Have a great weekend!

Creating reports and dashboards | Stimulsoft community forum

Chart sort on different value

Chart sort on different value

Re: Chart sort on different value

Re: Chart sort on different value

Re: Chart sort on different value