Show only Top X in a chart

RobClark3 · ‎09-28-2018

How do I filter a chart that based on distinct values in a text column to only show the top 10 most common?

E.g. I could have 4000 rows that have 20 different classifications, I want to only show the top 10 most popular classifications (the data is dynamic) on a bar chart.

Portal 10.6.1, Insights 3.0

NathanSmith8 · ‎10-09-2018

Hi Rob,

Thanks for posting. The only way to do this currently is through filters, and it wouldn't be exactly what you're looking for as a filter wouldn't dynamically display the 'top counts'. Rather, it filters a specified array of values.

To do this, you'd have to setup a filter so that the chart only displays, say 'counts greater than 1.8' or 'between a range of 1.8 - 5'.

In the example below, I have roughly 10 classifications but only 5 of them are displayed in the chart after applying the filter:

What is your specific use case for having the top counts to be displayed dynamically in a chart card, Rob?

View solution in original post

NathanSmith8 · ‎10-09-2018

Hi Rob,

Thanks for posting. The only way to do this currently is through filters, and it wouldn't be exactly what you're looking for as a filter wouldn't dynamically display the 'top counts'. Rather, it filters a specified array of values.

To do this, you'd have to setup a filter so that the chart only displays, say 'counts greater than 1.8' or 'between a range of 1.8 - 5'.

In the example below, I have roughly 10 classifications but only 5 of them are displayed in the chart after applying the filter:

What is your specific use case for having the top counts to be displayed dynamically in a chart card, Rob?

RobClark3 · ‎10-09-2018

Hi Nathan - this doesn't work. In a lot of the dashboards we do currently with map context, we often have some form of Top X which displays data relevant to a specific area. So as you filter you could see the top county's, states, or other geographical areas for a particular filter, category, type.