Hi, I am using influxdb for my energy consumption data. I would like to create a continuous query (Not found any other way supported by influxdb) where I would after every hour run a CQ which would add a hour tagkey. Ex. Value Time 4 2019-01-01 00:00 - 01:00 --> Run QC to ne…

Continuous query - tag hour in day

Stian_Braa April 20, 2019, 2:16pm 3

Hi,

In the end I would like to get data from multiple days and sum the energy consumption per hour in a day:

The only way I have found that might work is to create tags with the hour of day.

br
Stian

Topic		Replies	Views
Continuous Query with tags and time() Kapacitor cq	5	2083	July 5, 2021
Calculation of energy-counter data Fluxlang	2	1380	April 17, 2019
Daily continuous query gets timestamp of previous day influxdb , time-series , query	6	2756	November 7, 2020
Delay continuous queries execution influxdb	0	1007	April 2, 2018
Trying to understand continuous queries (I think) Store	5	1774	April 17, 2019