@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?
Anaisdg
8
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to sum the max value of every day, month and year? | 0 | 558 | December 11, 2022 | |
| Display Max Value Over Selected Time Range | 1 | 1958 | July 21, 2021 | |
| How to get maxValue and it`s time | 2 | 111 | November 29, 2024 | |
| How can I get the date of the 'max' value measured by 'aggregateWindow' in InfluxDB? | 1 | 94 | November 4, 2024 | |
| The MAX value query for time span | 0 | 459 | February 6, 2022 |
