Explore recipe: Reporting on tickets without a public reply

This Explore recipe shows you an easy way to limit the results returned by a report to give only the data you need. In this case, you'll create a report that returns all tickets that do not have any public comments.

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 

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 - Updates history, then clickStart report.
4. In the Metrics panel, click Add.
5. From the list of metrics, choose Comments > Public comments, then click Apply.
6. In the Rows panel, click Add.
7. From the list of attributes. choose Ticket > Ticket ID, then click Apply.
8. From the result manipulation menu (), click Metric filter.
9. On the Metric filter page, drag the circle on the metric line to 0, then click Apply.
   

For more information, see Selecting the metric result range.