Explore recipe: Calculating estimated cost of service

Return to top

8 Comments

  • Sarah Pham

    Hi, if i dont have the time tracker app and still use this recipe what exactly will the report show?

    0
  • Taylor Bowser
    Zendesk Customer Care

    Hi Sarah, 

    This recipe will only work if you're using the Time Tracking App as the formulas pull data from the custom fields that are populated by the app. 

    The Zendesk Time Tracking app must be installed, and must have collected data

    Note: The time tracking app stores data in custom numeric fields that are synchronized with Explore. If you have installed the Time Tracking app recently, the data required to build necessary calculated metrics might not yet be synced with Explore. This sync occurs once an hour.
     
    Best, 
    0
  • Sarah Pham

    Thanks Taylor, i have created the query as per above without knowing the time tracking app is required. It still gives me output, are you able to advise what data I am looking at?

    0
  • Taylor Bowser
    Zendesk Customer Care

    Hi @...

    I'm going to open a ticket on your behalf so we can take a closer look at the report you've set up. 

    Best, 

    0
  • Enrick Neil (NRCK)

    In the Metrics - should I use Average? AVG? 

    0
  • Marco Malbas
    Zendesk Customer Care
    Hi Enrick, that's a good question. Based on the formula being straightforward, I would suggest using SUM which is what it would default to. Cheers! 
    0
  • Enrick Neil (NRCK)

    I don't think SUM is correct. Using this formula and using SUM in Metrics gives 3 digit number results per agent. 

    This formula computes the cost per ticket right? based on their hourly cost. 

    Do we use AVG?

    0
  • Marco Malbas
    Zendesk Customer Care
    Thanks for replying, Enrick. I think you're right. I was thinking that since the formula already had "/3600*(your hourly rate)" then using SUM would be enough, but it might result to adding the Total Time spent altogether. So yes, you will be using AVG. Thanks for the catch! 
    0

Please sign in to leave a comment.

Powered by Zendesk