This article provides definitions for metrics and metric filters for creating Insights reports. For more information on Insights, see Insights resources. For information on other reporting objects, see Insights object reference. Insights and custom reporting is available on Professional and Enterprise. When creating your report, metrics are found in the 'What' panel. After selecting a metric, you can view its MAQL definition in the 'Detail' panel. In the table below, the 'How it's calculated' column gives a simplified version of the MAQL definition.
The article contains the following sections:
Tickets
You can use the metrics defined in this section to report on your tickets.
Ticket metrics
The metrics below are located under the Tickets folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # Assignee Stations | The number of agents a ticket has been assigned to. | Assignee is not the current assignee
Increment assignee stations by 1. |
| # Incidents | The number of tickets where the ticket type is 'Incident'. | The count of ticket IDs WHERE ticket type is Incident AND deleted tickets are not included. |
| # One-touch Tickets | The number of tickets that were solved in one-touch (one reply). | The number of solved tickets WHERE the average number of replies BY ticket ID is less than or equal to one. |
| # Open Tickets | The count of tickets that are not in solved or closed statuses. | The count of ticket IDs WHERE ticket status is not Solved, Closed, or Deleted. |
| # Problems | The number of tickets where the ticket type is 'Problem'. | The count of ticket IDs WHERE ticket type is Problem AND deleted tickets are not included. |
| # Reopens | The number of ticket reopens during the selected time period. | The sum of ticket reopens WHERE deleted tickets are not included. |
| # Reopens [Avg] | The average number of ticket reopens. | The average ticket reopens WHERE deleted tickets are not included. |
| # Replies | The number of public agent comments on tickets during the selected time period. | The sum of ticket replies WHERE deleted tickets are not included. |
| # Replies [Avg] | The average number of replies on a ticket.
If there is more than one reply on a ticket, each reply will be counted. |
The average of ticket replies WHERE deleted tickets are not included. |
| # Solved Tickets | The number of solved or closed tickets. | The number of tickets WHERE ticket status is Closed. |
| # Tickets | The total number of tickets. | The count of ticket IDs determined by ticket tag IDs WHERE deleted tickets and tickets with a delete flag are not included. |
| # Unsolved Tickets | The number of unsolved tickets. This includes tickets in every status except Solved and Closed. | The number of tickets WHERE ticket status is not in Solved or Closed. |
| Ticket Age (days) [AVG] | The average age of tickets. | The average number of days between the ticket created date to the present BY ticket ID WHERE deleted tickets are not included. |
| Ticket age (days) [MAX] | A ticket's lifespan from the creation date to the close date. | The max age between ticket created date to the present BY ticket ID WHERE deleted tickets are not included. |
| Ticket Age (Open Tickets) | The age of tickets not in the Deleted, Solved, or Closed statuses. | The max age between the ticket created date to the present BY Ticket Id WHERE ticket status is not Solved, Deleted, or Closed. |
| Current backlog | The current number of tickets that are not in the Solved or Closed status. This includes New, Open, Pending, and On-hold. | The count of ticket IDs WHERE ticket status is not Solved, Closed, or Deleted. |
| # Backlog Tickets | The number of backlog tickets. This is the total number of backlog tickets throughout history.
Note: This metric is located in the Backlog folder.
|
The sum of the backlog ticket count. |
User and organization metrics
The metrics below are located under the Users and Organizations folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # End-Users | The number of total end-users. | The count of users WHERE the user is active AND the user role is end-user. |
| # Organizations | The number of organizations. | The count of organizations WHERE deleted organizations are not included. |
| # Users | The number of active users. | The count of users WHERE the user is active. |
| Days Since Last Log-in | The number of days since an agent or user last logged-in. This is calculated from their last log-in date, not from the last time they used Zendesk Support to the present date. | The last date the user logged in BY user WHERE the user is active. |
Events
You can use the metrics described in this section to report on your different ticket events.
Ticket event metrics
The metrics below are located under the Ticket Events folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # Group Reassignments | The number of tickets reassigned to a different groups. | The number of ticket updates WHERE the text field change is group AND deleted tickets are not included. |
| # Tickets Created | The number of tickets created (received) in the selected time period or as a total amount. | The count of ticket IDs determined by ticket text field change WHERE the beginning date is the ticket created date BY ticket ID AND deleted tickets are not included. |
| # Tickets Deleted | The number of deleted tickets | The number of ticket updates WHERE the text field is status AND the new text field status value is deleted. |
| # Ticket Events | The number of events or changes to a ticket's system fields and text fields. | The count of ticket text field change WHERE deleted tickets are not included. |
| # Tickets Reopened | The number of tickets where the ticket status was Solved, and then reopened into a new unsolved status. | The count of ticket IDs determined by ticket text field changes WHERE the text field is status AND the new text field status value is Open, Pending, Hold AND previous text field status value is Solved AND deleted tickets are not included. |
| # Ticket Updates | The number of ticket updates during the selected time period.
This metric does not count updates that consist only of a comment and/or numeric field changes. |
The count of ticket updates determined by ticket text field change. |
| # Tickets Solved | The number of tickets marked as Solved | The count of number of tickets |
| [GeoChart] # Tickets Created | The number of tickets created displayed in the GeoChart widget. | The number of tickets created WHERE _Filter Event Dates filters the created date to the dashboard timeline. |
Ticket comment metrics
The metrics below are located under the Ticket Comments folder in Insights
| Metric | Definition | How it's calculated |
|---|---|---|
| # Private Comments | The number of private comments on tickets. | The number of total comments WHERE public comments are not included (false). |
| # Public Comments | The number of total public comments on tickets. | The number of total comments WHERE public comments are included (true). |
| # Total Comments | The total number of both public and private comments on tickets. | The count of tickets updates WHERE tickets are flagged with a comment AND deleted tickets are not included |
Time-based events
You can use the metrics described in this section to report on your different time related events.
Note: For business hours (Biz Hours) metrics, you must set business hours within Zendesk Support. For more information on setting business hours, see Setting your schedule with business hours and holidays.
Time metrics
The metrics below are located under the Time Based folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| Agent Wait Times (hrs) [Mdn] | The median hours tickets spend in the Pending status.
If a ticket returns to Pending multiple times, all hours will be recorded. |
The median agent wait time (in minutes) divided by 60 WHERE deleted tickets are not included. |
| Duration Since Last Change [Text Field] (hrs) | The median amount of time since a change was made to a ticket's text field or system field. | The sum of the text field duration (in minutes) divided by 60 WHERE deleted tickets are not included. |
| Periodic Update Time (hrs) [Mdn] | The median hours required between agent comments. | The median periodic update time |
| Periodic Update Time (min) [Mdn] | The median minutes | |
| First Reply Time (hrs) [Mdn] | The median hours before a first reply is made on a ticket. | The median first reply time (in minutes) divided by 60 WHERE deleted tickets are not included. |
| First Reply Time (min) [Mdn] | The median minutes until a ticket's first reply. This includes all minutes, not just business hours. | The median first reply time (in minutes) WHERE deleted tickets are not included. |
| First Resolution Time (hrs) [Mdn] | The median hours before a ticket is first resolved. | The median first resolution time (in minutes) divided by 60 WHERE deleted tickets are not included. |
| First Resolution Time (min) [Mdn] | The median minutes until a ticket is first resolved. | The median first resolution time (in minutes) WHERE deleted tickets are not included. |
| Full Resolution Time (hrs) [Mdn] | The median hours before a ticket is fully resolved. | The median full resolution time (in minutes) divided by 60 WHERE deleted tickets are not included. |
| Full Resolution Time (min) [Mdn] | The median minutes until a ticket is fully resolved. | The median full resolution time (in minutes) WHERE deleted tickets are not included. |
| Fast First Resolution (<2 hrs) | The number of tickets that were first resolved in less than two hours. | The number of solved tickets WHERE the sum of first resolution time (in minutes) divided by 60 BY ticket ID is less than 2. |
| Normal First Resolution (<8 hrs) | The number of tickets first resolved in less than eight hours. | The number of solved tickets WHERE the sum of first resolution time (in minutes) divided by 60 BY ticket ID is between 2 and 8. |
| Slow First Resolution (>8 hrs) | The number of tickets that were first resolved in more than eight hours. | The number of solved tickets WHERE the sum of first resolution time (in minutes) divided by 60 BY ticket ID is greater than 8. |
| Hold Time (hrs) [Mdn] | The median hours tickets spend in the On-hold status. | The median On hold time (in minutes) divided by 60 WHERE deleted tickets are not included. |
| Requester Wait time (hrs) [Mdn] | The median hours a ticket spends in the New, Open, and On-Hold statuses. This value is only measured after a ticket status is changed from New/Open/On-hold to Pending/Solved/Closed. | The median requester wait time (in minutes) divided by 60 WHERE deleted tickets are not included. |
Business hours metrics
The metrics below are located under the Business Hours folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| [Biz Hrs] Agent Wait Time (hrs) [Mdn] | The median hours tickets spend in the Pending status within your set business hours.
If a ticket returns to Pending multiple times, all hours will be recorded. |
The median agent wait time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
| [Biz Hrs] First Reply Time (hrs) [Mdn] | The median hours before a ticket is first replied to publicly within your set business hours. | The median first reply time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
| [Biz Hrs] First Resolution Time (hrs) [Mdn] | The median hours before a ticket is first resolved within business hours. | The median first resolution time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
| [Biz Hrs] Full Resolution Time (hrs) [Mdn] | The median hours until tickets are fully resolved within your set business hours. | The median full resolution time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
| [Biz Hrs] On Hold Time (hrs) [Mdn] | The median hours tickets spend in the On-hold status within your set business hours. | The median On hold time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
| [Biz Hrs] Agent Wait Time (min) [Mdn] | The median number of minutes a ticket spends in the Pending status within your set business hours. | The median agent wait time (in minutes) within business hours WHERE deleted tickets are not included. |
| [Biz Hrs] First Reply Time (min) [Mdn] | The median minutes before a ticket's first reply within your set business hours. | The median first reply time (in minutes) within business hours WHERE deleted tickets are not included. |
| [Biz Hrs] First Resolution Time (min) [Mdn] | The median minutes before tickets are first resolved within your set business hours.
A ticket can have only one first resolve time, and it will never change. |
The median first resolution time (in minutes) within business hours WHERE deleted tickets are not included. |
| [Biz Hrs] Full Resolution Time (min) [Mdn] | The median minutes until a ticket is fully resolved within your set business hours.
If tickets are reopened, the time will be recalculated until a ticket returns to Solved. |
The median full resolution time (in minutes) within business hours WHERE deleted tickets are not included. |
| [Biz Hrs] On Hold Time (min) [Mdn] | The median number of minutes a ticket spends in the On-hold status within your set business hours. | The median On hold time (in minutes) within business hours WHERE deleted tickets are not included. |
| [Biz Hrs] Requester Wait Time (hrs) [Mdn] | The median hours a ticket spends in the New, Open, or On-hold statuses during business hours.
This value is only measured after a ticket's status is changed from New/Open/On-hold to Pending/Solved/Closed. |
The median requester wait time (in minutes) within business hours divided by 60 WHERE deleted tickets are not included. |
Service Level Agreements (SLAs)
You can use the metrics described in this section to report on your Service Level Agreements (SLAs). These metrics are located under the Ticket SLAs folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # SLAs Achieved | The number of tickets where a service-level agreement was achieved. | The count of all ticket SLAs WHERE the SLA metric status is achieved AND deleted tickets are not included. If null replace with 0. |
| # SLAs Breached (Total) | The total number of tickets that surpassed the SLA's target time. | SLA metric status is breached (active) AND deleted tickets are not included. If null replace with 0. |
| # SLA tickets | The number of tickets with an SLA policy applied. | The count of tickets IDs determined by the number of all ticket SLAs. |
| % Achieved | The percentage of tickets where the SLA policy was achieved out of the total number of both breached and achieved. | The number of SLAs achieved divided by the number of SLAs breached (total) added to the number of SLAs achieved. |
| % Breached | The percentage of tickets where the SLA metric breached its target divided by total number of instances where that SLA metric was measured. | The number of SLAs breached divided by the number of SLAs achieved (total) added to the number of SLAs breached. |
| SLA Breach time [Mdn] | The median amount of time the SLA metric surpassed the target time. | The median SLA metric value minus SLA metric target WHERE SLA metric status is breached (active) or breached (fulfilled). If null replace with 0. |
| SLA Metric Target [Median] | The median target time (in minutes). | The median SLA Metric Target. If null replace with 0 |
| SLA Metric Value | The median amount of time (in minutes) the metric was active. | The median SLA Metric Value. If null replace with 0. |
Surveys
You can use the metrics described in this section to report on your Net Promoter Score℠ (NPS® ) and customer satisfaction survey results.
NPS® survey metrics
The metrics below are located under NPS® Survey folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # NPS® Deliveries | The number of NPS surveys delivered. | The count of NPS delivery IDs by the NPS recipient ID. |
| # NPS® Detractor Ratings | The number of NPS ratings that received a score of 6 or less. | The number of NPS responses WHERE NPS rating is 0, 1, 2, 3, 4, 5, or 6. |
| # NPS® Passive Ratings | The number of NPS survey responses with a 7 or 8 rating. | The number of NPS responses WHERE NPS rating is 7 or 8. |
| # NPS® Promoter Ratings | The number of NPS ratings with a 9 or 10. | The number of NPS responses WHERE NPS rating is a 9 or 10. |
| # NPS® Recipients | The number of recipients that received a NPS survey. | The count of NPS recipients IDs. |
| # NPS® Responses | The number of NPS survey responses received. | The count of NPS recipients ID WHERE NPS rating is not 11. |
| % NPS® Detractors | The percentage of NPS surveys with a 6 or less rating out of the total number of NPS survey responses. | The number of NPS detractor ratings divided by number of NPS responses. |
| % NPS® Passives | The percentage of NPS® surveys with a 7 or 8 rating out of the total NPS survey responses. | The number of NPS passive ratings divided by the number of NPS responses. |
| % NPS® Promoters | The percentage of NPS ratings that received a 9 or 10 out of the total number of NPS responses. | The number of NPS promoter ratings divided by NPS responses. |
| % NPS® Response Rate | The percentage of NPS survey responses out of the total number of users who received NPS surveys. | The number of NPS responses divided by NPS Recipients |
| Median NPS Rating | The median NPS rating during the selected time period.
If no time attribute is selected, the metric displays your median NPS rating so far. |
The median NPS rating. |
| Net Promoter Score℠ | The overall Net Promoter Score. | The percentage of Net Promoters (if null replace with 0) minus the percentage of Net Detractors (if null replace with 0) multiplied by 100 WHERE NPS deliveries is greater than 0. |
Satisfaction survey metrics
The metrics below are located under the Satisfaction Surveys folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # Satisfied | The number of good satisfaction survey responses. | The count of ticket IDs determined by satisfaction survey change (if null replace with 0) WHERE the new satisfaction value is good AND deleted tickets are not included AND ticket status is Solved or Closed. |
| # Satisfaction Change | The number of satisfaction survey responses that changed to bad or good. | The count of ticket IDs determined by satisfaction survey change (if null than replace with 0) WHERE the new satisfaction value is Bad or Good AND deleted tickets are not included AND Ticket status is Solved or Closed. |
| # Satisfaction Offered | The number of satisfaction surveys offered when the ticket is in the Solved or Closed status. | The count of ticket IDs determined by satisfaction survey change WHERE ticket status is Solved or Closed AND ticket satisfaction score is Bad, Good, or Offered. |
| # Satisfaction Responses | The total number of satisfaction responses. | The count of ticket IDs determined by satisfaction survey change WHERE ticket satisfaction score is Bad or Good AND deleted tickets are not included AND ticket status is Solved or Closed. |
| # Unsatisfied | The number of surveys with a bad satisfaction response. | The count of ticket IDs determined by satisfaction survey change WHERE ticket status is Solved or Closed AND ticket satisfaction score is bad. |
| % Dissatisfaction Score | The percentage of dissatisfied survey responses out of the total satisfaction survey responses received. | 1 minus (the number of satisfied responses divided by the number of total satisfaction survey responses). |
| % Satisfaction Response Rate | The percentage of satisfaction surveys responded to out of the total satisfaction surveys offered. | The number of satisfaction responses divided by the number of satisfaction surveys offered. |
| % Satisfaction Score | The percentage of good satisfaction responses out of the total satisfaction survey responses. | The number of satisfied responses divided by the number of satisfaction responses changed. |
Calls
You can use the Calls metrics to report on your Zendesk Talk conversations. These metrics are located under the Calls folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| Call Hold Time [Sum] | Total call time on hold | Sum aggregation of the 'Call Hold Time' fact |
| Wrap up [Sum] | Total time in wrap-up | Sum aggregation of the 'Call Leg Wrap Up Time' fact |
| Time spent in IVR | Total time customers spend in IVR before making a selection and being routed to an agent based on their selection | Max aggregation of 'Time spent in IVR' fact |
| # Accepted Calls | The number of calls agents accepted. Does not include calls that agents have missed or declined. | If the Call Leg does not exist, then the Record of Calls values are counted where the call is inbound, the call leg status is completed, and the call leg type is agent. |
| # Missed Calls | Number of calls an agent missed. | Similar to # Accepted Calls, but call leg status is missed. |
| # Declined Calls | Number of calls an agent declined | Similar to # Accepted Calls, but call leg status is declined. |
| # Calls abandoned | Total number of calls where a customer hung up while waiting to talk with an agent. | Number of calls where the call completion status is abandoned in queue, IVR, voicemail, or on-hold. |
| # Calls abandoned in voicemail | Total number of calls where customer hung up after being sent to voicemail | Number of calls where the call completion status is abandoned in voicemail |
| # Calls abandoned in on-hold | Total number of calls where customer hung up while on hold | Number of calls where the call completion status is abandoned on hold |
| # Calls abandoned in queue | Total number of calls where customer hung up while waiting in the queue | Number of calls where the call completion status is abandoned in queue |
| # Calls abandoned in IVR | Number of calls where customer hung up while going through the IVR tree | Number of calls where the call completion status is abandoned in IVR |
| # Abandoned Calls (% change) | The percentage change of abandoned calls this period versus last period. | Number of calls abandoned this period divided by the number of calls abandoned in the previous period. |
| Talk time | Net talk time when a customer is connected to an agent returned in seconds. Does not include any hold time. | Leg Duration minus Call Wait Time minus Call Hold Time |
| Agent Talk Time | The time agents spend talking with customers. Does not account for exact figures for customer talk times. | The sum of the 'Call Leg Talk Time' fact where the call leg type are agents and the call leg status is completed. |
| Total Talk Time | The total talk time per call. Should be used when looking for customer talk time values. | The sum of the maximum Call Talk Time fact by call. |
| Leg Duration [Sum] | Total leg duration time in seconds | Sum aggregation of 'Leg Duration' fact |
| Call Wait Time [Sum] | Total call wait time | Sum aggregation of 'Call Wait Time' fact |
| Call Wait Time abandoned calls [Sum] | Wait time for a call prior to it being abandoned | Call wait time where completion status is abandoned_in_ivr OR abandoned_in_queue OR abandoned_in_voicemail OR abandoned_on_hold |
| # Outbound calls | Total number of outbound calls | Number of calls where call direction is outbound |
| # Inbound calls | Total number of inbound calls | Number of calls where call direction is inbound |
| # Voicemails | Total number of calls that went to voicemail for any reason | Number of calls where voicemail is true |
| # Inbound calls (% change) | Percentage change of inbound calls during the selected period compared to inbound calls within the previous period of the same duration as the selected period. | Number of inbound calls of this period divided by number of inbound calls of previous period |
| # Completed calls | Number of completed calls either answered by an agent or left a voicemail | The number of calls where the Call Completion Status is completed |
| Call Consultation Time [Sum] | Total time in consultation | Sum aggregation of 'Call Consultation Time' fact |
| Talk minutes billed [Sum] | Total Talk minutes billed | Sum aggregation of 'Call minutes billed' fact |
| IVR Hops [Sum] | Total number of IVR hops | Sum aggregation of 'IVR Hops' fact |
| Charges [Sum] | Total amount of charges | Sum aggregation of 'Call charge' fact |
| # Voicemails (% change) | Percentage change of voicemails created during the selected period compared to voicemails created within the previous period of the same duration as the selected period. | Number of voicemails of this period divided by number of voicemails of previous period |
| # Outbound calls (% change) | Percentage change of outbound calls during the selected period compared to outbound calls within the previous period of the same duration as the selected period. | Number of outbound calls of this period divided by number of outbound calls of previous period |
| # Voicemails requested | Number of calls where customer requested to be put through to voicemail by dialing 1 |
Zendesk Guide
You can use the metrics described in this section to report on your different Zendesk Guide features.
Answer Bot metrics
The metrics below are located under the Answer Bot folder in Insights.
| Metric | Definition | How it's calculated |
|---|---|---|
| # Answer Bot attempted resolutions | The number of Answer Bot responses sent. | The count of ticket IDs with an automated response WHERE an Answer Bot suggested article was included. |
| # Answer Bot resolutions | The number of tickets resolved by Answer Bot | The count of ticket IDs with an automated response WHERE Answer Bot was used to solve a customer's support request. |
| Answer Bot overall click-through-rate | The percentage of Answer Bot suggested articles that were clicked over the total number of Answer Bot responses sent. | The number of Answer Bot suggested articles clicked divided by the number of tickets with an Answer Bot response. |
| Answer Bot unique ticket click-through-rate | The percentage of tickets where an Answer Bot article was clicked over the total number of Answer Bot responses sent. | The number of tickets WHERE an Answer Bot article was clicked divided by the number of Answer Bot emails sent. |
| # Answer Bot article clicks | The number of clicks on articles suggested by Answer Bot. | The count of all Answer Bot responses sent WHERE an article was clicked. |
| # Tickets with Answer Bot article clicks | The number of tickets that included an Answer Bot responses where one of the suggested articles was clicked. | The count of ticket IDs with an automated response WHERE a suggested article was clicked. |
| Answer Bot attempt:solve ratio | The number of times an Answer Bot suggested article solved a customer’s support request over the total number of Answer Bot responses sent. |
The count of tickets where the Answer Bot suggested article solved the support request divide by the total number of tickets with an Answer bot response BY Article ID. |
| Answer Bot resolution rate | The percentage of support requests that were resolved with Answer Bot over the total number of Answer Bot responses. | The number of solved tickets with an Answer Bot response over the total number of responses sent |
| MDN Answer Bot time-to-click | The median number of hours, minutes, and seconds between Answer Bot suggesting an answer and the customer clicking on one of the articles. | The median between when a customer clicked an article and when the Answer Bot response was sent WHERE an article was clicked. |
| MDN Answer Bot time-to-resolve | The median number of hours, minutes and seconds between Answer Bot suggesting an answer and the customer confirming their ticket as solved. | The median between when the support request was marked as solved and when the Answer Bot response was sent WHERE the article solved the support request. |
Metric Filters
The _spFilters and _Filters are special metrics that bridge together usually disconnected dimensions. After adding your report to a dashboard, you can activate these metric filters by selecting corresponding dashboard filters. There are two types of corresponding dashboard filters, User filters and Timeline filters. For more information on disconnect dimensions see, Understanding disconnected date dimensions.
These metrics aren't added into the 'What' panel, but instead are selected as numeric range filters after you've finished building your report. The third column of both tables below display the numeric range information for each metric filter.
The following filters can only be used when the Date (Timeline) dashboard filter is applied.
| Filter | Definition | Numeric range |
|---|---|---|
| _Filter Backlog Date | The number of backlog tickets (New, Open, Pending) in the selected time period. | Attribute: Date (Event)
Metric and Range: _Filter Backlog Date is greater than 0 |
| _Filter Backlog Date Most Recent Day | The number of backlog tickets on the most recent day of the selected time period. | Attribute: Date (Event)
Metric and Range: _Filter Backlog Date Most Recent Day is greater than 0 |
| _Filter Event Date | The number of events only within the selected time period. | Attribute: Date (Event)
Metric and Range: _Filter Event Date is greater than 0 |
| _Filter NPS Rated Date | The NPS ratings during the selected time period. | Attribute: Date (NPS Rated)
Metric and Range: _Filter NPS Rated Date is greater than 0 |
| _Filter Org Created Date | The number of organizations created during the selected time period. | Attribute: Date (Organization Created)
Metric and Range: _Filter Org Created Date is greater than 0 |
| _Filter Ticket Created Date | The number of tickets created during the selected time period. | Attribute: Date (Ticket Created)
Metric and Range: _Filter Ticket Created Date is greater than 0 |
| _Filter Ticket Solved Date | The number of tickets solved during the selected time period. | Attribute: Date (Ticket Solved)
Metric and Range: _Filter Ticket Solved Date is greater than 0 |
| _Filter User Created Date | The number of users created during the selected time period. | Attribute: Date (User Created)
Metric and Range: _Filter User Created Date is greater than 0 |
| _spFilter Backlog (Last Day of Month) | The number of backlog tickets on the last day of each month during the selected time period. | Attribute: Month/Year (Event)
Metric and Range: _spFilter Backlog (Last Day of Month) is greater than 0 |
| _spFilter Backlog (Max Day) | The number of backlog tickets on the last day of the selected time period. | Attribute: Date (Event)
Metric and Range: _spFilter Backlog (Max Day) is greater than 0 |
| _spFilter Backlog (Min Day) | The number of backlog tickets on the first day of the selected time range. | Attribute: Date (Event)
Metric and Range: _spFilter Backlog (Min Day) is greater than 0 |
| _spFilter Created Date (Previous Period) | The number of tickets created during the period of time previous to your selected time period. | Attribute: Date (Ticket Created)
Metric and Range: _spFilter Created Date (Previous Period) is greater than 0 |
| _spFilter Event Date (6 months) | The number of events within six months previous to the selected time period. | Attribute: Date (Event)
Metric and Range: _spFilter Event Date (6 months) is greater than 0 |
| _spFilter Event Date (12 months) | The number of events within 12 months previous to the selected time period. | Attribute: Date (Event)
Metric and Range: _spFilter Event Date (12 months) is greater than 0 |
| _spFilter Event Date (Previous Period) | The number of events during the period of time previous to the selected time period. | Attribute: Date (Event)
Metric and Range: _spFilter Event Date (Previous Period) is greater than 0 |
| _spFilter Ticket Created (6 Months) | The number of tickets created within six months previous to the selected time range. | Attribute: Date (Ticket Created)
Metric and Range: _spFilter Ticket Created Date (6 Months) is greater than 0 |
| _spFilter Ticket Created (12 Months) | The number of tickets created within 12 months previous to the selected time range. | Attribute: Date (Ticket Created)
Metric and Range: _spFilter Ticket Created (12 Months) is greater than 0 |
| _spFilter Ticket Solved (6 Months) | The number of tickets solved within six months previous to the selected time range. | Attribute: Date (Ticket Solved)
Metric and Range: _spFilter Ticket Solved (6 months) is greater than 0 |
| _spFilter Ticket Solved (12 Months) | The number of tickets solved within 12 months previous to the selected time range. | Attribute: Date (Ticket Solved)
Metric and Range: _spFilter Ticket Solved (12 months) is greater than 0 |
| _spFilter Solved Date (Previous Period) | The number of tickets solved within the period of time previous to the selected time range. | Attribute: Date (Ticket Solved)
Metric and Range: _spFilter Ticket Solved (Previous Period) is greater than 0 |
| _spFilter Org Created (prior to BOP) | The number of organizations created before the set beginning date of the selected time range. | Attribute: Date (Organization Created)
Metric and Range: _spFilter Org Created (prior to BOP) is greater than 0 |
| _spFilter NPS Rated (6 Months) | The number of NPS ratings within six months previous to the selected time range. | Attribute: Date (NPS Rated)
Metric and range: _spFilter NPS Rated (6 Months) is greater than 0 |
| _spFilter NPS Rated Date (Previous Period) | The number of NPS ratings within the period of time previous to the selected time period. | Attribute: Date (NPS Rated)
Metric and range: _spFilter NPS Rated Date (Previous period) is greater than 0 |
The following metric filters are used to restrict report results to selected users. They can only be activated when the User filter is added to the dashboard.
| Filter | Definition | Numeric range |
|---|---|---|
| _Filter Ticket Assignee (Current) | The selected agent's number of replies, reopens, or any selected ticket metric. | Attribute: Ticket Assignee
Metric and Range: _Filter Ticket Assignee (Current) is greater than 0 |
| _Filter Ticket Assignee (Historic) | The number of ticket updates made when the selected user was the assignee. | Attribute: Ticket Assignee (Historic)
Metric and Range: _Filter Ticket Assignee (Historic) is greater than 0 |
| _Filter Backlog Assignee | The number of backlog tickets for the selected agent. | Attribute: Backlog Assignee
Metric and Range: _Filter Backlog Assignee is greater than 0 |
| _Filter Updater | The number of times the selected agent has updated a ticket. | Attribute: Updater
Metric and Range: _Filter Updater is greater than 0 |
| _Filter User | This filter enables you to show any metric that can be used with the user attribute for only your selected agent. | Attribute: User
Metric and Range: _Filter User is greater than 0 |
Comments
14 comments
From the descriptions, it looks like the three Ticket Age metrics all keeping counting even when a ticket is solved of closed. They do a comparison to 'Present' rather than to 'Closed Date'. Is this correct?
Ticket Age (days) [AVG]
Ticket age (days) [MAX]
Ticket Age (Open Tickets)
I would be more interested in:
Average age of Unresolved tickets
Average age of Tickets when Solved
Average age of all tickets (combination of the above)
Does anyone else have an example of these?
Hi Tom,
You are correct - Ticket Age (days) [AVG] and Ticket age (days) [MAX] will measure the age of a ticket from the day it was created to today, regardless of its status.
Making custom metrics for your own needs based on the default metrics should be pretty straightforward:
Average age of Unresolved tickets: Take the "Ticket Age (Open Tickets)" metric, make a new copy of it, and replace "MAX" with "AVG" in its MAQL.
Average age of Tickets when Solved: I duplicated the "Ticket Age (days) [AVG]" metric and modified it slightly to calculate the number of days between the date a ticket was created and the date a ticket was solved:
SELECT AVG(SELECT Date (Ticket Solved) - (SELECT Date (Ticket Created) BY Ticket Id)) WHERE Ticket Status IN (Closed, Solved)
Otherwise, if you mean you want to combine the average age of unsolved tickets (today minus Date (Ticket Created)) and the average age of the tickets when they were solved (Date (Ticket Solved) minus Date (Ticket Created)), I don't think that is possible with Insights. My best recommendation in that case is to use the two metrics I described above side-by-side on a dashboard and compare them.
Hope that helps! Please let us know if we can be of further assistance or if you'd like more detail on how to make the metrics.
Hi there!
My team uses an open-pool ticket system where, once re-opened with a response from the requester, it goes back into the unassigned pool. Because of this system, many tickets get "Solved" more than once, often by different Agents. Does "# of Tickets Solved" include multiple Solves on the same ticket? Or does it just count once + get attributed to that person?
Thanks!
Looking through the metrics, I've noticed there are two types of solved ticket metrics.
What's the difference between how these work. I'm having trouble understanding the first one.
1. # Tickets Solved
SELECT IFNULL(COUNT(Ticket Id, Ticket Text Field Change), 0) WHERE [Text Field] New Value IN ([Status] solved, [Status] closed) AND [Text Field] Previous Value <> [Status] solved AND Ticket Status IN (Solved, Closed) AND Date (Event) = (SELECT MAX(SELECT Date (Ticket Solved) BY Ticket Id) BY Ticket Id)
2. # Solved Tickets
SELECT # Tickets WHERE Ticket Status IN (Solved,Closed)
Hi Alex!
Functionally, there isn't any difference between the two metrics. The longer definition in the first metric allows solved tickets to be sliced by Event date attributes in addition to Ticket Solved date attributes. This is so the results from the # Tickets Solved metric would make sense alongside other metrics that might not make sense using Ticket Solved date attributes.
I hope this helps-- Happy reporting!
Hi Bianca!
# Tickets Solved only sees the final solve on a given ticket. Who gets the credit depends on how you slice it! If you use Ticket Assignee (Historic), it'll attribute the solve to the first assignee on the ticket. If you use Ticket Assignee, it'll attribute the solve to the ticket's assignee when the ticket was solved. And if you use Updater, it'll attribute the solve to the person or process that updated the ticket to Solved.
Thanks for your question!
Hi,
If I look at number of group stations for a specific group does the number mean the number of tickets that have ended up in the group? Or the number of tickets which has left the group?
e.g 1st line # of group stations is 56. Is the number showing number of tickets that has been moved from 1st line or tickets being moved into 1st line?
Hi Team,
Our group is trying to create a report that shows the % of tickets created and solved by agent. Basically we are trying to measure the amount of work each agent is doing on a weekly basis.
I already have a report that shows me # of Tickets Solved and # of Tickets Created by each agent, but I don't know how to switch the results to a percentage.
Any suggestions?
Thanks!
Hi Monica!
For this, you’ll need to create a custom metric. If I understand you correctly, you’ll need to create two different metrics: one for % Tickets Created and one for % Tickets Solved. The metrics you want are:
SELECT # Tickets Solved/ (SELECT # Tickets Solved BY ALL OTHER)
and
SELECT # Tickets Created/ (SELECT # Tickets Created BY ALL OTHER)
For your report, you’ll select these two metrics and then select Ticket Assignee under the How section. The report will show a distribution of how many tickets are created and solved for each of your assignees by percentage.
Hey Gurunn,
When you create a report for Group Stations by Group Name the number you're seeing is the # of tickets that have been changed to that group.
Thanks for your question!
Hi,
I am trying to create a report for the number of tickets that have been changed from a particular ticket group to another ticket group. I know the names of both the ticket groups.
Any suggestions on how this can be created?
Thanks in advance!
Hey Jill!
This is an interesting question...let me see if I can get some of our Insights gurus in here to help you out!
Hi Jill!
I would recommend checking out our article on Building custom metrics for the events model-- you're going to want to specify the groups you're interested in using the [Text Field] New Value and [Text Field] Previous Value attributes to pull tickets that had an update submitted that changed groups in the way you've specified.
I hope this helps! Happy reporting!
Jill
That is a really good suggestion for a metric.
Here is an example of counting the number of times the group is changed from the development group to the support group.
Please sign in to leave a comment.