Hi everyone,
I am relatively new to QlikSense. I've been tasked with developing a dashboard to compare actual readmission rates to our peer's median, 10th percentile, and 26th percentile rates. I need to be able to slice this different ways, one of them being by date. I did do lots of research on how to use FRACTILE but I can't seem to get this right. This is an example of the calculation I am using for 25th.
Fractile (Aggr( Sum(AMC_PlannedReadmit30Cases) / Sum(AMC_ReadmitDenomCases)*100, [DischargeDate.autoCalendar.YearMonth]), 0.25)
As you can see in the screenshot, the totals for each percentile changes, but by date, they don't. What am I doing wrong?
Thanks in advance!
