Show only Top X in a chart

RobClark3

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

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?