Push Data to InfluxDB - problem with merging "Temperature" values from different sensors

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
marivesel
Posts: 4
Joined: Saturday 28 November 2020 12:21
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Push Data to InfluxDB - problem with merging "Temperature" values from different sensors

Post by marivesel »

My Domoticz setup is working perfectly fine on its own for several months now, but I want to push the data from it to InfluxDB.
I have created the new database and communication works, pushing/receiving, but the problem is as follow:

I have several temperature sensors, connected to Domoticz.
When I add two (or more) of these temperature sensors in the InfluxDB Push Data menu, both sensors push their data on the same influx measurement, called "Temperature". This cannot be renamed or changed in Domoticz, so I can't push different measurement.

In the following example I have "Boiler temp" and "Outside temp", respectively lets say 56C and 5C
If I add them both to push to InfluxDB via Domoticz menu, the values of the two sensors is sent to one "Temperature" measurement in influx database, and the data looks like garbage.

How can I separate the temperature sensors, so each of them sents on it's own differently named measurement?
4564.jpg
4564.jpg (78.83 KiB) Viewed 334 times
Stratos
Posts: 9
Joined: Friday 02 September 2016 6:45
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Push Data to InfluxDB - problem with merging "Temperature" values from different sensors

Post by Stratos »

This should work without bothering about the name.
Influxdb stores more than the names i.e. "Temperature", it comes with "idx" etc.
To visualize the time series of a specific sensor you have to expand the statement in i.e. Grafana
with the index of your sensor.
i.e. SELECT mean("value") FROM "Temperature" WHERE ("idx" = '388') AND $timeFilter GROUP BY time($__interval) fill(null)
marivesel
Posts: 4
Joined: Saturday 28 November 2020 12:21
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Push Data to InfluxDB - problem with merging "Temperature" values from different sensors

Post by marivesel »

Thank you very much @Stratos, that worked!
I am very new with influxDB and didn't know that it stores the idx also.
Happy Chrismass :)
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 1 guest