Creating a report for the average number of tickets per organization in Zendesk Explore is straightforward. First, ensure you have Zendesk Explore Professional or Enterprise and the necessary permissions. Then, in Explore, click the Reports icon and select New report. Choose the Support - Tickets dataset and start the report. Add metrics for Tickets and Organizations, and change the aggregator for Organizations to DCOUNT. Use the Result metric calculation to add a new metric with the formula: Count(Tickets) / DCount(Organizations). Finally, select Table as the visualization type. For more details, check the originalZendesk article.
To create a report in Zendesk Explore, you need to have Editor or Admin permissions. These permissions allow you to access the necessary features and datasets within Explore. If you're unsure about your permissions, you can check with your Zendesk…
If your 'tickets by customer' report is showing blank or NULL values, it might be due to a mismatch in the spelling of 'Organizations' in your metrics. Ensure that the spelling matches exactly with your account's settings. If the issue persists, it…
To filter out inactive organizations in your Zendesk report, you can add a filter for Ticket Organization Status and select Active only. This should help reduce the count of organizations to only those that are active. If inactive organizations…
Yes, you can create a bar graph with a trend line for tickets created by month in Zendesk. While the help doc doesn't provide specific steps for this, you can use the visualization options in Zendesk Explore to create a bar graph. Then, add a trend…
To use sets for viewing average tickets per members in Zendesk Explore, you need to manually apply filters that match your set's conditions. While Explore doesn't directly support filtering by sets, you can replicate the set's conditions by…