To GoodData homepage

Replies posted by Jacques Sham

2 Replies

Jacques Sham
GoodData Employee
Jacques ShamGoodData Employee
published in Metrics and MAQL - KB articles

Running Total Function in GoodData Platform (Sum vs Runsum)

Hello Yurii,I have sent you a private message to follow up your question but I have not received your reply yet. Sorry for the late follow up. I don’t think MAQL allows you to sum/average with a rolling time frame, but I think my suggested MAQL query should work unless you do not wish to segment by month/year. I believe there is misunderstanding from my side, I strongly recommend you to join our community slack channel and there are specialists timely replied any questions about GoodData products related general and technical questions with the following link: gooddataconnect.slack.comJacques

3436
M
GoodData Employee
8 months ago
Jacques Sham
GoodData Employee
Jacques ShamGoodData Employee
published in Metrics and MAQL - KB articles

Running Total Function in GoodData Platform (Sum vs Runsum)

Hello Yurii,Thank you for reaching to me and I am happy to help!When using runsum, we should not use where clause to limit the timeframe. If you want to calculate TTM Revenue in my example, the easiest way to do is declare the following metric and put it in an insight and sliced by Month/Year:select runsum(revenue) rows between 11 preceding and current row with pf except Date(Order Date)This syntax allows you to add 12 revenue entries (Or 12 months) when you slice by Month/Year. But you must have the insight sliced by Month/Year in order to work. The “pf except Date” allows the metric to work even if you have data filter in the insight.Please let me know if it works on your side.Jacques

3436
M
GoodData Employee
8 months ago
Welcome to the GoodData Community!Cookie settings