Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

How to write query to collect latest 5 web transactions duration per application


#1

I am trying to create a dashboard to display latest 5 web transactions for each application. What I find an average duration. Is there any way I can show each transaction.


#2

hey @hemant.goel

There’s currently no way to query that data for multiple apps in one widget

But - you can run a query like this:

FROM Transaction SELECT duration where transactionType = 'Web' AND appName = 'myAppName' limit 5

You’ll need to add a widget to your dashboard for each app though. That query will return the latest 5 transaction durations for the app you select for the appName attribute.