Question
I have added a month attribute to my report but it is not sorted correctly. Can I display the month values in chronological order?
Answer
By default, Explore sorts the values of the month attribute 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.
If you want to sort the columns in reverse chronological order, go to Result manipulation (
) > Sort > Z-A. This way the most recent results come first.
For more information about building and customizing reports, see the article: Creating reports.