Hi all,We're trying to create a rolling 30-day average in one of our bar chart widgets. I've tried using different solutions found online, but they all involve RPAVG, CURRENTDATE or other window functions that seem to break our connection to the live model or throw an unexpected token. An example we found was the following: AVG( [ Total Value], RANGE ( PREV ( [Days in Date], 30 ), CURRENT([Days in Date]))) from which we got the 'not supported by Live Model' erro...

Hey DRay, following up in case this issue comes up in the future - I got back from support the following:We're sorry for any inconvenience, but the following function is no longer officially documented or supported. It was deprecated some time ago, but it hasn't been removed from the product yet. Thank you for your understanding.I did make a forum post to suggest adding a new version of these RP functions over at Product Feedback. Thanks again for the help

Rolling 30-Day Average | Help and How-To

MoreDiscussions

Rolling 30-Day Average | Help and How-To | Sisense Community