2 Replies Latest reply on Aug 26, 2018 4:40 PM by elias.daniels.0

    Time Axis dynamically sorted by field.

    elias.daniels.0

      Hi guys,

       

      I'm reaching again for some knowledge.

       

      I was wondering if is possible to sort time axis based on a field.

       

      For example, in the attached workbook you will see I have  2 classrooms, with different booking times. And, another layer of subjects and status.

       

      My main concern is that for "Class2" that start from 6pm to 2 am, I need to manually rearrange the axis from 6pm to 2 am. Other wise it will show 2 am before 6pm.

       

      I know that if I drag the time dimension into columns, this will sort the axis, but including the day number.

       

      In my case I want to have all 6pm one above another one, no separate them by day.

       

      Let me show you:

       

       

      Sheet (Night)

       

      If I drag the time into columns (which I dont want) (Sheet Night (2))

       

       

      Do you think guys, I can sort the axis by the field Start date?

       

      So, if I choose Class 1, automatically sort from 10 am. And if I choose class2 from 6pm onward?

       

      Thanks in advance,

       

      Elias