jber
December 21, 2020, 6:25pm
1
I need to register with “0” and “1”, when an item is deactivated and activated respectively.
Then with those records in the database, I must count the number of activations in a period of the query.
The problem is when I make the query in the next moment as seen in the attached image.
If I query between 00:30 and 2:30, the result is “0”.
I hope you can help me!
Anaisdg
December 28, 2020, 4:42pm
2
Hello @jber ,
I believe you’ll want run a task that uses monitor package to determine whether or not your state has changed and then you can write those state changes to a new bucket.
These blogs might be helpful:
Anaisdg
December 28, 2020, 4:43pm
3
@jber but please let me know if I can help you construct the task.
jber
December 28, 2020, 5:41pm
4
Anaisdg, if you can help me, I appreciate it. We have no experience with bucket and monitor package.
Thank you!
Anaisdg
December 28, 2020, 6:37pm
5
Hello @jber ,
What version of InfluxDB are you using?
jber
December 28, 2020, 7:26pm
6
Hello Anaisdg
We are using version 1.8.0
Regards!