Sorting a heatmap

[CNH_1978]

Hi all,

I am having trouble trying to sort a heatmap. 

I have tried creating an inline table in the script with the sort order defined and i have tried using an expression but it doesn't seem to work. 

The order i would like is the following. 

Field = Impact

order = 

0 hrs
2 hrs
4 hrs
6 hrs
12 hrs
24 hrs
48 hrs
72 hrs
7 days
14 days
31 days

I have attached a QVF, is anyone able to help please?

Note that i also have a pivot table in the example which shows the sorting works as required, i just can't get the same result in a heatmap. 

[sunny_talwar · Accepted solution]

Use this as a calculated dimension in your chart

=Dual(Impact, Alt(If(SubStringCount(Impact, 'hrs') = 1, Num(Interval#(SubField(Impact, ' ', 1), 'h')), Num(Interval#(SubField(Impact, ' ', 1), 'D')))))