Comments (3)
Oh! You can use something like GROUP BY time(1w)
I think. I do this by day for electricity costs.
![image](https://private-user-images.githubusercontent.com/255023/280466989-8fa4fe8e-577b-4794-a23d-f9a19e5fa5fa.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTUyNzg1OTAsIm5iZiI6MTcxNTI3ODI5MCwicGF0aCI6Ii8yNTUwMjMvMjgwNDY2OTg5LThmYTRmZThlLTU3N2ItNDc5NC1hMjNkLWY5YTE5ZTVmYTVmYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNTA5JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDUwOVQxODExMzBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00ZGQzMzQ1OGQxYjcwODZkZTc1NjYwYzQwYjFhNDBkYWI2ZmU4ZjVjOTU3MzliZDVkODc4Y2Q0N2M3N2I4YjkyJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.Kfdr5YVpK8_GfChDkDNRbeSUTH1B0nOv1U4pBQ3LUI4)
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.
Related Issues (20)
- rtl_433 MQTT Auto Discovery (next) does not start HOT 12
- How can you tell which version of rtl_433 you're actively using? HOT 6
- How to install in HA Core? HOT 4
- 0.4.1 Stopped receiving HOT 66
- Auto Discovery publishes SCMPlus time value, skips the rest such as gas meter consumption. Case sensitive? HOT 3
- Device added by Auto Discovery doesn't persist across reboots. "This entity is no longer being provided by the mqtt integration" HOT 2
- on AmbientWeather-TX8300 report Battery statur from rtl_433 MQTT Auto Discovery (next) HOT 6
- DEVICE_TOPIC_SUFFIX config problem HOT 8
- Enable devices disabled by default in config?
- New repository HOT 2
- New version 0.8.0 not working HOT 5
- rtl_433 MQTT Auto Discovery will not run after update HOT 6
- Support RTL-SDR Blog V4 Dongle HOT 3
- No MQTT topic visible HOT 2
- Latest version says rtl_433: option requires an argument: F
- Getting started HOT 4
- Config for device trigger conflicts with existing device trigger HOT 3
- rtl_433 does not start anymore HOT 4
- No MQTT topics created - No error in logs HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rtl_433-hass-addons.