Create a Zendesk Explore Report for Ticket Comparison
How do I create a report comparing last month's tickets to a 12-month average in Zendesk Explore?
To create a report comparing last month's tickets to a 12-month average in Zendesk Explore, follow these steps. First, ensure you have Zendesk Explore Professional or Enterprise and the necessary permissions.
Start by clicking the reports icon in Explore, then select 'New report' from the Reports library. Choose the 'Support - Tickets' dataset and click 'Start report'. Create a standard calculated metric using the formulaCOUNT(Tickets)/DCOUNT_VALUES([Ticket created - Month])to find the monthly average. Then, create a date range calculated metric to return monthly averages for the last 12 months. Finally, add the default metricCOUNT(Tickets Created - Last Month)and your custom metric to the report, and select the KPI visualization to display the variation. For more details, check theoriginal link.
More related questions
What permissions are needed to create a report in Zendesk Explore?
To create a report in Zendesk Explore, you need Editor or Admin permissions. These permissions allow you to access and manipulate data within Zendesk Explore. If you don't have these permissions, you may need to contact your Zendesk administrator…
Can I compare weekly ticket data instead of monthly in Zendesk Explore?
Yes, you can compare weekly ticket data instead of monthly in Zendesk Explore. This involves adjusting the formula and date range. Instead of usingCOUNT(Tickets)/DCOUNT_VALUES([Ticket created - Month]), use `COUNT(Tickets)/DCOUNT_VALUES([Ticket…
What is the correct end date for the 12-month average metric in Zendesk Explore?
The correct end date for the 12-month average metric in Zendesk Explore is 'To the end of: 1 month ago'. This ensures you get a true 12-month rolling average. This setting looks back to the beginning of the current month in the previous year and…
What skill level is required to create a report in Zendesk Explore?
Creating a report in Zendesk Explore requires an intermediate skill level. This means you should be comfortable with navigating the Explore interface and using its features. The process involves creating calculated metrics and understanding how to…
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.
