SELECT postgres data by influxDB values

Hello guys,

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