SELECT (filter(count(), WHERE appName = ‘az-address’ AND transactionType = ‘Web’ AND (duration1000) > 100) /count(*)) * 100 as
SLA BREACH FROM Transaction SINCE 1 day ago UNTIL now
I am running this query on the Transaction table to SLA breach percentage. Strangely output is unit is coming as a microsecond. I am wondering how I can fix this?
Any help will be appreciated.