Display nothing when no Data is in Postgresql

[starfoxfs]

Hi,

since i switched form InfluxDB to PostgreSQL i have Data Fields filled with Values that dont exists.

e.g.:

Here in PostgreSQL over the Night there are no values because WIFI/WLAN is turned off but PostgreSQL filles this fields with the latest existing value.

[jangaraj]

@starfoxfs

PostgreSQL filles this fields with the latest existing value

Please prove that statement with raw data (e.g. query inspector). I bet there are no data from PostgreSQL - they are just connected existing datapoints:

How to let the line break when data is missing for a long time?

I am using Grafana Community Edition to visualize data from InfluxDB. I find that if data is missing for a long time, the line graph will still connect the two points. What I expect is to have an option to break the line if the distance of two points exceed some threshold. For example, in the following case, it’s clean to find that there are 10 hours of missing points between the last two data points in the table view , but grafana still connect them in the graph view. [image] [image]

BTW you have heavy query, customize this for you needs:

SELECT
  $__timeGroupAlias(timecolumn, $agg, 0),
  AVG(value) AS "metric"
FROM table
WHERE
  $__timeFilter(timecolumn)
GROUP BY 1
ORDER BY 1

Read the doc to understand the used macros:

PostgreSQL query editor | Grafana documentation

[starfoxfs]

@jangaraj

$__timeFilter(timecolumn)

Yeah this works:

SELECT $__timeGroupAlias(time, 1m, 0), AVG(value) AS solarertrag FROM solar WHERE $__timeFilter(time) AND field = 'watt' GROUP BY 1, value ORDER BY 1, value

But also works this: