13 Replies Latest reply: Feb 15, 2017 6:41 AM by Vineeth Pujari RSS

    Sorting and time dimension

    John Schmidt



      i have a sorting problem.


      I have a time dimension/table drilled down to the following for the year 2000-2020: year, month, week, day, hour.

      For sorting i have another field DATEID with the following format: YYYYMMDDHH.


      Now i have a simple bar chart where i sum up a value over each hour of the current day.

      The sorting works fine - i put a sorting using the formualr over the field DATEID.


      However, if i do a bar chart where a put the months on the x-axis the sorting doesnt work anymore.

      I dont understand the problem to be honest.


      Can somebody help me out or give some advice?