Month order in Chart

[#1]

Hi,

In Chart ( x-Axis) ,how to order the month in the order Jan,Feb,Mar for a year.Right now the chart show month in random order.

[simondachstr]

Go to sort and Sort by an expression like:

=Month(Date#(MONTH,'MMM'))

[maleksafa]

you have multiple options:

1) when loading the calendar table where you have the month names, add another field which is the number order, and in the chart sort by this number

2) when loading the month names load it as dual function with a number for sorting and in the chart sort by month name as numeric value

3) in your chart sort by expression, match(MonthName,'Jan','Feb','Mar','Apr'....)

[#4]

Hi Martin ,

Thanks for the reply.

I have solved this in loading script using "Month(date) " conversion for date field & set the sequence for month.

[#5]

Hi Malek,

Second option solved the query.