Histogram with value intervals as dimension.

[marunio007]

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?

[marunio007 · Accepted solution]

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))

[sunny_talwar]

Thanks for sharing.... I am sure others will benefit from this