User Filter - Top X
I am a new Spotfire User and I am working to provide visualization options to our data customers.
One of the options I’m trying to provide should allow them to make their own top “x” filtering options (e.g. top 10, top 20, top 10%, top 20%, bottom 10% etc, or even top 53% if the user wanted it) by typing their desired number into a filter in a webplayer.
From looking around online, it seems the best way is to create ‘preset’ filters using calculated columns from DenseRank, but is there a more straightforward way? A way that would allow us filter by top “x” of all data and then by “x” of category “abc” without having a calculated DenseRank column for each category?