Page 1 of 1

Chart sort on different value

Posted: Wed Nov 13, 2013 9:02 pm
by 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!

Re: Chart sort on different value

Posted: Fri Nov 15, 2013 6:53 am
by 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.

Re: Chart sort on different value

Posted: Fri Nov 15, 2013 1:51 pm
by jmgardn2
That worked perfectly, thank you very much Aleksey!!!

Re: Chart sort on different value

Posted: Sun Nov 17, 2013 5:57 am
by Andrew
Hello,

Have a great weekend!