image for site

Create Average Tickets per Organization Report in Zendesk

Learn how to create a report in Zendesk Explore to find the average number of tickets per organization. Follow these simple steps.

How can I create a report for the average number of tickets per organization in Zendesk Explore?

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.


More related questions

What permissions are needed to create a report in Zendesk Explore?

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…

Why is my 'tickets by customer' report showing blank or NULL values?

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…

How can I filter out inactive organizations in my Zendesk report?

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…

Can I create a bar graph with a trend line for tickets created by month in Zendesk?

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…

How can I use sets to see average tickets per members in Zendesk Explore?

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…

Interested indeflectingover 70% of your Zendesk support tickets?

Our AI customer support agent is here to help. Trained on all your help docs, installed directly into your Zendesk account, it can be used to automate customer replies for tickets or live chat. Learn more below.
Zendesk logo

Zendesk Support Tickets

Receive new tickets by email or a support form? This integration is for you.
My AskAI integrated within Zendesk to deflect support tickets
Learn about our Zendesk ticket integration
Zendesk logo

Zendesk Messaging (live chat)

Using Zendesk's Messaging widget on your site for live chat? This integration is for you.
My AskAI integrated within Zendesk to deflect customer support live chat conversations
Learn about our Zendesk Messaging integration

Join1,000+ companies reducing their support costs and freeing up support agents for more important work

Vestd company logo — Customer of My AskAI's AI customer support agents
Genesis company logo — Customer of My AskAI's AI customer support agents
Zinc company logo — Customer of My AskAI's AI customer support agents
Customer.io company logo — Customer of My AskAI's AI customer support agents
Zeffy company logo — Customer of My AskAI's AI customer support agents
NHS company logo — Customer of My AskAI's AI customer support agents
Kontakt.io company logo — Customer of My AskAI's AI customer support agents

Reduce support costs.Spend more time on customer success.

Our AI customer support agents are already used by 👇
Companies using AI assistants on their websites