Forum Discussion
Syndicate_Admin
Administrator
AdministratorArray object, order of a custom column
Hello everyone,
I have a visual object where I place whole numbers (hours, no minutes) ranging from 0, 1, 2, 3...22, 23 (24 hours a day).
In a matrix I show what occurred each hour:
| Hour | Item1 | Item2 |
| 0 | 10 | |
| 1 | 5 | 20 |
| 2 | 30 | |
| 3 | 20 | |
| 4 | 20 | |
| 5 | 22 | |
| 6 | 5 | 15 |
| 7 | 16 | |
| 8 | 10 | 10 |
| 9 | 30 | |
| ... | ||
| 21 | 10 | 10 |
| 22 | 10 | |
| 23 | 10 |
But I want the order of the "Time" column to start from 6 (time that starts the shift tomorrow) and end at 5, it would be something like this:
| Hour | Item1 | Item2 |
| 6 | ||
| 7 | ||
| 8 | ||
| .... | ||
| 22 | ||
| 23 | ||
| 0 | ||
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 |
How can I make that poersonalized order since from the format of the visual object I can not do it (or can I?)
Thanks a lot
1 Reply
Syndicate_AdminIt was easier than I thought...
I generated a conditional column and with the option "sort by column" I sort the time column according to a personalized numbering of the column I added