Calculating 3 month Rolling Average w/ If Statement
I'm trying to figure out how to calculate a 3 month rolling average for a turnaround time in a combo vizlib chart using MonthYear as my X-Axis.
Below is the criteria I used to come up with the average by month but when trying to calculate a 3 month rolling average using the criteria below I run into issues. Any help would be greatly appreciated. criteria.
Avg(If([ENCOUNTER.PATIENT CLASS]='Emergency' and Match([Procedure.Code],'LAB8581'),[LAB TEST.FIRST FINAL VERIFIED INSTANT]-[ENCOUNTER.ADMISSION INSTANT]))