I'm trying to get show the availability for some servers. The problem I'm having is showing when a server has 100% availability, because there are no records of downtime.
I've tried this (QlikFit: Set analysis that ignores all selections except a few) solution but I couldn't get it to work. Anyone got a suggestion how to solve this? It might be a easy fix but I'm pretty stuck and been staring at this problem for far too long.
See the attached file for more information.
The original post were I got some help fixing my tables: