-
Notifications
You must be signed in to change notification settings - Fork 3.5k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[HELP] Calculate total time based on binary value #8308
Comments
Did you ever figure out a way to do this? I have a very simular scenario. |
Not really... |
Hey @psellers89, I've been looking for a display like this in Grafana for boolean data, how did you do it? |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. |
This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions. |
Hello,
I am using influxdb to monitor my reservoir water level and record the pumps power (ON/OFF).
I receive the data from a LORA node, around every 10-15 seconds, it is not regular.
I would like to query the influx database to know how long the pumps were ON on the last 24 hours.
As I only insert a binary value (0 or 1), not on regular basis, I didn't find a way to do this.
Please check the screenshot from grafana, I want to know the total time of the green areas : http://i.imgur.com/G2POW9X.png
Do you have any idea how to do this ??
Thanks
The text was updated successfully, but these errors were encountered: