Chart types

Chart builder supports a variety of visualizations to present your data in whatever format works best for your needs. A chart's refresh rate is calculated based on the query's timeframe.

Chart types for events

When you run a NRQL query in Insights or use basic or advanced (NRQL) mode to create a chart in New Relic One chart builder, the chart presents a selection of chart types appropriate for that query. Depending on the data specified in your query, some chart types may be grayed out and can't be chosen for a chart. A small table shows the availability status of a chart type for Insights and New Relic One.

Area chart
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

Area chart shows a time series for a single attribute.

crop-chart-area-nrql-2.png
The area chart type shows a time series for a single attribute.

To enable an area chart, add a facet from the dropdown.

You can add only one facet in basic mode.

If you're using advanced (NRQL) mode you can use facet to add up to five attributes, separated by commas, and also the TIMESERIES function.

Use Area chart when you want to View the measurement of a single attribute over a period of time that you specify.
Avoid Area chart when you want to View a chart that contains more than a single attribute. The line chart type is good option; you can view multiple attributes over a time range that you specify. The bar chart type gives you a comparison view between the attributes; it uses a total of each attribute for the time range you choose.
Attribute sheet
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

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

crop-insights-attribute-sheet-widget
The attribute sheet shows the single value from the query results.
Use attribute street when you want to View a list of attributes for a set of single-value attributes.
Avoid attribute street when you want to View data when you have used FACET function in your query. The table chart type is an option when your query uses FACET or you have multiple values for each attribute.
Bar chart
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

The bar chart chart type shows comparisons among the categories returned in the query results.

crop-chart-bar-nrql-2.png
The bar chart chart type compares a related set of values.>

To enable a bar chart, add a FACET clause to the query.

You can add only one facet in basic mode.

You can use FACET with up to 5 different attributes, separated by commas.

Use bar chart when you want to Create a chart that shows measurements for attributes visually; comparison of the length of bars are easily and quickly seen.
Avoid bar chart when you want to Include measurements over a period of time. The line chart type is good option for this visualization.
Billboard
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

The billboard chart type presents results as a single, highly-visible value. It's an option when your query returns a single number, such as from this query:

SELECT (uniqueCount(session) FROM PageView since 1 day ago

A billboard chart 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-chart-billboard-nrql-2.png
The billboard chart displays a single value in a large, easy to read font.

To enable the data for a billboard chart, search for a single value. You can view multiple values by adding a facet from the dropdown.

You can set Warning and Critical thresholds on billboards, which will highlight a chart in yellow or red. The threshold fields are on the right side of the chart 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.

Use billboard when you want to Monitor values, including thresholds for Critical and Warning states, in a large, easy-to-read font.
Avoid billboard chart type when You want to view data over a period of time. The line chart type is a better option for viewing data by time.

For more information, check out New Relic University's tutorial: Editing billboard and gauge charts on Insights dashboards. Or, go directly to the full online course: Dashboards and data apps.

Bullet Chart
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

Use the bullet chart type to represent progress to a target or goal, called the Limit. To use this chart type, run a query that returns a single number, such as:


SELECT (unique count(`session`)) FROM PageView SINCE 1 day ago 
crop-chart-bullet-nrql.png
The bullet chart displays a value compared against a limit.

Bullet 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 bullet will adjust accordingly.

bullet chart type will only be available for charts that present a single value. For instance, a query using COMPARE WITH will not list bullet as an option.

Use bullet when you want to View a chart uses a large, easy-to-read font that helps you view the comparison quickly.
Avoid bullet when you want to View data that has more than a single value. Bar and line chart types may be better choices in this instance.
Bullet is not supported in Insights; use the gauge chart type instead.
Event
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights
crop-insights-event-widget
The event chart type lists the data in a text format.
Use event when you want to Create a text file that contains the attribute name and its value. The file can be shared and the content easily embedded into a report or spreadsheet, for example.
Avoid event when you want to Present the data in a graphic, which can be helpful when monitoring the event on a dashboard. The billboard event is a good option for single-value data visualization.
Funnel
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

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)?”

temp-funnel-chart.png
Sample funnel chart for a shopping site

