Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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