How to Sort Time bucket?

[Anonymous]

Hi All,

I have a trend line chart. and I would like to sort this chart by the time bucket filed which I created.

I calculate the Time Bucket field as follows:

Time(frac([Date]),'h tt') & ' - ' & Time(frac([Date]) + maketime(1,0,0),'h tt') as TimeBucket

How do I sort this field? so that it shows the data in the right format eg: 5 am - 6 am, 6 am - 7 am, 7 am - 8 am and so on.

[Anonymous]

Thanks a ton Marco!

[MarcoWedel]

you're welcome

[Anonymous]

Hi Marco,

Thank you for your previous comments on my question. I had one more query regarding the timebucket. I have one Region filter in my dashboard. I wanted to know if a end user selects for eg: APAC region. He needs to see the data as per the local time of APAC region. How can that be achieved. I basically want to show email responses are highest or lowest per time as per the region.