Spotfire - Color by dynamic group - use $map() and rank()

Sometimes you want to see how data changes by grouping data into different groups. Groups changes by using sliders.

This is what you can use in "color by":

You need first to create new rank columns based on sorted data.

If you want to select multiple columns, first, create new columns (avg/sum rank), and then re-rank the new column.

Useful link: (add calculated/binned/tagged columns)

https://www.youtube.com/watch?v=oorLo7Hrt6g