I have a dataset, for example, with 3 events in each of the US time zones -- all coming through as 7pm local to the time zone in the dataset.
I need to sort them by the time occurring, so in the example below, California events would be listed first, then Colorado, then Chicago, then New York.
How can i do this? Can I do it in a beast mode?
Event 1, California, 7PM
Event 2, California, 7PM
Event 3, California, 7PM
Event 4, New York, 7PM
Event 5, New York, 7PM
Event 6, New York, 7PM
Event 7, Colorado, 7PM
Event 8, Colorado, 7PM
Event 9, Colorado, 7PM
Event 10, Chicago, 7PM
Event 11, Chicago, 7PM
Event 12, Chicago, 7PM
Thanks!