Hi @PetrusTheron and welcome to the InfluxDB forum.
Your situation sounds similar to this one. Did you read through this already and/or try it?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to get total duration of state? | 4 | 3186 | November 19, 2021 | |
| Summarize stateduration to have total "on" hours per day | 9 | 1178 | March 27, 2025 | |
| stateDuration for metric collected every 10 minutes | 5 | 274 | November 13, 2023 | |
| Calculate stateDuration based on conditional logic of another column | 11 | 289 | April 24, 2024 | |
| Elapsed duration | 1 | 718 | October 10, 2019 |
