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.
3 Comments
I'm having the same problem but this solution didn't work for me. For some reason September and October are swapped in order. Any suggestions?
Hello John Ritter,
The chart you displayed might be sorted by the light blue value metric in this instance. I would start by checking the Result Manipulation > Sort option and see if it is set as "A to Z.
Best regards.
Devan,
Thank you so much for your help. It turns out I did have some odd sorting going on and that fixed it.
Please sign in to leave a comment.