What is the difference between Count and Count Distinct?

[e_wilber]

In Performance Analytics, on the indicator you can set the Aggregate to Count or Count Distinct. What's the difference?

[Jaspal Singh]

Hi,

Count would show a result of all records while count distinct will result in showing only distinct count. For instance, a table has 5 records as a,a,b,b,c then Count is 5 while Count distinct is 3.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[Shubham Dhawan]

Hi,

what will be the value of Sum for these records?

Thanks,

Shubham Dhawan

[Jeff Currier]

Count is the total number of values.  Count Distinct in the number of unique values.  Count Distinct will always be equal to or less than Count