Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following fact table:
VisitDate, Patient, KFRE
KFRE is a numerical value between 0 and1.
I was able to create a nice simple histogram where chart dimension is =Round(KFRE, 0.025) and expression is =Count(Patient) .
This gives me the number of visits with KFRE values within each KFRE interval for all the visits.
Since a patient can have more than 1 visit I need such histogram but only for the last patient's visit.
The expression would be something like this:
=Count({<VisitDate={$(=Max(VisitDate))}>}Patient)
but I am not getting any values on output.
What am I doing wrong?
I have found a solution in this thread:Help with Set Analysis - MAX
The needed expression does not use set analysis:
=count(If(VisitDate=Aggr(Nodistinct Max(VisitDate),Patient),Patient))
Thanks for sharing.... I am sure others will benefit from this