I need help with an expression under the following condition:
Give me the count of patients (MRN) who have zero Office Visits ([OFFICE VISIT]) and at least one Care Coordination [CARE COORDINATION])
This is close...but is there a way for it to do a count of all of the Office Visits for that patient and return the count of MRN when that Office Visit Count is 0 and the count of care coordination is >1?
This basically needs to collapse across the following:
Patient A 3/2/17 Office Visit
Patient A 3/4/17 Care Coordination
Patient B 3/1/17 Care Coordination
Patient C 2/4/17 Care Coordination
The output would be that we have MRN = 2 because only two patients have only Care coordination visits (A does not qualify because Office Visit = 1 for them).