Display Organizations with No Tickets in Zendesk Explore
How can I display organizations with no tickets in Zendesk Explore?
To display organizations with no tickets in Zendesk Explore, you need to create a custom report. Start by opening Explore and clicking the reports icon. In the Reports library, select 'New report' and choose the 'Support - Tickets' dataset. Add the 'Tickets' metric and create a standard calculated metric for organizations with the formula:IF ([Requester organization status]="Active") THEN [Requester organization ID] ENDIF. Ensure 'Compute separately' is enabled. Add this metric to your report and set its aggregator to COUNT. Finally, add the 'Requester organization name' attribute to the Rows panel to see a table of organizations and their ticket counts. Sort by the Tickets column to identify organizations with no tickets. For more details, visit theoriginal guide.
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 and modify reports within Explore. Additionally, you must have Zendesk Explore Professional or Enterprise, as well as access…
How do I handle syntax errors in Zendesk Explore formulas?
If you encounter syntax errors in Zendesk Explore formulas, it might be due to incorrect attribute names or locale settings. Ensure that the attribute names are spelled correctly and match the locale settings of your account. Use the autocomplete…
Can I filter organizations with no urgent tickets in Zendesk Explore?
Yes, you can filter organizations with no urgent tickets in Zendesk Explore by creating a custom metric. Use the formulaIF [Ticket priority]="Urgent" THEN [Ticket ID] ENDIFto count urgent tickets. Add this metric to your report alongside the…
How can I apply date filters to reports in Zendesk Explore?
To apply date filters to reports in Zendesk Explore, use native date attributes like 'Ticket created - Date'. You can slice or filter the data by these attributes to focus on specific timeframes. If you're having trouble, try using a calculated…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
