Hi,
I have 1 Dimension and 7 Metrics. Every value is is 0-100%.
I need to do a color grading from red to green which is typically achieved using ColorMix1(). The side effect of this function is that it fixates your sorting to the dimension and not by metric or interactive sorting on the expressions.
Is there a workaround around this?
The reason is because it is using the RangeMin and RangeMax which go from 1 to total number of rows which I am thinking uses dimension sort.
Thanks in advance