Forum Discussion

elois33's avatar
elois33
Helper I
3 years ago
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...
Need Help
  • elois33's avatar
    elois33
    3 years ago

    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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Sharing a screenshot does not help at all.  Share a dataset to work with (a table that can be pasted in MS Excel) and on that data, show the expected result.