Help with filtering calculated expressions using above()

[#1]

I am trying to filter a table that uses a calculated expression to evaluate the time between successive hospital admissions across a population of patients.

The Time_Between_Readmissions is calculated as [HospitalAdmissionDate]-above([HospitalDischargeDate]) with PatientID and [HospitalAdmissionDate] as dimensions.

The calculations work great but I am trying to filter the results to show only those records where Time_Between_Readmissions is within a specific range (say 0-30 days). For each patient, the first admission of each series has a null value for the calculated field (there is no record 'above').

I have tried using set analysis for the calculated expression and also have tried using a calculated dimension using an 'if' statement.

Any thoughts about how to filter the table so I only see the records of interest?

Thanks,

Mike

[Anonymous]

Hey Mike,

You might want to try calculating the Time_Between_Readmissions value in the script already and then use that field in the expression in your chart. It makes it kind of hard to "filter" the chart when you're using inter-record functions like above() at the same time to compare with other cells.

[#3]

Thanks. Unfortunately, I don't have access to the script. I am using a QV application our organization makes available for self-service analytics. I may be able to request an enhancement to the script but can't create changes myself.

Is there any way to filter the chart using the results of inter-record functions?

Mike