Help

Formula for Cumulative sum for the last 30 days

Topic Labels: Formulas
731 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Max_Hoogeweg
4 - Data Explorer
4 - Data Explorer

Hello, I’m trying to find a way to get a cumulative sum from the last 30 days that needs to be updated daily.
image
This is all I have at the moment.
(PS: The numbers on the left are IDs.)

2 Replies 2

There are a couple ways to accomplish this. One would be a scripting extension that you have to manually run, but which can spit out your updated value every day.

Another way would be to create a View that filters to only show records from the last 30 days:
CleanShot 2022-10-20 at 08.46.46

And then just look at the summary bar at the bottom every day to get your updated value (records that are 31 days old and older will automatically drop off the View at Midnight in the selected Timezone).

If you don’t want to have to go reference the View for your value, you could combine that filtered view with a Summary extension that Sums the value from a field for all records in that view:
CleanShot 2022-10-20 at 08.50.29

Those are probably your best options, although there are others.

Thank you for your response. However, since I am currently unable to extract the sum, how would I go about changing the formula to make it cumulative? Any assistance would be greatly appreciated.