I am trying to filter this data to just the year 2022, but the field "DepartEDDateTime" is a timestamp and I can't seem to get it to work in the if statement. Appreciate any help!
(count(if((DepartEDDateTime - LastReadyToAdmitDateTime)*1440 <=60 and [PatientClassName]= 'Observation' and year([DepartEDDateTime] = '2022'),[EncounterID]))
an easier way would be to add a YEAR column in your data model. where you define or load the field DepartEDDateTime, just add a new field defined by year(DepartEDDateTime) as your yearfield
this way in your expression or et analysis, you jut qualify your yearfield equal something
an easier way would be to add a YEAR column in your data model. where you define or load the field DepartEDDateTime, just add a new field defined by year(DepartEDDateTime) as your yearfield
this way in your expression or et analysis, you jut qualify your yearfield equal something
