I need to count the number of episodes with a service contact date within a period (May 2020).
I am using this logic to find the minimum service contact date for an episode:
If I filter my app by May 2020 how can I get a count of epiosde keys that have their first service contact date in that month?
Thanks for the response, I have tried this logic and am getting 16 when the answer should be 299..
Without sample data and/or some more detail it would be hard to understand the issue. You can give a try removing 'distinct' from count() if that helps.