Hello, I am trying to get a query to return the correct number of minutes (or hours) using stateDuration for a metric collected every 10 minutes. Here is what I have but it returns odd results: from(bucket: “my-bucket”) |> range(start: 2023-11-02T21:45:54.088Z, stop:2023-11-09T22:45:54.088Z) |> f…

Hello @Ryebot33 , Welcome! How are the results weird? It’s hard to me to tell what’s wrong without your expected output and desired output.

@Anaisdg Thank you for the response! Sorry, it definitely would have been helpful to post how the results are showing. So I have a reading that has been in the same state (a value of 1) for a week, and with the stateDuration units set to 10 minutes, I am getting a reading of 2.23 day when I put the …

@grant1 This was exactly it! Thank you, I had not found that thread before. Thank you so much!

Great. Please mark above as Solution so others can find.

stateDuration for metric collected every 10 minutes

Fluxlang

grant1 November 11, 2023, 11:20pm 4

@Ryebot33

Have you read through this? It sounds like you are trying to do the same thing. Not saying that stateDuration will not work, but I used elapsed in the aforementioned thread

Topic		Replies	Views
stateDuration, wrong output Fluxlang	4	725	January 24, 2020
Elapsed duration Fluxlang flux	1	721	October 10, 2019
How to get total duration of state? Fluxlang influxdb , time-series , influxdata , flux	4	3223	November 19, 2021
How to use stateDuration? Kapacitor kapacitor	3	3293	September 25, 2017
How to retrive total duration based on a value state? Fluxlang influxdb	0	331	April 4, 2023

stateDuration for metric collected every 10 minutes

Related topics