count compound statement

[earlcool]

I would like to count number of persons over or equal to 18 with a distinct id.

I have

 =Count({<Age={">=18"}>}Age) and =Count(DISTINCT patient_id )

I want a combine the statements to have one count statement

something like =Count(DISTINCT patient_id  where Age>=18)

thanks

[MayilVahanan · Accepted solution]

Hi

Try like below

=Count({<patient_id={"=Age >=18"}>}DISTINCT patient_id)

or

=Count({<Age ={">=18"}>}DISTINCT patient_id)