Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 data sets that are hooked together by Staff_Name.
distinct(Staff_Name) is counting exactly double the number of staff.
What is the reason for the double count as the data model is hooked together on the Staff_Name?
thanks
Stuart
Are they exactly the same in both data sets?
The correct syntax is count(distinct Staff_Name)
Thanks Jacob.
This still produces a double count again.
If I load in one or the other data set I only get half the figure, but when both are loaded I get the double count
Are they exactly the same in both data sets?
Good catch - there was a missing underscore in one side of the data !
Thanks again