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

Tried to change like this but not worked
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