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

Advanced NRQL Queries in Insights

nrql

#1

In this post, you’ll find eight short (2-3 minute) video tutorials that cover a variety of advanced NRQL queries. You can use these queries in Insights to get more in-depth data and advanced chart types. Click on any of the titles in the list below to expand that tutorial.

Funnel Queries with NRQL

This tutorial covers how to write a funnel query in Insights using NRQL.
Funnel queries allow you to ask questions about the completion of steps in a process, or completion of a series of desired actions.

This query format particularly useful when trying to discover when people exit your site before making a purchase or conversion.

Filter Functions with NRQL

This tutorial covers how to write a filter query in Insights using NRQL.

Filtering is a useful query type when you have a large chunk of data and you want to narrow the scope by a single specific parameter. For example, you might have thousands of user zip codes but you only want to view users in a single zip code - filtering allows you to view only that specific zipcode you want to see.

http:////fast.wistia.net/embed/iframe/8k4xbxlfwj

Cohort Analysis Queries with NRQL

This tutorial covers how to write a cohort analysis query in Insights using NRQL.

Cohort analysis allows you to group query results based on different time-based criteria. These queries rely on FACETing - or ‘grouping’ results by something like the month accounts were created in, the date of last account access, or any other time-based criteria.

Advanced Segmentation with NRQL

This tutorial covers how to do advanced segmentation in Insights using NRQL.

Advanced segmentation gives you deeper analysis into your data by breaking is down by attributes and then grouping results using specified numerical values. This is especially helpful for getting information about things like ‘user engagement’.

For example, if you want to look at the number of users who looked at a page on your site, and then also want to see how long they actually spent looking at that page, you can write a query that displays the duration of a pageview and break out durations by specified amounts.

Histogram and Heat Map Queries

This tutorial covers how to generate a histogram or heat map chart in Insights using the NRQL histogram function.

A histogram chart is a graphical representation of the distribution of data - each bar represents a bucket or grouping of data for the value of that attribute and the height of the bar shows the frequency events occurred in that particular grouping.

The heat map adds to this using color to show the frequency of the intersection of two attributes.

Percentile Queries with NRQL

This tutorial covers how to generate a percentile chart in Insights using the NRQL percentile function.

Using the percentile function can help identify performance outliers, while also setting a standard of performance within your app.

Apdex Queries with NRQL

This tutorial covers how to generate a Apdex chart in Insights using the NRQL Apdex function.

The Apdex score is a ratio value of the number of satisfied and tolerating requests to the total requests made.
I can use the apdex function in NRQL to return an Apdex score for a single transaction or for all my transactions using any attribute whose value is based on response time, such as duration or backendDuration.

Using Math in NRQL Queries

This tutorial covers how to use math in any numerically based NRQL query in Insights.

You can apply addition, subtraction, multiplication, and division on both individual attributes as well as the results of aggregator functions.

If you have any feedback or questions about these videos please post them as a reply to this thread. Thanks for watching!

Looking for more educational videos? Here is the complete list!