Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like below
=Count({<patient_id={"=Age >=18"}>}DISTINCT patient_id)
or
=Count({<Age ={">=18"}>}DISTINCT patient_id)
The individual statements are represented as p and q and the compound statements are represented by one of p v q, p ^ q, p ⇒ q, p ⇔ q. An example of a compound statement using the connective word 'or' is "It is raining outside or it is sunny.". Costco ESS Login
Hi
Try like below
=Count({<patient_id={"=Age >=18"}>}DISTINCT patient_id)
or
=Count({<Age ={">=18"}>}DISTINCT patient_id)