Forum Discussion

swaroopkumarmg's avatar
swaroopkumarmg
Helper II
6 years ago

Distinct Count

Hello there, I'm facing an issue with how the distinct count works.   i have a data set containing below fields and trying to accomplish 2 line graphs 1. Opportunity ID (duplicates) 2. Region  ...
Need Help
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi swaroopkumarmg ,

 

So the COUNT function counts all the rows within your dataset including duplicate values for your OpportunityID column.

But, when you use DISTINCTCOUNT on OpportunityID column, it just counts the unique values, ignoring any duplicates in this column in the data.

 

Thanks,

Pragati

  • swaroopkumarmg's avatar
    swaroopkumarmg
    Helper II
    6 years ago

    Thank you so much for replying, the problem im facing here is not the difference between Count and Distinctcount functions.

     

    Im using distinctcount function for OppID in both the graphs where the data set is the same but the only difference is the legend.

    the objective here is to have the sum of the values in a perticulat month to be the same in both the graphs, but im getting different values. 

     

    Please go through my post completely and help me out.

     

    thanks