How can I sort months in chronological order in my queries?

Question

I have added a month attribute to the query but it is not sorted correctly. Can I display the month values in chronological order?

Answer 

By default, the month attribute values are sorted starting with January and ending with December. This allows looking at the monthly trends year by year.

In certain cases, you might need to display the month values in chronological order, for example, when you look only at the data for the past few months. To order the month values accordingly place the corresponding year attribute before the month attribute.

If you want to shorten the month values go to Chart configuration () > X axis and set the Truncation (characters) to 8.

For more information about building and customizing queries, see Creating queries.