Insights chart types

New Relic Insights supports a variety of visualizations to present your data in whatever format works best for your needs. Insights charts refresh rate is calculated based on the query's timeframe.

Event chart types

When you execute any NRQL event query, Insights presents a selection of widgets appropriate for that query. Whatever the query results, a valid NRQL query will always return results in JSON format, in addition to any presentation widgets that are available.

Area chart

An area chart is an option when a line chart is showing a time series for a single attribute. Use the FACET clause to create stacked area charts.

crop-insights-areachart-widget

The area chart widget shows a time series for a single attribute.

Attribute sheet

An attribute sheet is a list of values for a single set of selected attributes. It is similar to a table, but it is an option only when you are not using a FACET clause.

crop-insights-attribute-sheet-widget

The attribute sheet widget shows a single set of values for an attribute.

Bar chart

The bar chart widget is a graphic representation of a table. It appears as an option when the FACET clause is used. To use this widget, run a query that returns one value for each of a set of attributes: SELECT count(*) FROM MobileSession SINCE 1 hour ago FACET device.

Screenshot - Insights bar chart widget

The bar chart widget compares a related set of values.

Billboard

The billboard widget presents results as a single, highly-visible value. It's an option when your query returns a single number: SELECT count(*) FROM PageView since 1 hour ago.

It is useful for single-stat queries like the Apdex function. Use billboards to monitor values at a glance.

Billboards can also be used to compare a single value across states. For instance, use the COMPARE WITH clause to compare the same attribute across two different time frames.

crop-insights-billboard-widget

The billboard widget displays a single value in a large, easy to read font.

You can set Warning and Critical thresholds on billboards, which will highlight a widget in yellow or red. The threshold fields are on the right side of the widget edit pane, highlighted in yellow and red respectively.

Threshold fields will only be available for dashboards that present a single value. For instance, use of a COMPARE WITH clause will disable the threshold settings in the edit pane.

Event

The event widget reports all specified attributes for a single event. As a variant of the table widget, it's an option when the limit of the number of records returned is set to 1.

The simplest call for an event is SELECT * FROM PageView LIMIT 1. This will return information on the last event of the PageView type. To drill down to a specific event, or set of events, use a WHERE clause and time range delimiters.

crop-insights-event-widget

The event widget shows the attribute values for a single event.

Funnel

Use funnels to evaluate a series of related events that are the steps toward a specified goal. A funnel allows you to ask, “Of the people that did (A), how many also did (B), and of the people that did (A) and (B), how many also completed (C)?”. For details and examples, see funnels documentation.

Gauge

Use the gauge widget to represent progress to a target or goal, called the Limit. To use this widget, run a query that returns a single number, such as: SELECT count(*) FROM PageView SINCE 1 hour ago.

The gauge defaults to a limit that is 2x the resulting query value. To adjust the limit, select in the Limit field and enter another number. The gauge will adjust accordingly.

When the value returned by the query exceeds the limit value, the gauge shows limit value in blue, and the overage in purple.

Insights-widget-gauge.png

The gauge widget displays a single value compared against a limit.

The gauge widget will only be available for dashboards that present a single value. For instance, a query using COMPARE WITH will not list the gauge widget as an option.

Heat map

A heat map is a faceted distribution that uses color to show the frequency of the intersection of two attributes. For example, the chart below shows event frequency by user agent and front-end response time. The darker the color, the higher the value. It is generated when the histogram function is paired with the facet clause. The color density in the heat map follows a logarithmic scale.

Screenshot Insights heat map widget
The heat map is a faceted distribution of values where color density represents the values displayed.

For more information, check out the New Relic University tutorial Histogram and Heat Map Queries. Or, go directly to the full online course Advanced NRQL.

Histogram

A histogram is a graphical representation of the distribution of data. It takes a numeric value, the range to report on (zero to value), and the number of buckets to break the results into. It is generated when the histogram function is used in the select method.

crop-insights-histogram-widget

The histogram charts frequency across a series of value ranges.

For more information, check out the New Relic University tutorial Histogram and Heat Map Queries. Or, go directly to the full online course Advanced NRQL.

JSON

All successful queries return in JSON format, even if the data cannot be represented by any of the available widgets.

Use the returned JSON in the Insights interface to review the raw data returned and to help develop integrations with New Relic Insights. To implement integrations, use remote queries to return raw JSON from Insights as a service.

Quickly copy the JSON using the Copy JSON button.

Example: The following is an example of the JSON response from SELECT count(*) FROM PageView.

{
  "results": [
    {
      "count": 125866
    }
  ],
  "metadata": {
    "contents": [
      {
        "function": "count",
        "simple": true,
        "openEnded": false
      }
    ],
    "eventType": "PageView",
    "openEnded": true,
    "beginTime": "2014-02-04T21:10:11Z",
    "endTime": "2014-02-04T22:10:11Z",
    "beginTimeMillis": 1391548211230,
    "endTimeMillis": 1391551811230,
    "rawSince": "`last_hour`",
    "rawUntil": "`now`",
    "rawCompareWith": ""
  }
}
Line chart

A line chart plots the values of numeric attributes over time. It an option when the TIMESERIES clause is used. Use it to display multiple measures on a given attribute, such as percentiles.

Line charts are unavailable for the uniques aggregator function.

crop-insights-linechart-widget

The line chart widget plots a timeseries for a single attribute.

List

The list widget lists unique values for a given attribute. It is an option when the uniques( ) function is used in the select method.

crop-insights-list-widget

The list widget shows the set of unique values for a given attribute.

Pie chart

A pie chart is the graphic representation of the table. It appears as an option for some functions when the FACET clause is used. To use this widget, run a query that returns one value for each of a set of attributes: SELECT count(*) FROM MobileSession SINCE 1 hour ago FACET device.

Insights-NRQL-pie-chart.png

The pie chart widget maps a set of values as a portion of a whole.

Pie charts are unavailable for the following aggregator functions: average, apdex, min, max, percentage, and percentile. For uniqueCount, percentages may add up to more than 100%.

Table

A table is the standard view for a set of values related to a specific attribute (for example, the count of all page views by user agent name). By default, all tables are sortable by any one column.

If you are using the FACET clause, the results will normally be returned as a table.

You can use a table as a shortcut to other dashboards. If a table is faceted by attribute, selecting an entry will take you to an existing dashboard that is filtered by that attribute. If you have multiple dashboards filtered by that attribute, Insights selects the first one created.

Insights-NRQL-table.png
The table widget shows a set of values for an attribute, optionally sorted by any attribute column.

Metric chart types

Metric widgets are unique from other event-based NRQL widgets. They display the aggregated metric data reported to New Relic from your agent. To add and customize metric widgets on your Insights dashboard, use the Metric Explorer.

Dashboard notes

Add markdown notes to dashboards to record or share custom information about the dashboard. Notes use markdown syntax, so it is easy to add elements such as headings, images, links, etc. Notes are added onto the dashboard just like other charts.

To add a dashboard note, select Add Dashboard Note at the top of the dashboard.

Web application throughput chart

For more help

Recommendations for learning more: