Count AND Set Analysis

[Taylorcc]

Hello, 

I am using the below to count clients who have a episode start AND review reason for collection recorded. The output is clients who have had one or the other - how can i adjust this set analysis to count only if a client has both?

Count({<ReasonForCollection={"Episode start"},
ReasonForCollection={"Review"},
Status={"Episode closed - treatment concluded"},
Name={"Clinical care coordination"}
>}Distinct Client)

Thanks very much 

[lironbaram · Accepted solution]

hi for the reason part you can use 

Count({<Client={"count({<ReasonForCollection={'Episode start','Review'}>}distinct ReasonForCollection)=2"},
Status={"Episode closed - treatment concluded"},
Name={"Clinical care coordination"}
>}Distinct Client)

[Taylorcc]

Thank you!