I have a table that dynamically changes based on a parameter chosen. I need this table to also change sorting and filtering based on which parameter is picked. I have created a “rank” column for each of the fields and utilized the switch function to change. This works for showing the top X results (due to being able to use a filter of rank < 15) but when trying to show the bottom results the option for top/bottom filter does not appear, as some metrics may have 100 results and others may have 1000s, so last X # of ranks are different. Is there a way to use the top/bottom filter?
Hi @mroo11,
You could try setting up an ifelse statement for your ranking column that changes how it gets ranked based on the parameter choice. For filtering out though, I’m not quite sure there’s a great way around the top/bottom filter issue you’re encountering as you need to use an integer.
I think the best work around for this would be to create separate visuals, one for each parameter option that you need different sorting. Then hide/show them based on a rule handled by the same parameter.
Thanks @Brett
Is there a way to convert my rank calculated field from a number to an integer?
Issue resolved utilizing other method
1 Like