index=servers | eval serverId_NOT_present=if(isnotnull(serverId), 0, 1) | stats count as totalServers, sum(serverId_NOT_present) as missingServers by rack | eval missingPercentage=round(100*missingServers/totalServers, 2) | stats sum(totalServers), sum(missingServers), sum(missingPercentage) by rack ... View more