What is the difference between COUNT and D_COUNT?

Return to top


  • Shelley

    Thanks for the explanation Bryan. Just to confirm for a query on a total number of SOLVED tickets. If a ticket ID is SOLVED multiple times  example, ticket ID SOLVED twice (open, solved, open, solved) will ...
     - COUNT count the unique ticket ID twice
     - D-COUNT
    count the unique ticket ID once


  • Gab Guinto
    Zendesk Customer Care

    Hi Shelley,

    It would depend on what metric/s or dataset you're using, but you're right, in general, if you expect a Ticket ID to appear more than once in a query, then it would be safe to opt for D_COUNT when you need to count each unique ID only once. You may also find this section helpful: COUNT and D_COUNT.


Please sign in to leave a comment.

Powered by Zendesk