Expression to calculate avg length of stay for prev 12 months

[ashmitp869]

Hi there ,

I have an measure -

Aveg length of stay

Sum({<measure_ward_discharge={'1'}>}measure_ward_los_agrr)/Sum(measure_ward_discharge)

Now , how to calculate the Aveg length of stay for prev 12 month ?

[sidhiq91]

@ashmitp869  Could you please provide some sample data? And expected output. I will try to help you out.