Match Sort Order

[c_latham]

Hi All,

I have a dimension of 'Hour' which is an expression: hour(t_put)

I want to set the order of this dimension to be:

22,23,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21

So I used the following on the sort order:

Match(hour(t_put),'22','23','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21')

However, I am getting a sporadic order which doesn't look like I expect.

Can anyone advise on what I have done wrong?

Thanks!

[sunny_talwar · Accepted solution]

Can you try this

Only({1} Match(Hour(t_put), 22, 23, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21))

[c_latham]

Perfect, thanks Sunny!

[mahendrankr]

Awesome! I was stuck with this issue for quite long time.. Thanks Sunny