D_Count vs Count giving different results when used in a custom metric | Community
Skip to main content

D_Count vs Count giving different results when used in a custom metric

  • November 11, 2022
  • 1 reply
  • 0 views

Claudia15

Hi! If I am looking to identify total tickets per active user. And when I use the D_COUNT function on the custom metric

COUNT(End-user submitted tickets)/D_COUNT(End-users)

I get around 7-8 submitted tickets per active user.

 

When I use the D_COUNT function on the custom metric

D_COUNT(End-user submitted tickets)/D_COUNT(End-users)

 

I get around 2-3 submitted tickets per active user. 

Is using the metric with D_COUNT preventing the same ticket from showing up multiple times?

I am trying to figure out what each result is telling me and which one most accurately represents total unique tickets/active users.

1 reply

Dane13
  • January 12, 2023
Hi Claudia,

You are correct, D_COUNT prevents the same ticket from showing up multiple times. 

More information can be found on What is the difference between COUNT and D_COUNT?