@joschika77, you could include tags that specify the month at ingest. For example, I would write a python script that adds the months in tags based on the timestamp. You could also run 12 continuous queries for each month and output the max value into a new db. If you need to apply a CQ to historical data, you can backfill your old data by doing something similar to: Backfilling a Continuous Query?
Related Topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
The MAX value query for time span | 0 | 380 | February 6, 2022 | |
Query aggregation question | 1 | 433 | August 27, 2020 | |
InfluxDB 2 - get specific mean values | 2 | 646 | April 20, 2022 | |
How can I get a maximum value in the point? | 0 | 601 | August 16, 2019 | |
Single query to obtain data grouped by time in a specific fashion
|
0 | 315 | February 3, 2020 |