nr1-slo-r icon indicating copy to clipboard operation
nr1-slo-r copied to clipboard

Need an "all" option under transaction field to add all transactions

Open gem-wang opened this issue 4 years ago • 3 comments

Summary

Need an additional option "all" in the transaction list to be able to select all of them.

Description

A lot of times we want to add all transactions. In most cases, we have couple hundreds of transactions, it takes a long time to add them all and it is tedious if we want to do this for all of our SLO definitions. With "all" option, we can add all of them at once.

gem-wang avatar Aug 13 '20 20:08 gem-wang

makes sense - I think we can do that - it fits nicely with defining a standard SLO generically against entities in accounts. Will roll this together with that plan.

ricegi avatar Aug 21 '20 19:08 ricegi

@gem-wang @ricegi @andrewseling - I have a prototype of this working - basically instead of adding individual transactions to a query with separate where clauses, I just remove those filters all together with an "all" checkbox above the dropdown:

all

When checked, the dropdown is disabled and no filters are applied to the query. Here are examples for both availability (errors) and latency (calculated):

Errors: SELECT (1 - ((FILTER(count(*), WHERE ( duration > 3))) / (count(*)))) * 100 AS 'SLO' FROM Transaction WHERE appName = 'myApp' AND httpResponseCode IS NOT NULL SINCE 1602705085292 UNTIL 1602706885292

Latency: SELECT (1 - ((FILTER(count(*), WHERE (httpResponseCode LIKE '5%' OR httpResponseCode LIKE '400' OR httpResponseCode LIKE '403' OR httpResponseCode LIKE '404'))) / (count(*)))) * 100 AS 'SLO' FROM Transaction WHERE appName = 'myApp' AND httpResponseCode IS NOT NULL SINCE 1602705134713 UNTIL 1602706934713

Let me know if that satisfies this use case.

khpeet avatar Oct 14 '20 20:10 khpeet

can be closed. Added in https://github.com/newrelic/nr1-slo-r/pull/133

khpeet avatar Nov 20 '20 15:11 khpeet