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

Return to top
Have more questions? Submit a request

7 Comments

  • John Ritter

    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?

     

    0
  • Devan - Community Manager
    Zendesk Community Team

    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. 

    0
  • John Ritter

    Devan,

    Thank you so much for your help.  It turns out I did have some odd sorting going on and that fixed it.

    0
  • 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
    Zendesk Customer Advocate

    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:

    WEEKYEAR([Ticket Created - Date])

    You can use this custom attribute along with the default Ticket Created - Week of Year attribute to resolve this issue. 

    Hope this helps!

     

    2
  • Antonio Rodríguez Rasero

    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?

    0

Please sign in to leave a comment.

Powered by Zendesk