In this example, you want to determine that of all the visitors that viewed the landing page, how many of them:

  • Browsed the products.
  • Then added one or more products to a shopping cart.
  • And finally, purchased the item(s) in the shopping cart.

Unlike other queries, you must use a SELECT funnel statement in your query; the funnel chart type is not selectable from any other type of query.

Additionally, the funnel chart type is only available for queries with eight steps or fewer. A funnel query that includes more than eight steps will only return the results as JSON.

SELECT funnel(session,
    WHERE pageUrl like '%/index.html' AS 'Landing',
    WHERE pageUrl LIKE '%/browse/phones' AS 'Browse ',
    WHERE pageUrl LIKE '%/shoppingcart' AS 'Cart',
    WHERE pageUrl LIKE '%/checkout' AS 'Purchased')
    FROM PageView where appName = 'WebPortal' AND duration < 1
    SINCE 1 week ago
Use funnel when you want to You want to visually evaluate the paths that visitors take after they hit a page that you designate as a landing page.
Avoid funnel when you want to You only want counts for the attributes in the WHERE clause. You will not be able to choose funnel unless you use SELECT funnel in your query.
Gauge
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

Use the gauge chart type to represent progress to a target or goal, called the Limit. To use this chart type, run a query that returns a single number, such as

SELECT count(*) FROM PageView SINCE 1 hour ago.
Insights-widget-gauge.png
The gauge chart type displays a single value compared against a limit.

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 the limit value in blue, and the overage in purple.

Use gauge when you want to View a large and easy-to-read comparison a value compared against a limit that you set.
Avoid gauge when you want to Create a query that uses COMPARE WITH as gauge will not be listed as an option.
Gauge is not supported in New Relic One; use the bullet chart type instead.

For more information, check out New Relic University's tutorial: Editing billboard and gauge charts on Insights dashboards. Or, go directly to the full online course: Dashboards and data apps.

Heat map
[check icon] Basic mode [check icon] Advanced (NRQL) mode> [check icon] Insights

Heat map displays data in a tabular format using color gradations to show frequency in specific time buckets.

temp-heat-map-chart.png
The heat map is a faceted distribution of values where color density represents the values displayed.

To enable a heat map, use the Histogram() function with a numeric attribute and use FACET to add up to five attributes, separated by commas.

See Histograms: View data distribution for more detailed information about histogram-based charts.

Use heat map when you want to View tabular data for multiple attributes over a period of time, with gradated colors instead of numerals.
Avoid heat map when you want to View the exact data for multiple attributes over a period of time. A line or bar chart may be an option.
Histogram
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights
crop-insights-histogram-widget
A histogram charts frequency across a series of value ranges.

Use histograms to show the distribution of data across time buckets. See Histograms: View data distribution for more detailed information about histogram-based charts.

Use histogram when you want to Chart frequency of data over a series of values.
Avoid histogram when you want to View the same data as heat map or to view the data without the time buckets.
JSON
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

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

If you are using Insights, copy the JSON using the Copy JSON button. If you are using New Relic One chart builder, use the Share menu to select Copy JSON.

The following is an example of a portion the JSON response from this query
SELECT (uniqueCount(`name`)) FROM Transaction 
   WHERE httpResponseCode = '200' 
   TIMESERIES 
   FACET `appName` 
   LIMIT 10 
   SINCE 24 hours ago
  	
