Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi Mark,
YOu display Jan, feb on X Axis.. but in Sort tab (chart properties) -- there is expression box. Select it
and say = Monthnum ascending.
SO it will always disply
Jan Feb Mar in youe X axis.
hi Mark,
Create a Monthnum field as below
date(date#(SUBSTRING(CONVERT(VARCHAR(11), DateCreated, 113), 4, 3),'MMM'),'MM') AS MontNum,
this will give output as 01,02,03.
Now go to Sort tab in Chart and in Expression =MontNum;
I hope this helps.
I already have a CreatedMonth field that stores the numeric equivalent for each month and I can use this to display 01 02 03.... along the x-axis but I'd like to display Jan Feb Mar...... I just can't see how I do that with the sorting or formating options .
hi Mark,
YOu display Jan, feb on X Axis.. but in Sort tab (chart properties) -- there is expression box. Select it
and say = Monthnum ascending.
SO it will always disply
Jan Feb Mar in youe X axis.
Thanks...thats it working now.