Hi Folks,
I have a data point coming in via SNMP. If the value of the data is zero, I do not want it interfering with an average. 0 would basically show it is not iin use, while I want to get an average of the quality on a daily basis which will be a positive number.
So, with an aggregate item, maybe even calculated, is there a way to filter out 0 from impacting the average?
I can only think to do this from a script, which is not ideal: if value is zero, return nothing.
I have a data point coming in via SNMP. If the value of the data is zero, I do not want it interfering with an average. 0 would basically show it is not iin use, while I want to get an average of the quality on a daily basis which will be a positive number.
So, with an aggregate item, maybe even calculated, is there a way to filter out 0 from impacting the average?
I can only think to do this from a script, which is not ideal: if value is zero, return nothing.