Is it possible to Filter devices and add fields to data to InfluxDB ? about rtl_433-hass-addons HOT 3 CLOSED

Oh! You can use something like GROUP BY time(1w) I think. I do this by day for electricity costs.

Here's the query as text. I'm still on influx 1.x, but I would be shocked if there wasn't equivalent functionality in the 2.x queries:

SELECT sum(mean) / 1000 / 3600 * $electrical_rate / 100  FROM (SELECT mean(value) FROM "W" WHERE $timeFilter GROUP BY friendly_name, time(1s) fill(previous)) GROUP BY friendly_name, time(1d);

from rtl_433-hass-addons.

Is it possible to have the ouput (to influx) just some devices? Not all devices found by RTL_433 dongle?

Sure. You can configure Home Assistant's influx addon to only send some device data. But assuming you don't care about the data in home assistant either, the best thing to do is a combination of limiting protocols in the rtl_433 configuration, plus only running the discovery addon when actively adding new devices.

Always with data sent to my Influx DB, is it possible to add field like "years" or "months" (maybe in config file) to make easiest use in Grafana?

I'm not sure what you're getting at here, but generally we emit ISO timestamps. That's what influx expects too - a single time field. However, I would expect you can convert the dates for display as needed with Grafana.

from rtl_433-hass-addons.

Thanks for your answer.

Sure. You can configure Home Assistant's influx addon to only send some device data. But assuming you don't care about the data in home assistant either, the best thing to do is a combination of limiting protocols in the rtl_433 configuration, plus only running the discovery addon when actively adding new devices.

I hadn't think it, I'm going to do this (configure Home Assistant's influx addon).

I'm not sure what you're getting at here, but generally we emit ISO timestamps. That's what influx expects too - a single time field. However, I would expect you can convert the dates for display as needed with Grafana.

For example, I'd like to sort data by years or by months like this :

I use influxDB v2. In Grafana, I can't do this (It might be possible but I don't know how to do it.).

In the config file, I have indicate : "report_meta time:iso:tz:local".

from rtl_433-hass-addons.