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

elois33's avatar
elois33
Helper I
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