LashellThomas
3 years agoQrew Member
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 same admit start date. the claim also has the member id of the member who had the inpatient stay.
I want to count the number of inpatient visits visit for each member regardless of how many claims were submitted for the inpatient visit.
I have attempted to do combine the claim ID with the admit date and want to do a distinct count of that....
------------------------------
Lashell Thomas
------------------------------
I want to count the number of inpatient visits visit for each member regardless of how many claims were submitted for the inpatient visit.
I have attempted to do combine the claim ID with the admit date and want to do a distinct count of that....
------------------------------
Lashell Thomas
------------------------------