Steal this Dashboard! Every Insights Chart Type in One Dashboard



  • Your modern software team moves fast. To help keep up the momentum, you’re likely gathering all kinds of data about the performance of your team and its deliverables. One of the best ways to visualize that data is to use New Relic Insights dashboards.

    Dashboards tell visual stories about your team’s work. They offer an instant view into the health of your systems, and they help you identify areas that need attention before problems arise. You need to set these views to match your workflows, and that’s why we give you so many ways to visualize the data you capture in New Relic. From billboards to histograms to gauges—you choose the visualizations that best help your team to understand what’s really happening.

    To illustrate the capabilities of New Relic Insights dashboards, we’ve built one that includes every possible way to visualize your APM data and pageview data—what we call the All Chart Types dashboard. These visualizations, or charts, come in a variety of formats, or widgets, and they are built using New Relic Query Language (NRQL) queries.

    Re-create this dashboard in your own environment to learn how each widget works. It’s a simple process: We supply all the necessary queries, and you should have it up and running in minutes.

    Whether you’ve created dozens of dashboards or you’re just getting started, or even if you have never once looked at Insights, this is a dashboard you’re going to want to steal.

    Build the All Chart Types dashboard

    To reproduce the All Chart Types dashboard, you’ll need New Relic APM, New Relic Browser, and New Relic Infrastructure accounts. The dashboard works with the standard New Relic data models and does not require any custom attributes or events.

    The result will look something like the following screenshots:

     all chart types dashboard1all chart types dashboard2all chart types dashboard3

     

    To get started, you need to create a new dashboard in Insights:

    1. Navigate to newrelic.com, and select the green plus (+) icon next to All dashboards.
    2. Name your dashboard.
    3. On the dashboard, click Edit and then click the gear icon Filter enabled.
    4. Configure the following settings:
      • Select Enable filter
      • For Event types select PageView
      • For Attributes set countryCode
    5. To add a widget and chart to your dashboard, run a NRQL query to populate the relevant data you want to visualize. For our All Chart Types dashboard, we’ve provided the relevant queries and an explanation of what each one does. Cut and paste them into your Insights query bar.
    Chart TypeDefinitionNRQL query
    Comparison billboardCompare the number of pageviews this week with last week.SELECT count(*) FROM PageView SINCE 1 hour ago COMPARE WITH 1 week ago
    Attribute sheetDisplay the total number of pageviews, unique sessions, and the maximum page-load duration from the past hour.SELECT count(*), uniqueCount(session), max(duration) FROM PageView SINCE 1 hour ago
    Total page views billboardDisplay the total pageviews in the last hour.SELECT count(*) FROM PageView SINCE 1 hour ago
    Page load duration (per location) histogramDisplay a histogram of the page-load duration for a specific location (in this example, California).SELECT histogram(duration) FROM PageView where countryCode IN ('CA', 'US') SINCE YESTERDAY
    Unique sessions facet pie chartDisplay a pie chart, which can be faceted, showing the number of unique sessions per country.SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode LIMIT 10 SINCE YESTERDAY
    Total pageviews bar chartDisplay a bar chart, which can be faceted, showing the total number of pageviews per country.SELECT count(*) from PageView facet countryCode
    Pageload duration heatmapDisplay a heatmap of page-load durations, faceted by page URL.SELECT histogram(duration) from PageView facet pageUrl
    Pageview gaugeDisplay the total number of pageviews.SELECT count(*) from PageView
    Related-events funnelDisplay a funnel that evaluates a series of related events that are the steps toward a specified goal.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
    Duration line-chart comparisonCompare yesterday’s duration times with duration times from today.SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto COMPARE WITH 1 day ago
    Timeseries-view area chartShow a timeseries view of today’s average page-load durations.SELECT average(duration) FROM PageView SINCE yesterday TIMESERIES auto
    Page-load line chartDisplay average duration and percentiles from today’s page loads.SELECT average(duration), percentile(duration, 50, 90) FROM PageView SINCE yesterday TIMESERIES auto
    Uniques listDisplay a stacked chart of the total number of pageviews faceted by country.
    SELECT uniques(pageUrl) FROM PageView
    Pageviews stacked chartDisplay a stacked chart of the total number of pageviews faceted by country. SELECT count(*) FROM PageView FACET countryCode TIMESERIES auto since yesterday
    Single pageview attributes chartDisplay the available attributes for a single pageview event.SELECT * FROM PageView limit 1
    Number of sessions and average duration facetable table Display a facetable table showing the unique number of sessions and average duration per country.

    SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode LIMIT 10 SINCE YESTERDAY
    Number of sessions and average duration multi-facetable tableDisplay a facetable table showing the unique number of sessions and average duration per country and city.SELECT uniqueCount(session), average(duration) FROM PageView FACET countryCode, city LIMIT 10 SINCE YESTERDAY
    Pageview event tableDisplay a table of the most recent events captured by PageView.SELECT * FROM PageView limit 10
    Maximum page load for a specified time periodDisplay the maximum page-load duration captured for the default time period.SELECT max(duration) from PageView
    Event feedDisplay events in a feed.SELECT * FROM InfrastructureEvent
    Raw JSONDisplay an event in its raw JSON format.SELECT * FROM PageAction

    (Refer to the Insights chart types documentation for more about each chart type.)

    Share your dashboard with the community, and win!

    On November 26th, 2018, New Relic will kick off our Shared Dashboards contest. You’ll have two weeks to enter by sharing your most useful queries, Insights charts, and dashboards in the Explorers Hub.

    Something for everyone who shares

    There are two chances to win a New Relic branded Apple Watch, but everyone gets something for sharing:

    • One Apple Watch winner will be selected by you via a community vote.
    • A second Apple Watch winner will be selected by the New Relic team.
    • Everyone who shares a dashboard will earn a New Relic Developer Program t-shirt and a contest badge.

    To help get you started and provide more inspiration, our dashboard experts will be sharing a Dashboard of the Day, complete with the NRQL queries that you can use to create these same dashboards in your own environments.

    Get ready to tell your story and share your dashboards. You could win big!





© Lightnetics 2024