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.
10 comments
Maik Künnemann
This does not work correct for us. Some tickets of calendar week 53 / 2020 now added to the end and visible as calendar week 53 / 2021.
1
Taylor Bowser
Hi Malik,
Thanks for reaching out! This is a known issue when reporting with Year and Week of Year over the start of a new year. This is because January 1st and January 2nd fall under Week 53 of 2020 and year 2021.
As a workaround, we recommend creating a custom attribute to use instead of the default Ticket Created - Year. The formula for this custom attribute would be the following:
You can use this custom attribute along with the default Ticket Created - Week of Year attribute to resolve this issue.
Hope this helps!
1
Antonio
Thanks Taylor! I was having the same issue and was driving me insane, thinking I was doing something wrong :)
One question though: is there a way to edit how week numbers are displayed, so instead of "2020 53, 2021 1...", we can see something like ""2020 W53, 2021 W1..." or ""2020 week 53, 2021 week 1..."?
Thanks in advance!
0
James Molina
Is there a way to sort a rolling 6 months so that the most current month is at the far left?
1
Elaine
Hi James,
If you already have the Months under the Columns portion of the attributes in your query, your next steps would be to go into Result manipulation > Sorts and then choose the Z-A option so that you'll see the current month on the left far side of the query. See how I did it on a sample query below:
Hope this helps! :)
0
Kevin Frouin
Hello everyone,
I currently have a view which shows the tickets created in during the last 6 days (including today) but they are ordered as follow
Is there a way to order the days in chronological order (so having the 20th at the top and today's date always at the bottom).
Thanks for your help !
0
Kevin Frouin
Hello,
Found the solution by adding the following columns
Cheers.
0
Alexander King - TechOps Manager
Thank you for posting, this was driving me crazy :/
1
Phil
I am trying to create a report showing tickets created and solved by week. But rather than show the week number on the x axis, I want to show the first date of that week. I have achieved this, but I can't get the dates to sort correctly. What am I doing wrong?
I created a standard calculated attribute that will find all the tickets created/solved and lump them onto the date of the first day of the week. See below:

This then gives me what I want to see, but the dates are not sorted correctly at the bottom even though I selected "Sort like time attribute":
Any ideas? Thanks in advance.
4
Mike DR
The closest solution is to use ordered set: Explore recipe: Using renamed and ordered sets to change displayed values
0