What Grafana version and what operating system are you using? Grafana v9.5.2 (cfcea75916) on Raspbian What are you trying to achieve? I want to sum up a difference between two series, but only the positive values. Background is that I have a energy consumption and a energy production time ser…

I got it working with the help of @fercasjr ’s hint. Thank you all for your help! [image] Key was to only apply the transformation to the “Netzbezug”.

Welcome Are you using influxql or flux query language? Could you post your query here?

I’m using the standard editor. The first query looks like this, the second analogue: SELECT mean("value") FROM "autogen"."sensor.stromzahler_power_curr" WHERE $timeFilter GROUP BY time($__interval) fill(linear) The expression is just a math expression $A - $B

So that is influxQL query language.

Where is the query for $A or $B not sure which one yoir query refers to

It’s no query but just an expression. $A is the consumption, $B is the production [Screenshot_20230529-203801]

[image] guerda: $A is the consumption, $B is the production Yes but those expressions comes from queries right? please show us what the source query of those expressions are?

Here are the two queries: $A SELECT mean("value") FROM "autogen"."sensor.stromzahler_power_curr" WHERE $timeFilter GROUP BY time($__interval) fill(linear) $B SELECT mean("value") FROM "autogen"."sensor.power_production_now" WHERE $timeFilter GROUP BY time($__interval) fill(previous)

Is there a possibility to generate this via the InfluxQL? Something like this (pseudo SQL): select max(0, ("autogen"."sensor.stromzahler_power_curr" - "autogen"."sensor.power_production_now" ) from .... ?

Hi @guerda How about this? $A SELECT mean("value") FROM "autogen"."sensor.stromzahler_power_curr" WHERE $timeFilter AND "value" > 0 GROUP BY time($__interval) fill(linear) $B SELECT mean("value") FROM "autogen"."sensor.power_production_now" WHERE $timeFilter AND "value" > 0 GROUP BY ti…

The single values are always greater zero, only the difference can be negative. I understand your queries that it would only filter out the series individual values which are 0 or lower. Am I getting this right?

Sum up only positive values of expression in time series

Grafana Dashboards

guerda May 29, 2023, 6:39pm 6

It’s no query but just an expression. $A is the consumption, $B is the production

Topic		Replies	Views
Only count positives values InfluxDB	3	3303	June 14, 2022
Split positive and negative values into two separate fields Dashboards	26	2748	August 4, 2023
Addition of queries via Expression option not working Grafana templating , influxdb , query-help , dashboard , query-editor	14	7891	February 14, 2024
How to use Expressions for calculations? Dashboards expressions	0	562	March 28, 2023
Visualization of solar panel with consumption InfluxDB	6	778	April 28, 2024

Sum up only positive values of expression in time series

Related topics