Using V#QuarterAvg when quarter is not complete

erinvhudson
New Contributor

Can anyone offer any help when using View = Quarter Average on for example January 2023 data when the quarter being referenced is not yet complete?  It seems that the View will not work until the quarter is fully populated.

1 REPLY 1

VivienJ
New Contributor

Would v#trailing3monthAvg work for your example?