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

Display month values in chronological order

Yes, you can display month values in chronological order. By default, Explore sorts the values of the month attribute starting with January and ending with December. This allows you to look at monthly trends year by year.

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

To shorten month values, go to Chart configuration ( ) > X axis and set Truncation (characters) to 8.

To sort 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 Creating reports.