How to calculate interrupted datasets?

[Quito96]

In my dataset, an energy meter has added up the values.
Unfortunately, when it is switched off, it starts again at zero. in this case, the correct

sum is therefore 2624+665=3288 W/h

Ideas /Methods on how to automatically calculate interrupted measurements over a period of time?
Any R Package ?

Many thanks in advance

[technocrat]

Hard to be very specific with just the screenshots. See the FAQ: How to do a minimal reproducible example reprex for beginners. It looks like you want to create a column that contains the first series as is, and continues with cumsum lagging by 1 period.

[xvalda]

cumsum seems indeed the right way to go
I created a simple example, imagining that a counter can reboot to 0 several times:

suppressPackageStartupMessages(library(tidyverse))
kwcount <- c(0, 2, 4, 6, 8, 0, 2, 3, 12, 0, 0, 5, 9, 12, 16, 20, 23, 0, 0, 3)
(df <- enframe(kwcount) %>% rename(c("ID" = "name", "kwcount" = "value")))

Then find difference between 2 measurements (this is why we need kwcount_lag), and apply cumsum.

df %>% mutate(
  kwcount_lag = lag(kwcount, default = 0), 
  kwcount_diff = ifelse(kwcount - kwcount_lag >= 0, kwcount - kwcount_lag, kwcount),
  kwcount_real = cumsum(kwcount_diff)
  )

[Quito96]

@xvalda

df %>% mutate(

What can I say? You have brought it precisely to the point.
I am thrilled and have already implemented your code.
Many thanks xvalda

Now I don't have to repeat or manually correct measurement series where my wife switches off the energy counter.

[xvalda]

Glad it helped! Now you can have fun switching the counter on and off