@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 | 435 | February 6, 2022 | |
Query aggregation question | 1 | 480 | August 27, 2020 | |
InfluxDB 2 - get specific mean values | 2 | 718 | April 20, 2022 | |
How can I get a maximum value in the point? | 0 | 693 | August 16, 2019 | |
Single query to obtain data grouped by time in a specific fashion
|
0 | 357 | February 3, 2020 |