Forum Discussion

Qrew Member

3 years ago

Distinct Count on a combined text field

I need to identify the number of unique inpatient admissions from claims data. Each inpatient stay can generate multiple claims each with a unique claim identifier. The claims would all share the sa...

Formulas and functions

Relationships

DougHenning1

Community Manager

3 years ago

If you want the count of distinct admit dates for each member, you can use a summary report to get this info. Sample claims data with unique claim ids:

Summary report counting each unique admit date for each member:

Summary report settings, grouping by member id and summarizing on distinct count of admit date:

Hope that helps!

------------------------------
Doug Henning
------------------------------