topic Re: Match Sort Order in App Development

Match Sort Order

c_latham — Sat, 16 Nov 2024 03:01:45 GMT

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 — Tue, 10 Mar 2020 16:09:08 GMT

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 — Tue, 10 Mar 2020 16:12:07 GMT

Perfect, thanks Sunny!

mahendrankr — Wed, 09 Jun 2021 12:42:16 GMT

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