Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
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))
Perfect, thanks Sunny!
Awesome! I was stuck with this issue for quite long time.. Thanks Sunny