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

    Sorting and time dimension

    John Schmidt

      Hi,

       

      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?