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:

       

      barchart_month.png

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

       

      barchart_monthyear.png

      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?

       

      Thanks

      Neil