3 Replies Latest reply: Jan 4, 2016 7:55 AM by Pekka Laaksonen RSS

    Problem with 53rd week

    Pekka Laaksonen

      Hi,

       

      I have a chart in my app which has weeks as a time dimension. 2015 had 53 weeks and week 53 spans the end of 2015 and beginning of 2016. Now, the weeks in 2015 are sorted correctly (49,50,51.. etc.) but the weeks in 2016 are not. Week 53, which in this case is before the first week of the year should come first:

       

      Capture.PNG

       

      How can I sort the time dimension so that the weeks appear in correct order? In addition, this would also cause problems if year 2016 would have 53 weeks. Luckily it doesn't, but is there something I could do to handle these kind of exceptions correctly?