Only count positives values

[casanovareina]

Hi, quite new to grafana.
I spent the last two days trying to solve this.
I got a graph with positives and negatives values. How can I just use positives to do a sum.
this is the graph

It represent the power taken from the grid (positive values) and power injected to the grid (negative values)
Thanks !!!

[bfilmer]

Any luck here?
I am trying to do exactly the same thing in flux.
Solar edge power meter by any chance?

Now I am looking at splitting out the values into two new columns using node red before it is written to influx

[casanovareina]

nah, I left for now. I´ll go back to it later

[akseth]

I was looking for same and after some tries found the solution with the help of transformations. Below is my transformation query:

FYI: My data is sourced from InfluxDB.