12 Replies Latest reply: Apr 17, 2017 3:31 AM by Ajinkya Bhonsle RSS

    How to Sort Time bucket?

    Ajinkya Bhonsle

      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.