ryanfliehman
Contributor II
2021-01-22
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculating 3 month Rolling Average w/ If Statement
Hello,
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]))
416 Views
0 Replies