How to make a condition in Grafana that checks 2 elements inside the panel and makes a conclusion in the 3rd element? I wanted to implement a check for opening the door lock in the rack. (1 - closed, 2 - open, 0 - error). The lock is powered by two inputs (A and B). If one input is disconnected, then the state of the lock should continue to be displayed as working. The logic looks something like this:
If A = 1 or B = 1, then C = 1 Else if A = 2 or B = 2, C = 2 Else if A = 0 or B = 0, C = 0.
The data comes from Zabbix.