I use PostgresQL database and an Influx time series database. The Postgres database is not in the time series format.
I want to get specific data displayed in a table in Grafana from Postgres Database by values from the influxDB.
I already managed to get the data into one table by using the Mixed Datasource and the concentrate fields transformation from Grafana.
for example in Influx i have the column _65226_11_2 if the value is != 0 I want to get the columns of the postgres where columnname1 = 11 and columnname2= 2
is it possible to do that?
Thanks in advance
Best regards Tobias