22 Replies Latest reply: Mar 13, 2017 8:52 AM by Vikraant Pai RSS

    Date sort order in line chart

    Oscar Marquez

      Hi all, this is driving me crazy :S I've tried everything that came to my mind, I combining 2 years in 1 chart using just month-day as dimension, but I cannot manage to get it sorted correctly, I'm already ordering by date field in load script and sort property in the dimension, but still, the dates not matching. Those at the end happen to be those days that were reported just in one year but not the other, any idea on how to solve this? Thanks in advance!

       

      Dimension: Month([Report Date]) & '-' & Day([Report Date])

       

      Sort: Expression -> [Report date]

       

      I've also tried to create the dimension as text in load script and sort by load order but I'm getting the same result.

      Capture.JPG.jpg