I’m having great difficulty in achieving the following from NRQL.
Basically I’m adding two custom parameters like
Custom/MyAttribute/Two (both are mutually exclusive) (I’m adding only one parameter based on a logic per AwsLambdaInvocation)
And what I’m trying is
SELECT sum(Custom/MyAttribute/One)+ sum(Custom/MyAttribute/Two) as 'Total Relics' from AwsLambdaInvocation FACET basicParam SINCE 7 days ago limit max
And this always returns no data available.
But if I try getting individually like
SELECT sum(Custom/MyAttribute/One) as 'Total Relics' from AwsLambdaInvocation FACET basicParam SINCE 7 days ago limit max
it will always work.
Can someone help me to achieve sum of both attributes?