In this Explore recipe, you'll learn how to create a line chart showing tickets solved this year compared to last year by month.
What you'll need
Skill level: Easy
Time Required: 10 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
You can click the preview below to watch a video of this recipe, or continue to the walkthrough.
- In Explore, click the reports (
) icon. - In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Tickets, then click Apply.
- In the Columns, add the Ticket Solved - Month attribute, then click Apply.
- Under Rows, add the Ticket Solved - Year attribute, then click Apply. Click the Visualization type (
) icon and select Line. - In the header of the row selector, Ticket Solved - Year, select the years you want to compare. The report updates to display the years you selected.
You can hover over any point on the line chart to display a tooltip displaying the ticket solved count for each year.