image for site

Why D_COUNT is Default in Zendesk Explore

Explore why D_COUNT is often the default metric aggregator in Zendesk Explore for unique and accurate data counts.

Why is D_COUNT the default metric aggregator in Zendesk Explore?

D_COUNT is often the default metric aggregator in Zendesk Explore because it provides a unique count of items, which is generally more useful for accurate reporting.

For example, when counting the total number of tickets an agent has updated with a comment, using DCOUNT ensures that each ticket is counted only once, avoiding inflated numbers due to duplicates. While COUNT can be used for total counts, DCOUNT is preferred for unique counts, which is why it might be set as the default in some cases.


More related questions

What is the difference between COUNT and D_COUNT in Zendesk Explore?

COUNT and DCOUNT are both aggregation methods used in Zendesk Explore, but they serve different purposes. COUNT simply counts the total number of items in a dataset, while DCOUNT counts only the unique items. For example, if you have a list of…

When should I use D_COUNT instead of COUNT in Zendesk Explore?

You should use D_COUNT when you need to count only unique items in your dataset. This is particularly useful if you expect an item, like a ticket ID, to appear multiple times and you want to ensure it's only counted once. For instance, if you're…

How does COUNT and D_COUNT work with rows and columns in Zendesk reports?

In Zendesk reports, COUNT and D_COUNT are aggregated within each cell when attributes are placed in rows or columns, rather than for the report as a whole. For example, if you have tags like 'Cat', 'Dog', and 'Bird' across different tickets, COUNT…

Does using COUNT or D_COUNT affect counting rated satisfaction tickets?

In most cases, using COUNT or DCOUNT for rated satisfaction tickets in Zendesk Explore won't make a difference, as both will count the number of ticket IDs. However, if you're using a dataset like Ticket Updates and calculated metrics, DCOUNT…

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