Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I just can't figure out how to create a gauge to show a simple status.
I have a table with a list of servers and a comment field showing if they are patched or not.
eg
Server Patch Status
SERVER01 Patched
SERVER02 Not Patched
SERVER03 Patched
SERVER04 Patched
SERVER05 Not Patched
I want to be able to show the % of servers patched, against the total number of servers displayed in a guage.
So servers which are patched are green on the gauge, and those not patched would be red on the gauge.
Any advice would be really appreciated.
Thanks
Nigel
Hi,
Your Gauge Expression should be as below.
count({<PatchStatus={"Patched"}>}Server)/ count(Server) * 100
PFA the sample that helps