4 Replies Latest reply: Mar 24, 2011 7:59 AM by Mark Boomer RSS

    Displaying months on the x-axis

      I cannot seem to get a way to display months of the year along the x-axis.

      When loading the data I extract the month from the date,

       

      SUBSTRING(CONVERT(VARCHAR(11), DateCreated, 113), 4, 3) AS DateCreatedMMM,

       



      so I have a field that holds the month e.g. Jan, Feb, Mar, etc

      If I use the DateCreatedMMM field as the dimension for the graph, how do I get the months to always display in the order, Jan, Feb, Mar, Apr etc and not be sorted into different orders.

      I tried formatting the field in the Document properties as DATE with a format of MMM but I still sometimes get the months out of order on the x-axis...depending on the values calculated for each month.