Cumulation of values

Hello!

I am currently working with Grafana v8.2.4 (d409b0ca16) on Microsoft 10.

I tried to cumulate some values from my database, but somehow I miss a detail. My goal is to create a time series graph with process values (which worked fine) and to cumulate those values over the time span. (that worked fine as well).
Now the problem is, I want to do a calculation before adding the new value on top of the others.

I used the SUM OVER function, and tried many different bracket styles, however as soon as I add any sort of calculation it does not work. No values are found/shown.

I am hoping to create a rising graph over the observed time, adding up the masured values.

SUM() OVER(ORDER BY()) is what I have used. I also wanted to try “transformation”, but I could not find the cumulative sum tab there.

I am as well looking for a solution to implement my excel calculations, which cumulate eg. the process time and start that in the famous blank cell.

Thanks a lot for your help!

is your field a number or string value?