Explore recipe: Comparing today's ticket volume to yesterday's

Return to top

13 Comments

  • Eric Haley

    Hi, I did this, but when I add it to my dashboard and select the brand filter and the date range, the top number turns to 0 and the bottom percentage is 100%, regardless of which brand or month I choose. What am I doing wrong here?

    1
  • Taylor Bowser
    Zendesk Customer Care

    Hi @...

    Thanks for reaching out! Sorry to hear you're running into issues when adding this query to a dashboard. I'm going to pull your request into a ticket so we can get a bit more information about your dashboard set up. 

    Best, 

    0
  • Shanaaz Banks

    Hi, is there any chance that you can compare against a custom target? E.g. yesterday, our CSAT was 92%, and I want to compare it against our company KPI of 95%.

    1
  • Shanaaz Banks

    Any workarounds or additional information about the above? 

    Hi, is there any chance that you can compare against a custom target? E.g. yesterday, our CSAT was 92%, and I want to compare it against our company KPI of 95%.

    0
  • Eric Gao
    Zendesk Customer Care

    Hi Shanaaz,

    You can compare against a custom target by creating a Fixed Calculated Metric (https://support.zendesk.com/hc/en-us/articles/360022366973-Adding-fixed-calculated-metrics#topic_xdd_441_hy), which would essentially act as a constant and can be used in a comparison with the other metrics.

    Warm Regards,

    Eric G. Gao | Technical Support Architect | Zendesk

    0
  • Felipe Vengoechea

    Hello,

    I am trying to find a way to show the variation (Percentage) on %Reopened Tickets Current Week VS Previous Week. I have not been able to get the results. Any help will be appreciated. Thank you.

    0
  • Reddit Support

    Hello Zendesk Team,

    In looking over this article, it seems that listed under Original Metric, Tickets is no longer a valid option. Using Tickets Created as the Original Metric and Ticket Created as Defined On seems to work.

    However, if you wanted to create the same metric for Solved tickets instead of Created tickets, does not seem to work. If you put in Tickets Solved for Original Metric and Ticket Solved for Defined On seems to cause the query to time out, provide no data, or throw an error saying that it exceeded the SQL limits.

    If anyone has suggestions for how to create the same type of queries for Solved tickets, like the above created tickets, please let me know. 

    0
  • Dane
    Zendesk Engineering
    @David,
     
    I have tried the directions on this article and it worked for me without any issue. Please refer to the values I have used and the resulting query.
     

     

     
    If you encountered any issue feel free to contact our Support through Messaging. 
    0
  • Oliver Jackson

    Hi folks, I'm in need of some help if possible please :) 

    I would like to create a table which provides with insight on Tickets Solved (by tag) for the last week, and the previous week respectively.

    Below is where I have got to so far, but it's not really what I'm looking for:


    What I would like is for the first column to display how many tickets tagged in a certain way were Solved Last week (which I think I have achieved), and the second column to display how many tickets (tagged in the same way) were Solved the Previous week (i.e. the week before last). For now, I have simply used another metric. I know that I can create this manually via the date picker, but I was hoping there would be something less manual and more automated to achieve this.

    Also, a VERY welcome bonus would be to also have a third column which illustrates the percentage increase/decrease between the second column and the first.

    Any help would be enormously appreciated! :) 

    Thanks in advance.

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi Oliver Jackson, you should be able to do this by creating two date range calculated metrics, one called Tickets solved last week and one called Tickets solved week before last. For both, set the Original metric field to Solved tickets and the Defined on field to Ticket solved. When it comes time to choose the date range for each one, go to the Advanced tab and:

    • Set the first metric to From the beginning of 1 week in the past and To the end of 1 week in the past
    • Set the second metric to From the beginning of 2 weeks in the past and To the end of 2 weeks in the past

    Add the two metrics you just created in the Metrics panel (make sure you change the aggregator to D_COUNT).

    Then, add the Ticket tags attribute in the Rows panel. If you want to see only certain tags in your report, you can filter on this attribute.

    And finally, to get the percentage change column, go to the Result manipulation menu and select Result metric calculation. In the Formula field, insert your Tickets solved last week metric divided by your Tickets solved week before last metric. Click Add. (For more on result metric calculations, see this article.)

    When you click out of the result metric calculation window, you should see your new column. You can change its formatting by going to the Chart configuration menu and selecting Display format. Next to your % change metric, select Custom and add a Suffix of %

    When you're all done, you should see a report similar to this: 

    1
  • Oliver Jackson

    Erin O'Callaghan 

    Hey Erin! I can't thank you enough for the explanation - so clear and effective. Really appreciate it.

    I have one last hurdle however before the finish line: the data doesn't show me a percentage increase/decrease, but instead it appears to show the difference between the two values:


    If we look at the example above, tech__reinstall_vcplusplus shows 100%, because it's an exact match, but in reality, I would like to display 0.0%.

    With tickets tagged tech__reinstall_or_repair_dotnet, it's showing 94%, when in reality it should show -6%, and the same with auth_issue which should actually say -50% rather than 50%.

    Does that make sense? Hope you can help me with this final brainteaser! :) 

    Thanks again.

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Oliver Jackson Ah, good point! To get the percent increase or decrease, you can use this formula in your result metric calculation instead of the one I described above (just make sure to change the names of the metrics if you named them something different in your environment): 

    (D_COUNT(Tickets solved last week)-D_COUNT(Tickets solved week before last))/D_COUNT(Tickets solved week before last)*100

    You can even go to Chart configuration > Columns and select the Arrow checkbox next to the last column to add a visual indicator of whether the number of solved tickets has increased (green arrow) or decreased (red arrow). 

    1
  • Oliver Jackson

    Erin O'Callaghan Thank you so much for this - all fixed up now! :) 

    Sorry for my delayed response - caught Covid and was off for several days.

    Cheers!

    0

Please sign in to leave a comment.

Powered by Zendesk