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?
The correct syntax is count(distinct Staff_Name)
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 !
Retrieving data ...