Query for custom attribute

Hi,

Could you please help me rewrite request so that it works? I have like that

SELECT sum(`epm.rms14-item-processor.app.service.message-processor.counter`) from metric WHERE result.status in ('error') and application = 'rms14-item-processor' and environment = 'staging-c20' / (select sum(`epm.rms14-item-processor.app.service.message-processor.counter`) from metric where result.status in ('error', 'success') and application = 'rms14-item-processor' and environment = 'staging-c20') SINCE 1 days ago

And now it doesn’t work.

Hi @Artem.Sorokin, Could you send us a link to the account that you’re running this query on? (Only New Relic employees can access this link)

Hi @zahrasiddiqa, sure
https://insights.newrelic.com/accounts/2685761/query?hello=overview&query=SELECT%20sum(`epm.rms14-item-processor.app.service.message-processor.counter`)%20from%20metric%20WHERE%20result.status%20in%20('error')%20and%20application%20%3D%20'rms14-item-processor'%20and%20environment%20%3D%20'staging-c20'%20%2F%20(select%20sum(`epm.rms14-item-processor.app.service.message-processor.counter`)%20from%20metric%20where%20result.status%20in%20('error',%20'success')%20and%20application%20%3D%20'rms14-item-processor'%20and%20environment%20%3D%20'staging-c20')%20SINCE%201%20days%20ago

Hi @Artem.Sorokin, Are you attempting to use two select statements in a single query? If so, I’d like to clarify that nested queries are not a supported feature yet.