0

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

Konrad Marciniak
  • 1

1 Answers1

1

It's now possible, since October 2022:

SELECT average(if(
  externalDuration > 0, 
  externalDuration, 
  ThirdPartyConnection))
FROM Transaction
TIMESERIES auto
zessx
  • 68,042
  • 28
  • 135
  • 158