I've created a template to access temperature sensors on my Mac OS X Servers, and am now able to track about a dozen temperature measurements.
This is kind of a lot of data when all I want to know is "how hot is the ambient air around the server" so I would like to make a calculated item that takes an average of 4 ambient temperature sensors. I've created a calculated item with this expression (broken on to multiple lines for clarity):
This works well on servers that have all 4 sensors. However, some servers only have a single power supply, so they're missing data for TemperaturePSU2InletAmbient.
Is there a way to structure this so that any missing items are just omitted from the average?
This is kind of a lot of data when all I want to know is "how hot is the ambient air around the server" so I would like to make a calculated item that takes an average of 4 ambient temperature sensors. I've created a calculated item with this expression (broken on to multiple lines for clarity):
Code:
(
last("TemperatureChunnelAmbientLeft")+
last("TemperatureChunnelAmbientRight")+
last("TemperaturePSU1InletAmbient")+
last("TemperaturePSU2InletAmbient")
)/4
Is there a way to structure this so that any missing items are just omitted from the average?
Comment