count compound statement

earlcool — Thu, 26 May 2022 20:26:46 GMT

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

Re: count compound statement

MayilVahanan — Fri, 27 May 2022 08:28:42 GMT

Try like below

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

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