image for site

Using COUNT and D_COUNT Aggregators in Zendesk

Learn when to use COUNT and D_COUNT aggregators in Zendesk Explore for counting objects and events.

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?

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