yeah just like @niketn said... For me it even worked with just a table of those 3 fields (|table Control_Name, Compliant_IPs, Total_IPs), as long as Control_Name is unique, otherwise just use | stats sum(Compliant_IPs), sum(Noncompliant_IPs) by Control_Name. Noncompliant_IPs is ofc Total_IPs minus Compliant_IPs. and I would recommend to not use any spaces in field names. Try to use stack 100% to make it more visible, if it should only represent the percentage. ... View more

you can even do this with the same token: if(isnull($value$),"blank or other text", $token1$) ... View more