1 of 1 people found this helpful
Count Returns the number of rows in a measure or a dimension.
CountDistinct Returns the number of unique values in a measure or dimension. It avoid duplicates.
It depends upon what you want to see in data. COUNTD will be less than Count in most of the cases unless you have unique data where they become same.
If you filter your view for the DRIVERID="SOMA",
you will observe he has two unique values for the field "SCHEDULE PICKUP"
30/01/2018 10:35 31/01/2018 9:18
For the first value, you have 1 record, where as for the second value you have 9 records.
This is what is driving up your count values against the distinct count.
if you want to get unique count, use countd else count.
say, if you table has a primary key and you want to see number of row in that table.
then count and countd of primary key return the same output
Thanks for your answers.
So I can use based on condition, right?
its based on your condition and requirement.
Please mark correct and helpful to close the discussion so that it will be helpful for others as well