Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To keep the explanation as simple as possible, I’ll describe it thus: I’m counting the number of times patients are admitted to a hospital.Hence:-
Dimension:
=aggr(sum({<set analysis in here>}AdmCounter),PatientID)
Expression:
count({<set analysis in here>}distinct PatientID)
And I get a very nice chart thankyou...
However, for this example, I’m really not interested in the “1” column but I want all the others (akin to a sql “Having Count >=2” clause I guess). How can the “1” column be ignored please? What do I write? Where do I put it? Any help very much appreciated.
Either try:
=aggr(if(sum({<set analysis in here>}AdmCounter)>1,
sum({<set analysis in here>}AdmCounter))
,PatientID)
or
if(sum({<set analysis in here>}AdmCounter)>1,
count({<set analysis in here>}distinct PatientID) )
Hope this helps,
Stefan
Thanks Stefan. The first of the two suggestions appears to be the correct solution and works just fine:
=aggr(if(sum({<set analysis in here>}AdmCounter)>1,
sum({<set analysis in here>}AdmCounter))
,PatientID)
Many thanks.
Graham