Filtering graphs by transaction type

Support: Alerts/Applied Intelligence (AI) Alerts
#1

A feature which I find quite useful for basically all reports and graphs in NR is the ability to filter out data by transaction type, ie. separate transactions between web / command-line / all.

If I recall correctly, a toggle allowing the user to do so in an easy way was present above most of the graphs displayed by the standard interface, but it seems to be now available only in the APM “Summary” page.
I find that toggle more useful than the other one, which is still be available in many places, allowing to filter the data by server instance (as our production web-farm instances are all set up the same way, unless major issues arise, they all exhibit a similar behaviour).

I tried to achieve the same filtering by creating my own graph using the NRQL, but I could not find how to add a WHERE condition which filters out the data by transaction type.
Is that possible? And, if so, where can I find the relevant documentation?

Thanks
Gaetano

#2

Can you share the query you have built thus far. I am able to filter Transactions based on type

SELECT * FROM Transaction WHERE transactionType = ‘Web’ AND transactionSubType = ‘Custom’

#3

This is the current query I have - it’s not necessarily showing the data I want, just something generated by the NR gui when browsing for specific data. What I’d like to see in this case is the nr. of calls made to an external webservice and/or the total time spent

SELECT count(newrelic.timeslice.value) AS External/analyticsreporting.googleapis.com/allFROM Metric WHERE metricTimesliceName = 'External/analyticsreporting.googleapis.com/all' ANDentity.guid = '...' TIMESERIES

#4

Hi @ggiunta1

Thanks for sharing, im not sure why this isnt showing the data that you desire. I have to loop in engineering to have a look at why.

Please note they will reach out soon via this post. If you have any updates or questions please let us know.

#5

Hi @ggiunta1 - It sounds like you are using the data explorer which has very limited filter functionality. I would recommend using the metric explorer to find a query that might work for you and tune it with additional NRQL query syntax to get the data you are looking for in query builder.