A heatmap is a great way to see your team’s effectiveness at different times in a very compact way. If you have set up business hours in Zendesk, you can customize this query to reflect that.
What you'll need
Skill level: Easy
Time Required: 15 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
How to create the report in Explore
- In Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click New query. Query builder opens.
- In the Metrics panel, click Add
- From the list of metrics, choose Duration between events - Calendar hours (min) > First reply time (min), then click Apply. Explore displays the median first reply time for all tickets.
- In the Columns panel, click Add.
- From the list of attributes, choose Time - Ticket created > Ticket created - Day of week, then click Apply. Explore displays the median first reply time for all tickets sliced by weekday (Sunday to Saturday).
- In the Rows section, click Add.
- From the list of attributes, choose Time - Ticket created > Ticket created - Hour, then click Apply.
- From the visualization type menu (), choose Table.
Explore displays a table showing the median first reply times each hour for every day of the week (Sunday to Saturday).Tip: You can click the table column headers to change the default column names to shorter values.
If you want to filter the chart to show results for a specific period, for example the year to date, click Ticket created - Hour ,then Edit date ranges.
- From the calculations menu (), click Standard calculated metric.
- On the Standard calculated metric page, click the Fields list, then choose the same metric and aggregator that you already added to the query, in this case MED(First reply time (min)).
- Give the metric a name, and then click Save.
- In the Metrics panel, click the paintdrop icon.
- From the list of metrics, add your new standard calculated metric, which you can find in the Calculated metrics section of the list, then click Apply.
- In the chart configuration menu (), click Columns.
- On the Columns page, uncheck Fit to content.
- In the chart configuration menu (), click Colors.
- On the Colors page, change Color encoding to color encoding style 3. You can also click the two paintdrops to choose the colors you want to use for the lower and upper end results. You can also move the blue dot on the color range to add more contrast between the bulk of the results.