# App Development

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Contributor III

## Match Sort Order

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!

Labels (1)
• ### Match

1 Solution

Accepted Solutions
MVP

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))``
3 Replies
MVP

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))``
Contributor III
Author

Perfect, thanks Sunny!

Contributor III

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

Tags
Community Browser