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

This recipe will demonstrate how to generate a list of users who have open tickets in your account. 

What you'll need

Skill level: Beginner

Time required: 5 minutes

Data source: Tickets dataset 

Ingredients:

  • One default metric
  • One default attribute
  • One filter

How to create the report in Explore

    Use the following steps to create this report in Explore.

    1. In Zendesk 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 . 
    6. In the Rows panel, click Add.
    7. From the list of attributes, choose Requester/user > Requester name, and if you'd like to include their email address, Requester/user > Requester email then click Apply.
    8. In the Filters panel, click Add.
    9. From the list of filters, choose Tickets > Ticket status, then click Apply.
    10. In the Filters panel, click Ticket status, then choose Open to filter for open tickets. 
    11. If you have a lot of open tickets in your account, the report may be too large to execute. You can export it as a CSV to download all data, or you can apply a metric filter to narrow your report to show users with a certain number of open tickets. 
    12. Click Save.
    Powered by Zendesk