I am trying to calculate a compliance rate for patient observations performed. by unit each month. We have 4 hospital units and the expectation is that one patient observation will be performed on each shift on each unit.
During a 31-day month, there should be 93 observations per Unit. During a 30-day month, it would be 90, etc.
I created a calculated field called 'Observation Compliance' with the goal of getting a compliance rate for the month, by unit; however, it is only returning the count of observations.
I tried using and LOD expression (maybe it's my order of operations), or else I'm just overengineering the calculation altogether.
Here is the expression with the packaged workbook attached:
If DATE([Date of Observation])>=⌗November 1, 2023# and DATE([Date of Observation])<=⌗November 30, 2023# THEN {FIXED [Unit]: COUNT([Continuous Observation Data])/90}
ELSEIF DATE([Date of Observation])>=⌗December 1, 2023# and DATE([Date of Observation])<=⌗December 31, 2023# THEN {FIXED [Unit]: COUNT([Continuous Observation Data])/93}
ELSEIF DATE([Date of Observation])>=#January 1, 2024# and DATE([Date of Observation])<=#January 31, 2024# THEN {FIXED [Unit]: COUNT([Continuous Observation Data])/93}
ELSEIF DATE([Date of Observation])>=⌗February 1, 2024# and DATE([Date of Observation])<=⌗February 29, 2024# THEN {FIXED [Unit]: COUNT([Continuous Observation Data])/87}
END
Any help would be greatly appreciated.
Thank you,
Jason
See if this works better for you:
{FIXED [Date of Observation], [Unit], [Patient Name]: IF DATE(MIN([Date of Observation]))>=⌗November 1, 2023# and DATE(MIN([Date of Observation]))<=⌗November 30, 2023# THEN COUNT([Continuous Observation Data])/90
ELSEIF DATE(MIN([Date of Observation]))>=⌗December 1, 2023# AND DATE(MIN([Date of Observation]))<=⌗December 31, 2023# THEN COUNT([Continuous Observation Data])/93
ELSEIF DATE(MIN([Date of Observation]))>=#January 1, 2024# AND DATE(MIN([Date of Observation]))<=#January 31, 2024# THEN COUNT([Continuous Observation Data])/93
ELSEIF DATE(MIN([Date of Observation]))>=⌗February 1, 2024# AND DATE(MIN([Date of Observation]))<=⌗February 29, 2024# THEN COUNT([Continuous Observation Data])/87
END }
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
