Calculation Options for Top/Bottom Filters in Explore
What are the calculation options for top/bottom filters in Zendesk Explore?
Zendesk Explore offers calculation options to enhance your top/bottom filters. You can choose 'Aggregate values', which is useful if you have attributes in both the Rows and Columns panels or if your chart displays results over time.
Another option is 'Aggregate filtered elements', which combines all results outside your specified top/bottom range into another category. This is particularly useful when you want to maintain accurate overall totals and percentage shares without viewing the details of smaller results. Note that this option works only with the COUNT, SUM, MIN, and MAX aggregators.
More related questions
What is a top/bottom filter in Zendesk Explore?
A top/bottom filter in Zendesk Explore helps you focus on a specific range of results. For instance, you can create reports to find the ticket type with the shortest resolution time or identify the top five agents with the most solved tickets. This…
How do I apply a top/bottom filter in Zendesk Explore?
To apply a top/bottom filter in Zendesk Explore, start by opening the report builder and clicking the result manipulation icon. In the Result Manipulation panel, select 'Top/bottom'. Enter the number of top and bottom results you want to see,…
What strategies can I use with top/bottom filters in Zendesk Explore?
When using top/bottom filters in Zendesk Explore, you can choose from several strategies to tailor your results. If you have attributes on both rows and columns, you can select the appropriate section for your filter. For more detailed analysis,…
Why is my 'Other' category blank when using Aggregate filtered elements?
If your 'Other' category appears blank when using the 'Aggregate filtered elements' option, it might be due to the metric aggregator you're using. Switching from D_COUNT to COUNT can resolve this issue. This solution was provided by Zendesk Support…
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.
