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

Intro Dashboard - All Widget Chart Types

browser
apm
infrastructure
shared-dashboards

#1

Dashboard of the Day - All Widget Types!

Motivation

To kick off our Dashboard of the Day campaign, we wanted to start with the basics: chart types! This dashboard contains every chart type currently available for event data in Insights.


Screenshot



Dashboard Details

Required Products: APM, Browser, Infrastructure
Level of Effort: Low
This dashboard will work on the standard New Relic data models and does not require any custom attributes or events.

Settings
Use the gear button to edit your dashboard and configure the following settings:

  • Dashboard Filter: Enabled
  • Enabled Event Types: PageView
  • Enabled Attributes: countryCode

Chart Details

In this section, we’ll go into the details on the purpose of each of the charts. We’ll also show you the query (NRQL) that you can cut/paste into your Insights query bar.

Billboard Comparison

SELECT count(*) FROM PageView SINCE 1 hour ago COMPARE WITH 1 week ago

Compares this week’s number of Page Views with last week

Attribute Sheet

SELECT count(*), uniqueCount(session), max(duration) FROM PageView since 1 hour ago

A total of Page Views, unique sessions, and the max page load duration from the past hour

Billboard

SELECT count(*) FROM PageView SINCE 1 hour ago

Total Page Views in the last hour

Histogram

SELECT histogram(duration) FROM PageView where countryCode IN ('CA', 'US') since YESTERDAY

Histogram of the page load duration in California

Facet Pie Chart (linked)

SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode LIMIT 10 SINCE YESTERDAY

Facetable pie chart displaying the number of unique sessions per Country

Add a Chart Facet for extra functionality!

Chart Facets expands the ability to quickly scope down into data by being able to click on an attribute and have the entire dashboard facet by that data point. Add this to the chart by doing the following:

  1. Run the NRQL query and save the chart to your dashboard.
  2. Open the menu in the newly created chart by clicking the ellipses in the top right corner and select “Edit Chart”.
  3. Click the blue button labeled “Link facets to a dashboard”, select the “current dashboard” option, and click Save.

Linked Bar Chart

SELECT count(*) from PageView facet countryCode

Facetable bar chart displays total number of Page Views per country

Add a Chart Facet for extra functionality!

Chart Facets expands the ability to quickly scope down into data by being able to click on an attribute and have the entire dashboard facet by that data point. Add this to the chart by doing the following:

  1. Run the NRQL query and save the chart to your dashboard.
  2. Open the menu in the newly created chart by clicking the ellipses in the top right corner and select “Edit Chart”.
  3. Click the blue button labeled “Link facets to a dashboard”, select the “current dashboard” option, and click Save.

Heatmap

SELECT histogram(duration) from PageView facet pageUrl

Heatmap of the page load durations faceted by Page URL

Gauge

SELECT count(*) from PageView

Total number of Page Views

Funnel

SELECT funnel(user, where name = 'Controller/applications/index' as 'App Index', where name = 'Controller/applications/show' as 'App Detail', where name = 'Controller/traced_errors/index' as 'Errors') from PageView

Evaluates series of related events that are the steps toward a specified goal - More info here

Line Chart Comparison

SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto COMPARE WITH 1 day ago

Compares yesterday’s duration times with today

Area Chart

SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto

A timeseries view of today’s average page load durations

Line Chart

SELECT average(duration), percentile(duration, 50, 90) FROM PageView SINCE yesterday TIMESERIES auto

Average duration and percentiles from today’s page loads

Uniques List

SELECT uniques(pageUrl) FROM PageView

Lists the unique page Urls that were viewed

Stacked Chart

SELECT count(*) FROM PageView FACET countryCode TIMESERIES auto since yesterday

Stacks the total number of Page Views faceted by country

Single Chart

SELECT * FROM PageView limit 1

Displays the available attributes for a single Page View Event

Facet Table (Linked)

SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode LIMIT 10 SINCE YESTERDAY

Facetable table displaying unique number of sessions and average duration by Country

Add a Chart Facet for extra functionality!

Chart Facets expands the ability to quickly scope down into data by being able to click on an attribute and have the entire dashboard facet by that data point. Add this to the chart by doing the following:

  1. Run the NRQL query and save the chart to your dashboard.
  2. Open the menu in the newly created chart by clicking the ellipses in the top right corner and select “Edit Chart”.
  3. Click the blue button labeled “Link facets to a dashboard”, select the “current dashboard” option, and click Save.

Multi Facet Table

SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode, city LIMIT 10 SINCE YESTERDAY

Same as above with an extra facet option - Country and City

Event Table

SELECT * FROM PageView limit 10

Displays the most recent events captured by PageView

Max of a date

SELECT max(duration) from PageView

Displays the max page load duration captured for the default time period

Event Feed

SELECT * FROM InfrastructureEvent

Displays the events in a feed

Raw JSON

SELECT * FROM PageAction

Displays the event in it’s raw JSON format


Extra Credit - Share your dashboard with the community!

Want to be a super “NeRD” (New Relic Developer)?
Use the API Explorer (or our Postman collection) to load the dashboard definition below into Insights or share the definition of your dashboard and increase your international NeRD cred! (And you’ll earn a cool badge for your community profile!)
Here’s some quick tips on how to do this.

Dashboard Definition

