Hello Everyone! Im new to this Forum, appologies if this Topic isnt in the right Sub.
What Grafana version and what operating system are you using?
Grafana v8.2.3
-
What are you trying to achieve?
Summarizing multiple boolean Values over a given Period of time and displaying it as percentage in a Pie Chart. -
How are you trying to achieve it?
I am very unfammiliar with SQL and Databases in General. Appologies fot that!
Im a PLC technitian an somehow managed to get involved in a SQL Project…
Via the count Function im am Able to Count the Number of Times that the boolean Datapoints have gone from False to True within a given Time (Timefilter Function)
This is how my Data Table in Microsoft SQL looks like:
Here is what i have so far in Grafana:
This Pie Chart represents not the actual Status of the Maschine as it only Counts the rising Edge of the boolean Values. So im looking for a Way to Count the Percentage of those boolean Values over a specific Time Range.
E.g.: Time Range (2022-10-02T09:00:00 until 2022-10-02T10:00:00)
boolean Auto was True from 2022-10-02T09:00:00 until 2022-10-02T09:40:00
boolean Fault was True from 2022-10-02T09:40:00 until 2022-10-02T09:45:00
boolean Waiting was True from 2022-10-02T09:45:00 until 2022-10-02T09:55:00
boolean Auto was True from 2022-10-02T09:55:00 until 2022-10-02T10:00:00
This Example should lead to the follwing Result in the Pie Chart:
75% Auto; Fault 8,33%; Waiting 16,66%
Any Help to Achive this Goal will be greatly Appreciatet! And sorry for my English if there are some Things not easy to Understand.