5 Replies Latest reply: Jul 12, 2017 11:32 AM by Sunny Talwar RSS

    Trouble sorting by date

    Tanya Ruppell

      I have loaded data with dates that are only in June.

      I then created a master calendar for the entire year.

      When I graph or chart any of the data, the June data always shows first, instead of in proper chronological order (I am sorting by date).

      Screen Shot 2017-07-12 at 10.51.50 AM.png

      I tried adding a "sortOrder" field to the master calendar, and using it as a sort expression. It resolves the problem when my dimension is individual days (as shown below), but when I try to use month as my dimension, it reverts back to starting with June. Is there some generic fix to make the dates sort chronologically?

      Screen Shot 2017-07-12 at 10.59.22 AM.png