What is the difference between COUNT and D_COUNT?

Return to top

2 Comments

  • 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

    ...?

    0
  • 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.

    0

Please sign in to leave a comment.

Powered by Zendesk