Count of first dates

[Taylorcc]

Hello

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: 

Date(Min([service_contact_date],episode_key))

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? 

Thank you 

[tresesco]

Try like:

Count(Distinct {<service_contact_date={'$(=Date(Min([service_contact_date]))'}>}episode_key)

[Taylorcc]

Thanks for the response, I have tried this logic and am getting 16 when the answer should be 299.. 

[tresesco]

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.