Influxdb 1.8 query for Monthly Energy Usage

I have log total energy usage in every minute for 6 month from digital power meter. How the sql query to get monthly usage for all month. As i know sql query in influxdb is limited.

You just can’t, unless you got the Year, Month, date, or any other time-related “part” saved as a tag.
You can extract those using telegraf date processor if needed.

in influxDB, you can just query a “time” as an interval, the DB is not aware of what a day, week or month is.

1 Like

Thanks for your clear explanation. i will try that on telegraf date processor .n