{
  "dashboard": {
    "title": "All widget types!!",
    "description": null,
    "icon": "dashboard",
    "visibility": "all",
    "editable": "editable_by_all",
    "metadata": {
      "version": 1
    },
    "widgets": [
      {
        "visualization": "markdown",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 1
        },
        "data": [
          {
            "source": "# Motivation\n---\n\nThis dashboard houses one of each widget type, including this \"Dashboard Note\" type and metric charts.\n\nhttps://discuss.newrelic.com/t/intro-dashboard-all-widget-chart-types/60663"
          }
        ],
        "presentation": {
          "title": "",
          "notes": null
        }
      },
      {
        "visualization": "billboard_comparison",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT count(*) FROM PageView SINCE 1 hour ago COMPARE WITH 1 week ago"
          }
        ],
        "presentation": {
          "title": "Billboard Comparison",
          "notes": "Compares this week’s number of Page Views with last week"
        }
      },
      {
        "visualization": "attribute_sheet",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*), uniqueCount(session), max(duration) FROM PageView since 1 hour ago"
          }
        ],
        "presentation": {
          "title": "Attribute Sheet",
          "notes": "A total of Page Views, unique sessions, and the max page load duration from the past hour"
        }
      },
      {
        "visualization": "billboard",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) FROM PageView SINCE 1 hour ago"
          }
        ],
        "presentation": {
          "title": "Billboard",
          "notes": "Total Page Views in the last hour",
          "threshold": {
            "red": 20000,
            "yellow": 1000
          }
        }
      },
      {
        "visualization": "histogram",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration) FROM PageView where countryCode IN ('CA', 'US') since YESTERDAY"
          }
        ],
        "presentation": {
          "title": "Histogram",
          "notes": "Histogram of the page load duration in California"
        }
      },
      {
        "visualization": "facet_pie_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode LIMIT 10 SINCE YESTERDAY"
          }
        ],
        "presentation": {
          "title": "Facet Pie Chart (linked)",
          "notes": "Facetable pie chart displaying the number of unique sessions per Country",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) from PageView facet countryCode"
          }
        ],
        "presentation": {
          "title": "Linked bar chart",
          "notes": "Facetable bar chart displays total number of Page Views per country",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration) from PageView facet account"
          }
        ],
        "presentation": {
          "title": "Heatmap",
          "notes": "Heatmap of the page load durations faceted by Page URL",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) from PageView"
          }
        ],
        "presentation": {
          "title": "A Gauge",
          "notes": "Total number of Page Views",
          "threshold": {
            "red": 10000
          }
        }
      },
      {
        "visualization": "funnel",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT funnel(user, where name = 'Controller/applications/index' as 'App Index', where name = 'Controller/applications/show' as 'App Detail', where name = 'Controller/traced_errors/index' as 'Errors') from PageView"
          }
        ],
        "presentation": {
          "title": "Funnel",
          "notes": "Evaluates series of related events that are the steps toward a specified goal"
        }
      },
      {
        "visualization": "comparison_line_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto COMPARE WITH 1 day ago"
          }
        ],
        "presentation": {
          "title": "Line Chart Comparison",
          "notes": "Compares yesterday’s duration times with today"
        }
      },
      {
        "visualization": "line_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto"
          }
        ],
        "presentation": {
          "title": "Area chart",
          "notes": "A timeseries view of today’s average page load durations"
        }
      },
      {
        "visualization": "line_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 5,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT average(duration), percentile(duration, 50, 90) FROM PageView SINCE yesterday TIMESERIES auto"
          }
        ],
        "presentation": {
          "title": "Line chart",
          "notes": "Average duration and percentiles from today’s page loads"
        }
      },
      {
        "visualization": "uniques_list",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 5,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT uniques(appName) FROM PageView"
          }
        ],
        "presentation": {
          "title": "Uniques List",
          "notes": "Lists the unique page Urls that were viewed"
        }
      },
      {
        "visualization": "faceted_area_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 5,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) FROM PageView FACET countryCode TIMESERIES auto since yesterday"
          }
        ],
        "presentation": {
          "title": "Stacked Area",
          "notes": "Stacks the total number of Page Views faceted by country"
        }
      },
      {
        "visualization": "raw_json",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 6,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT * FROM PageView limit 1"
          }
        ],
        "presentation": {
          "title": "Single Event",
          "notes": "Displays the available attributes for a single Page View Event"
        }
      },
      {
        "visualization": "facet_table",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 6,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode   LIMIT 10 SINCE YESTERDAY"
          }
        ],
        "presentation": {
          "title": "Facet Table (linked)",
          "notes": "Facetable table displaying unique number of sessions and average duration by Country",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_table",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 6,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode, city   LIMIT 10 SINCE YESTERDAY"
          }
        ],
        "presentation": {
          "title": "Multi facet Table",
          "notes": "Same as above with an extra facet option - Country and City",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "event_table",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 7,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT * FROM PageView limit 10"
          }
        ],
        "presentation": {
          "title": "Event Table",
          "notes": "Displays the most recent events captured by PageView"
        }
      },
      {
        "visualization": "billboard",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 7,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT max(account_created) from PageView"
          }
        ],
        "presentation": {
          "title": "Max of a date",
          "notes": "Displays the max page load duration captured for the default time period",
          "threshold": {
            "red": null,
            "yellow": null
          }
        }
      },
      {
        "visualization": "event_feed",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 7,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT * FROM InfrastructureEvent"
          }
        ],
        "presentation": {
          "title": "Event Feed",
          "notes": "Displays the events in a feed"
        }
      },
      {
        "visualization": "raw_json",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 8,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT * FROM PageAction"
          }
        ],
        "presentation": {
          "title": "Raw JSON",
          "notes": "Displays the event in it’s raw JSON format"
        }
      }
    ],
    "filter": {
      "event_types": [
        "PageView"
      ],
      "attributes": []
    }
  }
}