There was a forum post a long while back about avoiding having to create formulas that add up PREV(1) + PREV(2) + ... + PREV(N) periods to get a rolling average or sum. I can't find it now but it referenced an undocumented function for rolling previous periods - something like RPREV(), but that's not working for me.
Ring any bells?
Hi wallingfordce,
I'm not able to find specific post, but we do support using R in formulas. Here is the documentation on that. https://docs.sisense.com/main/SisenseLinux/using-r-in-formulas.htm
This post may also help. https://community.sisense.com/t5/build-analytics/prev-query-getting-error/m-p/3369
The "may also help" I already reviewed and outlines the "PREV() series" solution I'm hoping to avoid. And I'm definitely not talking about using R. It's just that the memory I have of the "Running Previous Periods" function was something like RPREV instead of PREV, like RSUM instead of SUM.
Thanks for trying to help though - I appreciate it!
