Cumulative sum

[Feng Jin Liew]

I have this formula but I am trying to modify it to calculate cumulative sum of data every 3 minutes. The data I have are generated every 0.03 min. What should I put in the periods (blank) here or do I need another formula?

$Periods = periods( blank ) 

$average = $acc.aggregate(average(), $periods, durationkey()) 

$difference = $acc - $average 

$difference.aggregate(sum(), $periods, durationkey())

[Teddy]

I think you are looking for this.

periods(3min,3min)

 

[Teddy]

If the above doesn't get you what you are looking for can you attach a screenshot with a drawing of your goal?  I didn't fully understand what you were doing with the sum() aggregate at the end so the periods formula I supplied might not help with that part. 

[Feng Jin Liew]

Hi Teddy,
Thank you for the response. I have a set of data that are measured every 0.03 mins and I would like the data to be visualized as a cumulative sum of every 3 mins. I may have used the wrong formula. How should I share the worksheet with you? 

[Siti Tay]

Hi Feng.

Can you give a try this formula and let me know if it works

$SumRange = periods(3min)
$signal.runningSum($SumRange)

 

[Feng Jin Liew]

That works!