Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have multiple patients (PatientID) visiting a hospital (VisitID) multiple times
I am trying to find the average number of visits per patient
Is this possible?
Thank you
How VisitID associated with PatientID?
I mean if the same Patient visit multiple times then he/she allocated different VisitID everytime?
Try something like below.
Avg(Aggr(Count(Distinct VisitID),PatientID))
Great thank you,
Now I need to only count patients with Diagnosis=Mentalhealth
Is this possible?
Use set analysis expression
count({<[Diagnosis]={'Mentalhealth'}>}PatientID)
Thank you - where would i put the VisitID?
Avg(Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))
or
Avg({<[Diagnosis]={'Mentalhealth'}>}Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))