Cumulative and other "expansions" to metrics

[siljamardla]

The pattern of defining a metric and then needing its cumulative value over a period X is extremely common.
Any ideas on how to enable something about cumulative metrics, while keeping it flexible around the periods?

It is very restrictive to define something like revenue_90days - each new window would require defining a new metric, and making sure its definition stays aligned with the original revenue definition.
What would be nicely flexible and reusing the main definition would be something like cumulative: enabled. The user could then specify at query time the details on the cumulative window.

Very similarly, there will be requests for period-over-period absolute difference, period-over-period percent difference, period-to-date values etc.

[yuliia-puzanova]

Oh, I can relate to it so much!

[sfc-gh-wpugh]

I wonder if this could be solved by having a concept of parameters or variables? E.g. have a metric specified as:

AVG(myfield) OVER(ORDER BY day ROWS BETWEEN :day_cumulation PRECEDING AND CURRENT ROW)

And some parameter day_cumulation that has a default, but can be overridden in the query.