2 of 2 people found this helpful
You can go to Color marks card->Edit Color-> Select stepped color check box and choose the number of steps you want to take depending on your range of measurements.Increase & decrease the steps and notice the change in color, that way you can determine the right number of steps required for your requirement
That should solve your issue...
Thanks for the advise however did not solve my problem.
The range of colours isn't the issue, my issue is that the colours should be specific to the measurement type however when adding more than 1 measurement type they are specific to all measurements.
Does that make sense?
I find your query interesting and i tried to find out the solution but after a good amount research, this problem cannot be solved.
We could have had option of deciding the colour range, for eg. "pane down" option.
But, unfortunately its not there.
Have found a potential worst case solution that may work if I make each measurement type a measure, will keep digging a while longer to see if there is an easier way first though.
That sounds to be a good workaround though.
This is Simply achievable using a "Table Calculation" , i.e. Rank
Write a calculation
Name :: Rank
Then Drag this to color card now then Change the compute using option to "Pane down and across"
Also find the attachment of document that help you with same. Replicated using superstore Data set.
Please mark this answered if it helped you
Pane Wise Color Using Rank.twbx 320.5 KB