Forum Discussion
Solved
Sort by time
Hello, How can I sort my martice table by hour, starting from the earlieast departure time for each "id bus" Here is an example of my data in Excel. I already tried right click, sort by depar...
Hello all,
I found a solution for this and it seems to be the right one for now, so I am sharing it with you in case somebody has the same issue .
-To sort by time, I created a new column where I turned hour into second, I added it to my visual, I selected sort by second and then I hide it from my table.
-To sort my table by geographical order, I created a new column where I multiplied longitude x latidude, I added to my table and I sorted by the result of this new column.
Thank you all for your time and help
Kind regards,
Elois