{
  "metadata": {
    "contents": {
      "messages": [],
      "timeSeries": {
        "messages": [],
        "contents": [
          {
            "function": "uniquecount",
            "attribute": "name",
            "simple": true
          }
        ]
      },
      "bucketSizeMillis": 1800000
    },
    "eventTypes": [
      "Transaction"
    ],
    "eventType": "Transaction",
    "openEnded": true,
    "messages": [],
    "beginTimeMillis": 1556226069396,
    "endTimeMillis": 1556312469396,
    "beginTime": "2019-04-25T21:01:09Z",
    "endTime": "2019-04-26T21:01:09Z",
    "guid": "5238a2c6-328d-a5ff-9185-7f3f04c42d1e",
    "routerGuid": "1aea2ec5-0be8-3a60-7554-851e1b016eb0",
    "rawSince": "24 HOURS AGO",
    "rawUntil": "NOW",
    "rawCompareWith": "",
    "facet": "appName",
    "offset": 0,
    "limit": 10
  },
  "facets": [
    {
      "name": "RPM Combined Production",
      "beginTimeSeconds": 0,
      "endTimeSeconds": 0,
      "timeSeries": [
        {
          "results": [
            {
              "uniqueCount": 415
            }
          ],
          "beginTimeSeconds": 1556226069,
          "endTimeSeconds": 1556227869,
          "inspectedCount": 4589471
        },
        [
          {
            "uniqueCount": 1714
          }
        ],
        "beginTimeSeconds": 1556310669,
        "endTimeSeconds": 1556312469,
        "inspectedCount": 53341469
      }
    ],
    "total": {
      "results": [
        {
          "uniqueCount": 2651
        }
      ],
      "beginTimeSeconds": 0,
      "endTimeSeconds": 0,
      "inspectedCount": 5053841114
    }
  },
  "performanceStats": {
    "inspectedCount": 6088068932,
    "responseTime": 8077
  }
}

...
    
Line
[check icon] Basic mode [check icon] Advanced (NRQL) mode >[check icon] Insights

A line chart is useful for spotting trends over time.

crop-chart-line-basic.png
The line chart chart type plots a timeseries for an attribute.

When working in basic mode in New Relic One, select a single attribute you can plot over time.

When working with a NRQL query, either in Insights or advanced (NRQL) mode in New Relic One, SELECT one or more attributes you can plot over time and then use the TIMESERIES function.

Use line chart when you want to Create a chart that lets you easily view trends over a specified time frame.
Avoid line chart when you want to View your data using one or more attributes and see the values associated with each attribute. A bar or table chart is an option.
List
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

The list chart type 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 chart type shows the set of unique values for a given attribute.
Use list when you want to Create a list of the value associated with each attribute. This list can be shared and easily added to reports and spreadsheets, for example.
Avoid list when you want to When the data you want to view has multiple values for each attribute. The event chart type may be an option, especially for New Relic One users.
Pie chart
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

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 chart type, run a query that returns one value for each of a set of attributes.

crop-chart-pie-nrql-2.png
The pie chart chart type maps a set of values as a portion of a whole.

To enable pie chart, add a FACET from the dropdown.

You can add only one FACET in basic mode.

If you're using Insights or advanced (NRQL) mode you can use FACET to add up to 5 attributes, separated by commas, and also the TIMESERIES function.

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%.

Use pie chart when you want to Create a chart that that graphically presents a set of values as they relate to a whole. A pie chart is effective for displaying values for a time period, for example.
Avoid pie chart when you want to Present data that does not use values as they related to a whole, such as with line charts.
Table
[check icon] Basic mode [check icon] Advanced (NRQL) mode [check icon] Insights

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.

crop-chart-table-nrql.png
The table chart type, with its tabular format, works well for dashboards, as well sharing the data for use in reports, for example
Use table when you want to Create a text-compatible table consisting of your data. This table can be shared and used in reports or imported into spreadsheets, for example.
Avoid table when you want to View your data in a graphical format.

Chart types for metric data

Metric chart are unique from other event-based charts. You can view aggregated metric data reported to New Relic from your agent. To add and customize metric charts on your Insights dashboard, use the Metric Explorer.

The metric explorer is not yet supported in New Relic One. However, once you have added a metric chart to dashboard, you can the chart builder in advanced (NRQL) mode to edit the query.

Follow these steps to use the advanced (NRQL) mode in New Relic One:

  1. Enter one.newrelic.com in your browser's address bar.
  2. In the top right corner of the page, click Chart builder.
  3. If chart builder opens in basic mode, click Advanced (NRQL) in the top right corner of the basic mode container.
  4. Use the Show query history dropdown in advanced (NRQL) mode to select the query associated with the metric chart on the Insights dashboard.

When you open chart builder, you will see the last query mode you used, either basic mode or advanced (NRQL) mode.

The Show query history dropdown in advanced (NRQL) mode will display all of your New Relic queries, for both Insights and New Relic One, for both basic and advanced (NRQL) modes.

For more help

Recommendations for learning more: