I have added a month attribute to the query but it is not sorted correctly. Can I display the month values in chronological order?
By default, the month attribute values are sorted starting with January and ending with December. This allows you to look 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 the article: Creating queries.