What's my plan?
Suite Professional, Enterprise, or Enterprise Plus
Support with Explore Professional or Enterprise

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.

  1. In Explore, click the reports () icon.
  2. In the Reports library, click New report.
  3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
  4. In the Metrics panel, click Add.
  5. From the list of metrics, choose Tickets > Tickets, then click Apply.
  6. In the Columns, add the Ticket Solved - Month attribute, then click Apply.
  7. Under Rows, add the Ticket Solved - Year attribute, then click Apply. Click the Visualization type () icon and select Line.
  8. Click one of the time attributes that you added (Ticket Solved - Month or Ticket Solved - Year), and then click Edit Date Ranges.
  9. Click Advanced and set the range as below:
    • From the beginning of: 1 years in the past.
    • To the end of: Today.

You can click the header of the row selector, Ticket Solved - Year to ensure that all years are selected, and displayed on the chart.

 

Powered by Zendesk