Events to Metrics Query is NOT working

[ptahdunbar]

Events to Metrics Query is NOT working

Description

Hi,

As part of long term reporting, we created couple of metrics, especially the "Sum.Transaction.tankeringSavings.summary.Filtered" and "Transaction.Tankeringsavings.summary.Filtered". 

If you notice the queries created behind the scene by the NR does NOT work ( doesnt return any data)

FROM Transaction SELECT summary(`Tankering savings`) AS 'Transaction.Tankeringsavings.summary.Filtered' WHERE appName ='busine-aviation-fue-service-prod' and tankeringSavings is not null FACET `customerNumber`, `tailNumber`.

Ideally the query should be

FROM Transaction SELECT SUM(tankeringSavings) AS 'Transaction.Tankeringsavings.summary.Filtered' WHERE appName ='busine-aviation-fue-service-prod' and tankeringSavings is not null FACET `customerNumber`, `tailNumber`.

So the metric does not work for us in reporting.

Thanks

Steps to Reproduce

• Create a new aggregated metric
• Select it to open the mini-overview window.
• Copy/paste the code snippet for "NRQL used to create this rule"

Expected Behaviour

The NRQL provided in the E2M app should return valid NRQL.