Result metric calculationsenable you to add a further calculation to a report you have already taken. For example, if you've created a report to calculate a cost of service for your tickets (seeCalculating estimated cost of servicefor an example), and you want to add a ten percent margin to this, you could use a result metric calculation.
Creating a result metric calculation
To create a result metric calculation
- With an Explore report open, click the result manipulation menu (), then selectResult metric calculation.
- ClickAdd a new metric.
- On theResult metric calculationpanel, enter the name of your metric.
- Enter your formula. For help writing formulas, seeWriting Explore formulas.
- SelectClear used metrics从th隐藏其他指标e report results and only show the result metric calculation. The metrics are still used in the result metric calculation, but the results will not appear in your chart.
- ClickAdd, then close theResult metric calculationpanel. The new result metric calculation is added to the report.
- Your calculation is automatically added to the open report.
- In your report, clickSave.
Example: Calculating the percentage of On-hold tickets
In this example, you'll create a report that shows the total number of tickets, and the number of On-hold tickets for any given year. Then, you'll add a result metric calculation that displays the percentage of On-hold tickets.
Creating the report
To create the report
- In Explore, create a new report using theSupport: Ticketsdataset.
- In theMetricspanel, add the following metrics:
- COUNT(Tickets)
- COUNT(On-hold tickets)
- In theFilterspanel, add the following attribute:
- Ticket created - Year
- From the visualization type menu (), chooseTable.
Explore displays a table showing the total number of tickets and the number of On-hold tickets. You can click theTicket created - Yearfilter to filter your results to specific years.
- Enter a name for the report, then clickSave.
Adding the result metric calculation
To add the result metric calculation
- With an Explore report open, click the result manipulation menu (), then selectResult metric calculation.
- ClickAdd a new metric.
- On theResult metric calculationpanel, enter the name of your metric,Percentage of On-hold tickets.
- Enter the following formula:
COUNT(On-hold tickets)/COUNT(Tickets)
TheResult metric calculationpanel will look like the following example:
- ClickAdd, then close theResult metric calculationpanel. The new result metric calculation is added to the report.
- Next, you need to display the new calculation as a percentage. In the chart configuration menu (), clickDisplay format.
- On theDisplay formatpanel, click the drop-down list next to your metric,SUM(Percentage of On-hold tickets).
- From the list of display formats, choose percentage, (%). The result metric calculation in your report now displays a percentage.
- In your report, clickSave.
14 Comments
I've currently got a table that has two metrics on it and a result metric calculation that computes an SLA for our 30 second or less call answer times. I've been asked to create a sparkline or line chart that looks at the SLA value over time, but every time I try to create a chart it wants to use the metrics for the chart instead of the result metric calculation. Is there any way to hide those other metrics from a chart and only display the result metric calculation?
Hipstraussthanks for asking such a good question. You can select the checkbox at the bottom of the calculation screen to remove the original metrics from the display. It looks like this:
That should then leave only the calculation available for visualization. I hope that helps!
@...- Ah hah! That's brilliant. You're a life saver. Thanks.
Hey!
I am trying to set up a start condition for calculating the response time. For example, I need to count the time since the appearance of a certain tag in the ticket and not since the moment of its creation. What is the best formula to use?
Is it possible to make the Result Metric Calculation display on the secondary axis of a line chart?
Also, can we add Result Metric Calculations to the datatip available fields?
Hello@...and@...
I created for you tickets so I can discuss with both of you what you need to achieve more in detail
You should have receive a notification about it.
Hi there,
I have a metric A and a metric B in my query in absolute numbers monthly and when I add a ratio of them in % using the result metric calculation it's added to the query against the existing axis Y. Because the axis Y is in absolute numbers the ratio metric in % can barely be seen.
Is it possible to add a second axis using the result metric calc function? I know I can create and add a third custom metric with ratio, but wondering if it's possible to do via result metric calculation. Below is the screenshot how it looks
Thanks
Hi Vladimir,
Unfortuantely it's not possible to use a dual axis with Result Metric Calculations. You'll need to create a separate custom metric in order to apply a dual axis.
Warm Regards,
Eric G. Gao | Technical Support Architect | Zendesk
I think I know the answer to this already, but I'm looking to create a dashboard that shows data quarter by quarter.
At the moment all I can show is data from quarters that are already complete. There doesn't appear to be a way to show data dynamically to-date. For instance, can I compare 20 days into Q3 with 20 days into Q2?
I don't want to show the total amount for Q2 and the amount so far for Q3 as you can't make a useful comparison.
Hope that makes sense?
HiMatt,
With the use case that you presented, I think theDate range calculated metricswould help you out on this. You can check the articleAdding time and date calculated metricsregarding this one.
You can use data for a quarter of a year under theAdvanced tabandAdd a repeat patternwithin the calculated metric to compare the current quarter to another quarter of the same year or a different year.
For more information about adding a repeat pattern, you can check the articleEditing dates and date ranges. Hope this helps! :)
Thanks for the reply@...!
I didn't have much luck with the repeat pattern - it seemed to just lump the previous periods' data into the number shown.
Correct me if I'm wrong, but I think by using the two metrics for different quarters I've achieved the result I was looking for?
Hi Guys,
I'm trying to create a query that will measure my team's AVG resolution time for tickets per ticket priority, and struggling with excluding the extreme results (so it will not affect our AVG dramatically).
I created the following metric to filter out the 'pending's from the calc:
Resolution time without pending (Biz - days)
如果不是INCLUDES_ANY (followup_tick(票标签)。et_creation", "closed_by_merge", "closed_by_trigger_blocked_email_channel"))
THEN(VALUE(Full resolution time - Business hours (hrs))-VALUE(Agent wait time - Business hours (hrs)))/24
ENDIF
Finally I got the AVG resolution time per priority, but I found it is not reflecting the reality as few extreme cases are influencing the AVG dramatically.
Therefore, I tried to use the "Results manipulation" -> "Results metric calculation" to filter out values that are too far from the STD_DEV by creating the following metric:
ST_Dev AVG Resulution time
如果不是INCLUDES_ANY (followup_tick(票标签)。et_creation", "closed_by_merge"))
AND VALUE(Full resolution time (min)) < 3* STD_DEV(Full resolution time (min))
THEN
(VALUE(Full resolution time - Business hours (hrs))-VALUE(Agent wait time - Business hours (hrs)))/24
ENDIF
Unfortunately, the Results manipulation metric is not working as expected, and I couldn't find what is wrong, or what is the best way to exclude the tickets with the extreme AVG resolution time from the general AVG.
Please assist me in this one, as it is a crucial report for measuring the team performance.
Best Regards,
Tom
Thanks for reaching out in our community as well by the way.
A ticket was also created from this reply, and as I have also already contacted our Explore team, please refer to my reply on your ticket with me.
Regards,
Have you already tried to refresh your browser and recreate the Result Metric Calculation? Normally this will do the trick if changes are not being saved in Explore.
Pleasesign into leave a comment.