What's my plan?

Available on Suite Professional plans and above Available on Explore Professional plans and above

You can use Explore to create an overview of your tickets based on specific ticket fields. This information can also be captured with views, but views don't include archived tickets like Explore does.

In this recipe, you'll create a table focusing on custom ticket fields that can be added to a dashboard, exported, or scheduled. For more on custom fields, see Adding custom fields to your tickets and support request form.

Note: This overview is of a specific time period. If you're looking to export all of your ticket data, see Exporting data to a JSON, CSV, or XML file instead. 

This article contains the following topics:

  • What you'll need
  • Creating the report
  • Next steps

What you'll need

Skill level: Beginner

Time required: 10 minutes

  • Zendesk Explore Professional or Enterprise
  • Editor or Admin permissions (see Giving users access to Explore)
  • Custom ticket fields
  • Tickets using those custom ticket fields

Creating the report

Deciding what you want to report on and how

Before you create your report, take a look at your ticket fields and figure out what fields you want to track. In this example, we'll be using the custom field called What Fruit? 
Fruitbat_form.png

Then, decide how do you want to organize your data. When you create a report in Explore, any attributes you add are sorted from the top down. For example, if you have Ticket group as your first attribute, any following attributes will first be sorted by ticket group.
attribute1-2.png

Building the report

  1. In Explore, click the Reports ( ) icon.
  2. In the report library, click New report.
  3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens. (While this example uses the Tickets dataset, you can use whichever dataset includes the data you want to report on).
  4. In the Metrics panel, click Add.
  5. From the list of metrics, select Tickets > Tickets, then click Apply.
  6. In the Filters panel, click Add, select Time created - Date, and apply a time filter for a small period of time, such as a day or week. This prevents the query from timing out while you're building it. The example screenshot below also shows a Ticket form filter.  
    time_filter-2.png
  7. In the Rows panel, add the ticket fields you want to report on, such as Ticket group, Assignee name, or your custom ticket fields (in this example, What Fruit?).
    Tip: You can find all non-numeric custom ticket fields collected together in the menu under the Ticket custom fields folder. Numeric custom fields show up in the Metrics panel instead.
  8. In the Visualization type () menu, set your report's visualization to Table (if it isn't already). visualization.png
    At this point, your report should look something like this: attribute3-2.png
  9. Add any additional attributes as desired.
    Note: There is a limit to the amount of data that Explore can report on at one time. If the report you build is too big, you may receive an error. For more information, see Why do I receive a “Network error” in my report? 
  10. Give your report a descriptive name and click Save.

Next steps

Now that you've created your report, you can do any or all of the following:

  • Add the report to a dashboard
  • Export the report
  • Schedule a recurring dashboard delivery
Powered by Zendesk