Average Number of Visits

[Taylorcc]

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 

[MK_QSL]

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))

[Taylorcc]

Great thank you, 

Now I need to only count patients with Diagnosis=Mentalhealth 

Is this possible?

[GreatGreekYogurt]

Use set analysis expression

count({<[Diagnosis]={'Mentalhealth'}>}PatientID)

[Taylorcc]

Thank you - where would i put the VisitID?

[MK_QSL]

Avg(Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))

or

Avg({<[Diagnosis]={'Mentalhealth'}>}Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))