I am using Grafana to display Total, Active and Inactive devices. I could calculate the Total Devices and Active devices and display them in individual single stat tile. Now I want a third tile that will show the Inactive Devices (by subtracting Total and Active devices).
My dashboard looks something like this.
Can you please help me out with a suitable way to do this in Grafana?
Thanks in advance.