Filter Visualization to include top 10 only

[gusdahu]

Hello,

I have a population of vendor spend over a given period. I included a visualization within my dashboard. However, I would like the visualization to only show the top 10 or 15 vendors by spend rather than the entire population. How may I do this?

Regards,

Gus Dahu

[Greg_Deckler]

Easiest way in the Filters area use Top N filtering.

[gusdahu]

---

@Greg_Deckler wrote:

Easiest way in the Filters area use Top N filtering.

---

Where would I find this filter?

Regards,

Gus

[Greg_Deckler · Accepted solution]

So, I don't have exact info on what you have but can point you to it. Select your visual. Underneath VISUALIZATIONS pane you should see a section called FILTERS. Within that section there is a "Visual level filters" area and it should include every column and measure that you have in your visual. Let's say you have a Column1 and a Column2 in a table. You want the Top N of Column1 (category of something) based upon Column2 (value). Hover over Column1 and click the drop down arrow.  Under "Filter Type", click the drop down and choose "Top N". For "Show items" leave the drop down at "Top" and put in the top number of items you want, let's say 10. In the "By value" area drag in your Column or Measure that you want the "top" to be based on. Click "Apply filter".

[gusdahu]

This worked! Thanks Greg!