Movingsum 12 month

Get Help
1

Hello everybody,
I am trying to do some windowing query with the GUI.
In SQL it should look,like this:
SUM(tg."nbdays_stop") OVER (ORDER BY tg."Month-Date" ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS movingsum_12_month,

For now, I did really complexe things like: sum of 12 offset, or cumulative sum of "nbdays_stop" - cumulative sum of offset("nbdays_stop" ,- 12).
Is there a simpler way ?

I have seen this topic but I havent found others :"Moving Metrics" + Date Operations in MBQL - #3 by lvgiacomin

Selfhosted version 0.53.3

thanks in advance for any help!

2

The GUI currently does not support creating "ROWS BETWEEN (n) PRECEDING AND CURRENT ROW" queries, the closest thing you could achieve with it is LAG/LEAD through the Offset custom expression.