What Grafana version and what operating system are you using?
debian 11, 10.0.0-preview (package installed)
What are you trying to achieve?
Just a time series…
How are you trying to achieve it?
This is the query:
SELECT UNIX_TIMESTAMP(TIMESTAMP) AS "time", DEVICE AS metric, CONVERT(VALUE, DOUBLE) * -1 as Batterie_Entladung FROM history WHERE $__timeFilter(TIMESTAMP) AND DEVICE = 'sungrow' AND READING = 'Battery_power_discharge' ORDER BY TIMESTAMP
With this data:
|2023-09-13 20:22:28.000|sungrow|MODBUSATTR|Battery_power_discharge: 0|Battery_power_discharge|0|| |2023-09-14 15:29:30.000|sungrow|MODBUSATTR|Battery_power_discharge: 1931|Battery_power_discharge|1931||
Please have a look at the series in light green
What did you expect to happen?
I would think that the light green line would be on zero between the two data points
Maybe this is a configuration issue or is there a possibility to “optimize” the query?
I hope, this question is not already answered, I could not find anything…
Best regards and thanks in advance,