This is how your Zendesk Support metrics are calculated in Geckoboard based on the raw data Zendesk provide.

Ticket count metrics

All tickets

The number of unarchived tickets currently in your Zendesk account.

New tickets

The number of tickets currently in your Zendesk account where status is new.

Received tickets

The number of tickets created, excluding those that have been deleted.

Count of tickets grouped by tickets.created_at.

Note: This may differ from how it’s shown in Zendesk’s reporting tab, which doesn’t exclude deleted tickets. Learn more about data discrepancies between Zendesk Explore and Geckoboard.

Solved tickets

The number of tickets currently in your Zendesk account where status is solved.

Count of tickets grouped by tickets.solved_at.

Open tickets

The number of tickets currently in your Zendesk account where status is open.

Pending tickets

The number of tickets currently in your Zendesk account where status is pending.

On-hold tickets

The number of tickets currently in your Zendesk account where status is hold.

Count of tickets where status NOT IN ("closed", "solved").

Unsolved tickets

The number of tickets currently in your Zendesk account where status is not closed or solved.

Unassigned tickets

The number of tickets currently in your Zendesk account that have no assignee and where status is not closed or solved.

Count of tickets where status NOT IN ("closed", "solved") AND ticket.assignee IS NULL.

Efficiency metrics

First resolution time (calendar)

Time from when the ticket was created to when it was first solved.

The difference between ticket.solved_at and ticket.created_at grouped by ticket.solved_at.

First resolution time (business)

Time from when the ticket was created to when it was first solved, excluding out of office hours.

Full resolution time (calendar)

Time from when the ticket was created to when it was last solved.

The difference between ticket.last_solved_at and ticket.created_at grouped by ticket.solved_at.

Full resolution time (business)

Time from when the ticket was created to when it was last solved, excluding out of office hours.

First reply time (calendar)

The time the assignee took to reply to the first incoming message in a ticket.

The difference between first_reply_at and ticket.created_at grouped by ticket.created_at.

First reply time (business)

The time the assignee took to reply to the first incoming message in a ticket, excluding out of office hours.

On-hold time (calendar)

The time that a ticket was in the on-hold status.

On-hold time (business)

The time that a ticket was in the on-hold status, excluding out of office hours.

Agent waiting time (calendar)

The time the assignee waits for additional information from the requester.

Agent waiting time (business)

The time the assignee waits for additional information from the requester, excluding out of office hours.

Requester waiting time (calendar)

The time the requester waits for responses and answers in the total time it takes to solve their issue.

Requester waiting time (business)

The time the requester waits for responses and answers in the total time it takes to solve their issue, excluding out of office hours.

Satisfaction metrics

Rating (CSAT)

COUNTIF(rating = good) / COUNT(all ratings) * 100, grouped by satisfaction_ratings.created_at.

SLA target metrics

Number of SLA targets achieved

The number of SLA targets that are achieved in the selected time period.

Number of SLA targets breached

The number of SLA targets that are breached in the selected time period.

Did this answer your question?