Jump to content

Cumulative sum


Recommended Posts

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())

Link to comment
Share on other sites

  • Administrators

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. 

Link to comment
Share on other sites

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? 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...