Adding fixed calculated metrics

Return to top

11 Comments

  • Gökhan Cicek

    How can I create a chart which compares the average weekly ticket solved by an individual agent vs. the average of the all team. This should be basically a time series chart includes two lines: individual agent solved ticket vs. average of all agents solved tickets.

    0
  • Hannah Meier
    Zendesk Customer Care

    Hello @...,

    The best way to create an average like this is by using the ATTRIBUTE_ADD function that is part of the Explore aggregate functions EAP. 

    Here are some links about the EAP:

    0
  • Gökhan Cicek

    This one is not available for me. I have signed up for the EAP. How long does it take to be included?

    0
  • Devan - Community Manager
    Zendesk Community Manager

    Hello Gokhan,

    I've gone ahead and pulled this into a ticket so one of our experts can look into this for you. You should receive an email followed by a response relatively soon. 

    Best regards. 

     

    0
  • Leopoldo Villasana

    Hi There! 

    We have our Organizations divided into groups in Zendesk. If we wanted to show the total number of Organizations per group shown in Queries in a fixed way (so that the number doesn't change when we select date ranges, for example), would that be possible?

    1
  • Nicholas von Zenjob

    Hello. I am trying to create a result metric calculation which multiplies Full Resolution Time by Solved Tickets. 

    I enter the name, the formula "SUM(MED(Full resolution time (min))*SUM(COUNT(Solved tickets)", but the option to +ADD stays greyed out. I've also tried "SUM(MED(Full resolution time (min))SUM(COUNT(Solved tickets)"

    What's the proper syntax for multiplying?

    0
  • Elaine
    Zendesk Customer Care

    Hi Leopoldo,

    I remember you reached out via a ticket previously and I was able to answer you from there. Hope I cleared this one out. Cheers! :)

    0
  • Elaine
    Zendesk Customer Care

    Hi Nicholas,

    I think the article Using result metric calculations will better guide you regarding your concern.

    I tried to do a raw formula based on what you mentioned and this is how it looked like on my end:

    I'm not totally sure though if that's what you're trying to achieve.

    You can also check Explore functions reference which lists all available functions or syntax in Explore and how to use them. Hope I was of any help. :)

    1
  • Nicholas von Zenjob

    Thank you! This has pointed me in the right direction. 

    0
  • elzbieta.petryka

    Hi, I try to create "fixed calculated metric" which will be also "date range metric". 

    Scenario: I would like to track % of One-Touch tickets and compare the score to the % of One-Touch tickets for 2021:

    I would like to:

     

    1. The top value to change depending on the period of time I am selecting in tab filters AND

    2. The bottom value to be based on the fixed result for 2021 

    My problem now is that 1. works correctly but 2. does not. The base for Bottom value also change when filter change.

    Scenario 2: I have chosen a time filter to show the result for Today:

    1. Top result is correct.

    2. Bottom result is incorrect. Instead to compare Today result to fixed 2021 result, it change a base forr the bottom metric according to the filter. So of course there is 0% difference between Top and the bottom score.

    Is there a way to disable time filter for bottom metric?

     

    0
  • Elaine
    Zendesk Customer Care

    Hi Elzbieta,

    I'll need to take a closer look into your query where you're trying to create a fixed calculated metric so I can properly provide you a resolution for the scenarios you have mentioned.

    I've gone ahead and created a ticket on your behalf. Kindly lookout for an email notification. Cheers! :)

    0

Please sign in to leave a comment.

Powered by Zendesk