Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
May be this:
Count(DISTINCT {<MRN = {"=Count({<[OFFICE VISIT] = {'Office Visit'}>}MRN) = 0 and Count({<[OFFICE VISIT] = {'Care Coordination'}>}MRN) >= 1"}>} MRN)
Share some sample data and expected output
May be like this
Count(DISTINCT {<[OFFICE VISIT] = {0}, [CARE COORDINATION] = {'>= 1'}>}MRN)
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).
May be this:
Count(DISTINCT {<MRN = {"=Count({<[OFFICE VISIT] = {'Office Visit'}>}MRN) = 0 and Count({<[OFFICE VISIT] = {'Care Coordination'}>}MRN) >= 1"}>} MRN)
Definitely it! I'll have to look into that method you used where you defined MRN, I haven't seen that before in set analysis
Check this out here (Under Search String):