I have a dataset that is made up of a number of records or sales orders, there is a completed date and this would make up the first count which is easy count of SalesOrder Completed Date. The issue is the second subset, there is also a survey date which I want to count the number of surveys taken based on the survey date.
This dataset is a blend of two the SalesOrder and the Survery data, with a left join on the SalesOrder based on OrderID.
When I do the count of both I always get the same value for both, it is counting all the Ordercompleted dates that have a Survey date that falls within the date range.
I want to be able to get the count of all Completed Orders and then the count of all Surveys taken on those closed Orders.
This seems very straightforward but I can't come up with the two different sums, it always comes up with the same number for both. I've tried numerous beastmodes including a Closed Flag on the SalesOrder where Closed Date is not null and a survey count on the Surveydate is not null and tried doing a sum of both and still only get the same number.
Let me know if there is a differenct approach I should be taking or something I'm overlooking.
Thanks in advance any help on this.
Randy