Is there a way to sort a table by a field that isn't in the table columns? I'm trying to sort time information chronologically like this:
1:00 AM
2:00 AM
…
12:00 PM
1:00 PM
But Domo sorts it like this:
1:00 AM
1:00 PM
2:00 AM
2:00 PM
etc.
I can have the time displayed as 24-hour but I'd rather not if possible.