5 Replies Latest reply: Jan 5, 2015 9:51 AM by Neil Deeley RSS

    Date sorting on bar chart

    Neil Deeley

      Hi there,


      I've created a bar chart which counts orders and is dimensioned by Month & Year.

      If I set the dimension to just year, or just month, the sorting on the chart is fine:



      However, if I add in the year, then it all goes potty:



      I'm creating this date in the load script from a column in oracle:


      MakeDate(left("CREATION_DATE",4),mid("CREATION_DATE",5,2), right("CREATION_DATE",2)) as FormattedCreationDate,


      ..and using this as the dimension:


      Month([FormattedCreationDate]) & '/' & Year([FormattedCreationDate])


      Any ideas what I need to do in order to sort the dates correctly?