Ubidots Community

[SOLVED] Resetting cumulative sum

I’ve created a synthetic variable that calculates daily degree days based on daily max and min temperatures.
Now, I would like to show the accumulation from a certain date. I’ve created another synthetic variable that uses cumsum(degree days), which works nicely. Except, I would like to be able to set a start date (eg: accumulate since Jan 1). Or be able to reset the accumulation at some point. Is this possible or will it accumulate forever?

Good day @andynad

Thanks for sharing your question with the community!

If you only want to show the accumulation, I’d suggest using any widget in your dashboard for the synthetic variable that you’ve already created and configuring it with the sum aggregation method. This way, you could select the date range in which you want this aggregation method to be done.

Below, you can see an example of how to create a widget with this aggregation method, all you need is to write the variable label of your synthetic variable where I wrote the label temp. As you can see, you could also be able to set a date range to make the accumulated

I hope this would be useful for you!

All the best,

Hi Ángela,
That’s a simple enough solution. Ideally, I wouldn’t mind being able to show a chart with the increasing values, but showing the sum will suffice.

1 Like