I’m currently working on add graph widget to a new relic dashboard . Dashboard query contains dynamic parameters . I need to get data for all requests for that API call . My query is below

We are using the java agent to monitor service calls etc.
There are several features such as slow query logging that new relic agent offers, but we don’t want to have switched on by default due to performance overhead etc.

in our newrelic.yml we have:

Our java spring boot web app runs in AWS. We want to use newrelic to monitor the api endpoints and their timings. We dont want anything else, as we cant afford it. AWS sends our logs to our self install of ELK.

We cant find any concept of environment in new relic.

When am using this query can see the graph with thousands of errors.
select count() AS ‘Total Errors’ FROM TransactionError where tags.environment = ‘PROD_US’ and (tags.scenario like ‘CCMHost%’ or tags.scenario like ‘Driver%’) FACET appName since 7 day ago UNTIL today TIMESERIES 1 day
Same Query i converted for getting percentage like below. But am not seeing anything all are showing zero.
SELECT
filter(count(), WHERE tags.environment = ‘PROD_US’ AND (tags.scenario LIKE ‘CCMHost%’ OR tags.scenario LIKE ‘Driver%’) AND error IS true) * 100.0 /
filter(count(*), WHERE tags.environment = ‘PROD_US’ AND (tags.scenario LIKE ‘CCMHost%’ OR tags.scenario LIKE ‘Driver%’))
AS ‘Error Rate (%)’
FROM
TransactionError
FACET
appName
SINCE 7 days AGO
UNTIL today TIMESERIES 1 day