Using COUNT and D_COUNT Aggregators in Zendesk
When should I use the COUNT and D_COUNT aggregators?
The COUNT and DCOUNT aggregators are used when you need to count specific objects or events in your data. COUNT is used to count all recorded values, while DCOUNT counts only unique values.
In many cases, both aggregators will yield the same results if the values being counted are not repetitive. For example, counting Ticket IDs in the Tickets dataset will give the same result for both aggregators since each ticket ID is unique. However, in datasets where values repeat, like the Updates history dataset, COUNT will return a higher result as it counts each occurrence.
More related questions
How do I change the metric aggregator in Zendesk Explore?
To change the metric aggregator in Zendesk Explore, you need to access the report builder. First, add a metric to the Metrics panel. Then, click on the metric you added and select a new aggregator from the list. The available aggregators will vary…
What are the different types of metric aggregators available in Zendesk Explore?
Zendesk Explore offers a variety of metric aggregators to help you analyze your data effectively. These include COUNT, DCOUNT (distinct count), SUM, AVG (average), MED (median), MIN (minimum), MAX (maximum), VARIANCE, STDDEV (standard deviation),…
How do AVG and MED aggregators differ in Zendesk Explore?
AVG (average) and MED (median) aggregators both help in understanding the tendency of a metric, but they differ in their approach. AVG calculates the arithmetic mean of numeric values, making it suitable for data that is mostly uniform. However,…
What is the VALUE aggregator and how is it used in Zendesk Explore?
The VALUE aggregator in Zendesk Explore is unique because it is only available within formulas. It returns the exact value of a metric without any additional manipulation, making it useful for creating calculated metrics or attributes. VALUE can…
How can I choose the right metric aggregator for my report in Zendesk Explore?
Choosing the right metric aggregator in Zendesk Explore depends on your reporting needs. By default, metrics use the most relevant aggregator, but you might need to select a different one based on your specific requirements. For counting objects,…
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.
