Explore recipe: Solved tickets this year compared to last year

Have more questions? Submit a request

6 Comments

  • Bill Cicchetti
    Comment actions Permalink

    Anyone know of a way to stack the lines so current year/month is on top and previous year/month is below it so its easy to compare  2019 month to 2018 month?

    0
  • Ricardo
    Comment actions Permalink

    Hello, Bill,

    If you press the key Command of your keyboard, you are able to select both results and see the two lines in the same query:

    Does that help?

    0
  • Bill Cicchetti
    Comment actions Permalink

    Thanks Ricardo for the feedback.  I forgot about that functionality and it does help a bit.  I still am wondering if there is a way to obtain there results without doing this additional step.

    Thanks again!

    0
  • Ricardo
    Comment actions Permalink

    Ah! You can actually have the query showing both lines by default under Chart configuration > Row selector > Selected position. Choose select all.

     

    1
  • Bobby Koch
    Comment actions Permalink

    Hey team, 

    Is there a way to bring this to the week/daily level?

    I.e., I want to compare last weeks volume to the same (or close enough to the same) week from 2019. 

    I followed this article (which is awesome, btw) and got this far:

    But ideally, we can look at week 1 from 2020 and compare it to week 1 from 2019, but broken down further by the date (or day of the week i.e., 1 -7). Would appreciate any help here!

    0
  • Devan
    Comment actions Permalink

    Hello Bobby Koch,

    You will want to use a time comparison calculated metric to create this type of report to the level of granularity you've described above. 

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk