Struggling with scatterplot / XY Chart

Grafana
1

Hi,

My data is stored in InfluxDB v1.8. With that in mind, I want to draw a XY chart / scatterplot of 2 time series from different measurements. As I came to understand, InfluxDB v1 does not support joins, so I’m stuck with 2 Grafana queries and am trying to find a way combining them.

Query A

SELECT mean(“Ext.indoor_ambient_sensor(R6T)”) FROM “espaltherma” WHERE “topic”::tag = ‘espaltherma/ATTR’ AND time >= 1735689600000ms and time <= 1738367999999ms GROUP BY time(1d) fill(null) ORDER BY time ASC

Query B

SELECT difference(max(“total_energy_consumption_kwh”)) FROM “mtr” WHERE “topic”::tag = ‘mtr/hvt/heat’ AND time >= 1735689600000ms and time <= 1738367999999ms GROUP BY time(1d) fill(null) ORDER BY time ASC

Any hints or thoughts are welcome.
Thank you.

1 Like
2

Hi,

I think we’ll need some sample data to help :smile: What do you have now (sanitized data preferably in table mode), what do you want to achieve (e.g. some screen / paint picture :smile:, data in table mode).

3

Thanks for answering. I think I’ve found a solution in the mean time: using a Grafana transformation (OUTER JOIN) to combine the 2 formerly distinct tables into one table that can be used as input for the XY chart. Something that is surely achievable with a database supporting JOINs by itsown. However, and as I wrote before, InfluxDB v1.8 does not support JOINs of any quality, so my “detection” of Grafana’s transformation feature solved it.

Thanks again.

1 Like