4 Replies Latest reply on Oct 12, 2016 3:06 AM by hanneke.vankeep

    Sorting weeks in YoY chart

    hanneke.vankeep

      Hi!

      I am making a line chart showing YoY growth per week.

      To calculate the YoY growth I used the following calculated field:

      (ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

       

      However, I run into a problem when I make the linegraph.

      My data starts at week 44 2014, which it compared to week 44 2015. This goes all the way to week 30 2015/2016.

      When I make the linegraph, it starts with week 1 (comparing 2015/2016) all the way to week 30 (2015/2016) then there is a jump and it continues to week 44 (2014/2015) until week 53.

       

      I would like to have the graph start at 44 and end at 30, but if I include the year, my calculated field does not work anymore.

       

      Is there a way to manually "sort", the weeknumbers on the x-axis? Or another way to solve this?

       

      Thanks!