'NRQL IF statement to select wanted value

I'm trying to get one result from query in NRQL, when external is bigger than 0 then it should return average(external), if not average(thirdparty). If that was SQL, it would be easy.

SELECT  average(externalDuration) FROM Transaction...

What I want:

SELECT IF(externalDuration>0,average(externalDuration), average(ThirdPartyConnection))FROM Transaction...

I don't know if it's even possible

performancenewrelicnrql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions