How to get the top (n) results in a chart?
Hi Paul,
For the Serial Chart element, you can configure it to show to "top N" values for a field, by specifying the maximum categories property. For example, in the screen capture below - the serial chart is showing station ID values on the x-axis (category field), with their mercury levels on the y-axis (series 1 field). The mercury levels are sorted in descending order, with the maximum categories property set to 10 - so the chart is displaying the top 10 stations with the highest mercury levels in descending order.
Hope this helps,
Hi Derek
Thanks for the reply.
This is close, but not quite for what I need. I see from your screenshot that you have selected 'Features' as the 'Categories From' option. This allows you to choose a 'Category Field', which for me is a field called 'detail' which contains text strings. Now it asks for a 'Series 1 Field', which it requires to be a numeric field. This is where it doesn't work.
I want to use 'Grouped Values' to display a Count statistic based on my 'detail' string field. Doing this gives me a bar graph of all the values in that field. But if I use Grouped Values then there is no 'Maximum Categories' option, so the bar graph is kind of unreadable. I have inserted a screenshot below to help understand - it's a typical graph with a long tail...
Am I missing something here?
