Forum Discussion
Sort by time
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
You have not shown the expected result. What result are you expecting?
Hello Ashish_Mathur , Thank you for your reply. I don't know how to show you the expected result but I can explain you what I'm trying to achieve and I attached the screenshot bellow.
-I want to sort my martice table by the departure time so I can have the ID sorted by the earliest departure time.
-The second thing is that when I choose a specific itinerary on the slicer on the right, I want to have the same order of this itinerary on my matrice table. For example, when I select Kansas/Colorado and then Colorado/Oklahoma, I want to sort the matrice table by this specific order that the user has chosen.
Thank you very much for your help, I appreciate it. Hope you can figure out a way to solve my 2 weeks problem 😪
Regards,
Elois