Dimensions for Guage

nigelapt — Tue, 28 Mar 2017 15:08:49 GMT

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.

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

Re: Dimensions for Guage

krishnacbe — Tue, 28 Mar 2017 15:37:02 GMT

Hi,

Your Gauge Expression should be as below.

count({<PatchStatus={"Patched"}>}Server)/ count(Server) * 100

PFA the sample that helps