Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nigelapt
Contributor III
Contributor III

Dimensions for Guage

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

1 Reply
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Your Gauge Expression should be as below.

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

PFA the sample that helps