HI! I am trying to create something similar to the transaction scorecard with some business rules and saving each calculated % for dashboards and reports. For example:
Login 99.30% availability in the time range, where we calculate this by doing "Number of Transactions - Transactions with Technical Errors / Number of Transactions" from a set of business transactions. We want this to see it online and also to have a daily and monthly ratio.
I tried this query that gives me the number that i want:
SELECT 100.0 * filter(count(*), userExperience != "ERROR") / count(*) FROM transactions WHERE application = "application example" AND transactionname = "login business transactions example" SINCE 1 minutes
But I cannot save that as a metric and also it is not exact when trying to see a 1 month period.
Is there a way to calculate this?
Is it possible to use Experience Level Management?
Regards
... View more