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

Front to Back in Real Time - APM and Browser Dashboard

browser
shared-dashboards

#1

Dashboard of the Day - Front to Back in Real Time: APM and Browser

Motivation

As we all know by now, dashboards play a crucial role in successfully monitoring your applications’ performance over time. What if, however, we want to see how customers are interacting with your application right now? How can we tell what browsers are being used to access your application right now? This dashboard is set to evaluate your data as it streams in to New Relic to provide near real time front and back end statistics.


Screenshot


Dashboard Details

Required Products: APM, Browser
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: Transaction
  • Enabled Attributes: all

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.

Peak Usage

Gauge Chart

SELECT uniqueCount(host) FROM Transaction since 1 day ago LIMIT 200

Displays the number of unique hosts active in the last day

Hosts

Gauge Chart

SELECT uniqueCount(host) FROM Transaction since 1 minute ago LIMIT 200

Displays the number of unique hosts active in the last minute

Transaction by Host

Bar Chart

SELECT count(*) FROM Transaction since 1 minute ago FACET host LIMIT 100

Displays the number of APM transactions in the last minute faceted by host

Page Views

Gauge Chart

SELECT count(*) FROM PageView SINCE 1 minute ago

Displays the number of Browser page views in the last minute

Sessions

Gauge Chart

SELECT uniqueCount(session) FROM PageView SINCE 1 minute ago

Displays the number of active Browser user sessions in the last minute

Average Page Load

Bar Chart

SELECT average(duration) FROM PageView SINCE 1 minute ago facet userAgentName limit 50

Displays your average page loads in the last minute faceted by the user’s browser

Pages

Bar Chart

SELECT count(*) from PageView SINCE 1 minute ago FACET pageUrl LIMIT 50

Displays the pages with the most page views in the last minute

Backend

Heat Map

SELECT histogram(databaseDuration) FROM Transaction FACET name SINCE 1 minute ago LIMIT 100

Maps out the average backend duration faceted by transaction name

Front End

Heat Map

SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET browserTransactionName LIMIT 10

Maps out the average front end duration faceted by browserTransactionName

Countries

Heat Mat

SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET countryCode Limit 50

Maps out the most active countries

Cities

Heat Map

SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET city Limit 50

Maps out the most active cities

Platforms

Heat Map

SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET userAgentOS Limit 50

Maps out the most active Operating Systems used to access your application


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": "Front and Back End Real Time Comparison",
    "description": null,
    "icon": "bar-chart",
    "visibility": "all",
    "editable": "editable_by_all",
    "metadata": {
      "version": 1
    },
    "widgets": [
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(host) FROM Transaction since 1 day ago LIMIT 200"
          }
        ],
        "presentation": {
          "title": "Peak usage",
          "notes": "Displays the number of unique hosts active in the last day",
          "threshold": {
            "red": 458
          }
        }
      },
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(host) FROM Transaction since 1 minute ago LIMIT 200"
          }
        ],
        "presentation": {
          "title": "Hosts",
          "notes": "Displays the number of unique hosts active in the last minute",
          "threshold": {
            "red": 34
          }
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 1,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) FROM Transaction since 1 minute ago FACET host LIMIT 100"
          }
        ],
        "presentation": {
          "title": "Transactions by host",
          "notes": "Displays the number of APM transactions in the last minute faceted by host"
        }
      },
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) FROM PageView SINCE 1 minute ago"
          }
        ],
        "presentation": {
          "title": "Page Views",
          "notes": "Displays the number of Browser page views in the last minute",
          "threshold": {
            "red": 172834
          }
        }
      },
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(session) FROM PageView SINCE 1 minute ago"
          }
        ],
        "presentation": {
          "title": "Sessions",
          "notes": "Displays the number of active Browser user sessions in the last minute",
          "threshold": {
            "red": 28
          }
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT average(duration) FROM PageView SINCE 1 minute ago facet userAgentName limit 50"
          }
        ],
        "presentation": {
          "title": "Average page load",
          "notes": "Displays your average page loads in the last minute faceted by the user’s browser"
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) from PageView SINCE 1 minute ago FACET pageUrl LIMIT 50"
          }
        ],
        "presentation": {
          "title": "Pages",
          "notes": "Displays the pages with the most page views in the last minute"
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT histogram(databaseDuration) FROM Transaction FACET name SINCE 1 minute ago LIMIT 100"
          }
        ],
        "presentation": {
          "title": "Backend",
          "notes": "Maps out the average backend duration faceted by transaction name"
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET browserTransactionName LIMIT 10"
          }
        ],
        "presentation": {
          "title": "Frontend",
          "notes": "Maps out the average front end duration faceted by browserTransactionName"
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET countryCode Limit 50"
          }
        ],
        "presentation": {
          "title": "Countries",
          "notes": "Maps out the most active countries"
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET city Limit 50"
          }
        ],
        "presentation": {
          "title": "Cities",
          "notes": "Maps out the most active cities"
        }
      },
      {
        "visualization": "heatmap",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT histogram(duration, 10, 50) FROM PageView SINCE 1 minute ago FACET userAgentOS Limit 50"
          }
        ],
        "presentation": {
          "title": "Platforms",
          "notes": "Maps out the most active Operating Systems used to access your application"
        }
      }
    ],
    "filter": {
      "event_types": [
        "Transaction"
      ],
      "attributes": []
    }
  }
}