Forum Discussion
Filter Visualization to include top 10 only
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
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".
4 Replies
Easiest way in the Filters area use Top N filtering.
Greg_Deckler wrote:Easiest way in the Filters area use Top N filtering.
Where would I find this filter?Regards,
Gus
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".
