Why Heatmap Custom Sorting not working?

[hedychen]

Hello,

I wanted to sort one of the dimensions called "Likelihood" exactly as "Low" "Medium" "High"...  My formula was "Match ([Likelihood], 'Low', 'Medium', 'High')"  but it never worked as expected (see attached screenshot)...

Can anyone let me know what went wrong, and how can I fix this issue?Heatmap Custom Sorting issue

[tresesco]

@hedychen  Will you be able to share your sample app to check?

[hedychen]

Hello,
I'm just wondering, is it the "Ascending"/"Descending" option right below "Sort by Expression" that overrides my formula "Match ([Likelihood], 'Low', 'Medium', 'High')"? If so, this option cannot be unchecked, and how could I make sure my formula working as expected?

Heapmap sorting issue

[mikaelsc]

in nov 2020 the option to sort by expression is has been removed... 

more generally, in case of dimensions you want to sort according to their "natural order", i tend to prefer creating dual( ) dimension values: 

create an excel, 2 columns, valueNum and valueText and load dual(valueText,valueNum) as ValueDual

most of time (all?) sorting will happen on num value, but the text value will be used as label. 

[hedychen]

Thank you so much!!  I tried your dual value method, and it worked well for Heatmap sorting.  

The question now is how and where to convert the valueNum to valueText (i.e. to show 'Low', 'Medium', 'High', instead of '1' '2' '3') in Heatmap?  I tried the Text () and Dual () formulas, but not working...

And how to define/customize the Heatmap color, e.g. I want Red in High/High area?

how to convert valueNum to valueText

[mikaelsc · Accepted solution]

you don't use dual for sorting ! you just use the dual value as dimension ! 

colors can be changed in appearance>design

[hedychen]

Thank you so much, truely appreciate it!!