https://community.qlik.com/t5/QlikView/Calculating-3-month-Rolling-Average-w-If-Statement/m-p/1776744#M454915 <P>Hello,</P><P>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.</P><P>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.&nbsp;</P><P>Avg(If([ENCOUNTER.PATIENT CLASS]='Emergency' and Match([Procedure.Code],'LAB8581'),[LAB TEST.FIRST FINAL VERIFIED INSTANT]-[ENCOUNTER.ADMISSION INSTANT]))</P> Sat, 16 Nov 2024 17:35:19 GMT ryanfliehman 2024-11-16T17:35:19Z https://community.qlik.com/t5/QlikView/Calculating-3-month-Rolling-Average-w-If-Statement/m-p/1776744#M454915 <P>Hello,</P><P>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.</P><P>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.&nbsp;</P><P>Avg(If([ENCOUNTER.PATIENT CLASS]='Emergency' and Match([Procedure.Code],'LAB8581'),[LAB TEST.FIRST FINAL VERIFIED INSTANT]-[ENCOUNTER.ADMISSION INSTANT]))</P> Sat, 16 Nov 2024 17:35:19 GMT https://community.qlik.com/t5/QlikView/Calculating-3-month-Rolling-Average-w-If-Statement/m-p/1776744#M454915 ryanfliehman 2024-11-16T17:35:19Z