I manage a VDI offering and we have a "small", "medium", and "large" VDI offering, depending on user needs. I am setting up super metrics that report the average CPU and Memory on a per user basis, not VM basis due to non-persistence. The metrics below show a custom metric we created (teal), CPU % (pink), and Mem % (purple). The metrics generated while the user is logged on are perfect, however, when the user is logged off, the metrics report a value of zero "0".
This is breaking our "view"/report because we are trying to get an average because the average is including the 0 values when the users are not logged in. So non working hours are draging down the value. The picture below shows the skewed data from the user above. The CPU and Memory usage that are reported are drastically lower that the average during an active user session.
I have seen some metrics that report NULL values when there is nothing to report. For instance, Session|User Desktop Duration Last Interval reports null (instead of 0) when the user is not logged in.
Is there any way to have my supermetrics report a null value instead of 0 when the user is not logged in?
Here are the existing metrics as I have them: