2 Replies Latest reply: Sep 1, 2017 3:46 AM by stefan kollberg RSS

    Sort Year-Week in graph

    stefan kollberg

      Hi!

      I have a report where data is presented in a graph.

      The time dimention in the graph shows Year-Week, e,g "2017-35".

      This dimention is created in the loading script as " Year &'-'&replace(upper(Week),'W','') as YearWeek "

       

      The problem is that the sorting of 'YearWeek' is not correct as you see in the graph below.

       

      How can this be solved?