This content has been marked as final. Show 4 replies
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.