Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to find the average age of servers but the problem is some of the servers have negative numbers. Is there a way to get the averages only when the age_of_servers > 0??
=avg( if(age_of_servers >0, age_of_servers))
or
=avg({<age_of_servers = {">0"}>} age_of_servers)
=avg( if(age_of_servers >0, age_of_servers))
or
=avg({<age_of_servers = {">0"}>} age_of_servers)