Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks a ton Marco!
you're welcome
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.