I have a duration metric that is populated every time a pipeline runs, i would also like to use this metric to see trends on how often the pipeline is run and the outcome. But because this is not very frequent a simple count on the timeseries does not give a very revealing graph. Instead i would need the sum over the time period for each datapoint to get a clearer picture, the equivalent of count_over_time in prometheus.
I see that i can do an array modification with arrayCumulativeSum or arrayMovingSum but i would need instead something related to time both options above also always start from a low sum which is not ideal.
Is there a way to do this?
