Could you explain a bit more about the calculation logic?
Here is my script. I hope it is understandable.
Num(If("ID"=Peek("ID"), "value"+Peek([Running Total]), "value")) as [Running Total]
Resident table_raw_data where created>=year(today()-1) Order by "ID", created ;
Also I see there are multiple values for single date 1'6-04-2018 00:04' in your target table, but you needed one value for every dates, right? Yes, I only need all the values from the same date, added together.