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

Mobile Dashboard - Crashes, Analysis and Performance

mobile
shared-dashboards

#1

Dashboard of the Day - Mobile Crashes, Analysis and Performance

Motivation

How and where are my crashes happening? Are these crashes affecting all app versions? I wonder if these crashes are specific to a certain mobile Carrier… All of these questions and more can be answered in this dashboard!


Screenshot

NOTE: We blurred out some of the data because some information is private. However, you can still see how the dashboard would look and leverage the queries in your own environment. If you’d like to contribute a screenshot, but have concerns about exposing private data, we can work with you to blur out some of the private data. If you have questions, don’t hesitate to message us and we’ll do our best to help you participate.


Dashboard Details

Required Products: APM
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: appName, pageUrl

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.

Chart Title

Attribute Sheet

SELECT uniqueCount(uuid) from Mobile since 1 day ago

Displays the number of unique active users in the last day

Monthly Users

Gauge

SELECT uniqueCount(uuid) from Mobile since 1 month ago

Displays the number of active users in the last month

Crashes by App Version

Bar Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET appVersion

Totals the number of crashes faceted by appVersion

Mobile Crashes over a Week

Area Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago TIMESERIES AUTO

Displays the number of crashes over time

Crashes Based on Device

Bar Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET device

Displays the number of crashes faceted by device

Crashes by Country

Bar Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET countryCode

Displays the number of crashes faceted 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.

Crashes by Carrier

Bar Chart

nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET carrier

Totals the number of crashes faceted by mobile service provider

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.

Most Common Crashes

Bar Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET crashException

Displays the most common crashes faceted by crashException

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.

Crashes by Cities

Bar Chart

SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET city

Displays the number of crashes faceted by city

Crashes for the Day

Event Table

SELECT * from Mobile WHERE category ='Crash' SINCE 1 day ago

Displays all of the crashes and crash details for the past day

Top 50 Issues over the last week

Event Table

SELECT appName, appVersion, crashException, crashFingerprint, crashLocation, crashMessage,lastInteraction, device from Mobile WHERE category ='Crash' SINCE 1 week ago limit 50

Details the top 50 issues over the last week


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": "Mobile Crashes, Analysis and Performance",
    "description": null,
    "icon": "mobile",
    "visibility": "all",
    "editable": "editable_by_all",
    "metadata": {
      "version": 1
    },
    "widgets": [
      {
        "visualization": "markdown",
        "layout": {
          "width": 3,
          "height": 1,
          "row": 1,
          "column": 1
        },
        "data": [
          {
            "source": "# Motivation\n---\nHow and where are my crashes happening? Are these crashes affecting all app versions? I wonder if these crashes are specific to a certain mobile Carrier... All of these questions and more can be answered in this dashboard!\n\nhttps://discuss.newrelic.com/t/mobile-dashboard-crashes-analysis-and-performance/61714"
          }
        ],
        "presentation": {
          "title": "",
          "notes": null
        }
      },
      {
        "visualization": "attribute_sheet",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(uuid) from Mobile since 1 day ago"
          }
        ],
        "presentation": {
          "title": "Daily Users",
          "notes": "Displays the number of unique active users in the last day"
        }
      },
      {
        "visualization": "gauge",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT uniqueCount(uuid) from Mobile since 1 month ago"
          }
        ],
        "presentation": {
          "title": "Monthly Users",
          "notes": "Displays the number of active users in the last month",
          "threshold": {
            "red": 100
          }
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 2,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET appVersion"
          }
        ],
        "presentation": {
          "title": "Crashes by App Version",
          "notes": "Totals the number of crashes faceted by appVersion",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "line_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago TIMESERIES AUTO"
          }
        ],
        "presentation": {
          "title": "Mobile Crashed over a Week",
          "notes": "Displays the number of crashes over time"
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET device"
          }
        ],
        "presentation": {
          "title": "Crashes Based on Device",
          "notes": "Displays the number of crashes faceted by device",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 3,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET countryCode"
          }
        ],
        "presentation": {
          "title": "Crashes By Country",
          "notes": "Displays the number of crashes faceted by country",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET carrier"
          }
        ],
        "presentation": {
          "title": "Crashes by Carrier",
          "notes": "Totals the number of crashes faceted by mobile service provider",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 2
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET crashException"
          }
        ],
        "presentation": {
          "title": "Most Common Crashes",
          "notes": "Displays the most common crashes faceted by crashException",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "facet_bar_chart",
        "layout": {
          "width": 1,
          "height": 1,
          "row": 4,
          "column": 3
        },
        "data": [
          {
            "nrql": "SELECT count(*) from Mobile WHERE category ='Crash' SINCE 1 week ago FACET city"
          }
        ],
        "presentation": {
          "title": "Crashes By Cities",
          "notes": "Displays the number of crashes faceted by city",
          "drilldown_dashboard_id": null
        }
      },
      {
        "visualization": "event_table",
        "layout": {
          "width": 3,
          "height": 1,
          "row": 5,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT * from Mobile WHERE category ='Crash' SINCE 1 day ago"
          }
        ],
        "presentation": {
          "title": "Crashes for the Day",
          "notes": "Displays all of the crashes and crash details for the past day"
        }
      },
      {
        "visualization": "event_table",
        "layout": {
          "width": 3,
          "height": 1,
          "row": 6,
          "column": 1
        },
        "data": [
          {
            "nrql": "SELECT appName, appVersion, crashException, crashFingerprint, crashLocation, crashMessage,lastInteraction, device from Mobile WHERE category ='Crash' SINCE 1 week ago limit 50"
          }
        ],
        "presentation": {
          "title": "Top 50 issues over the last week",
          "notes": "Details the top 50 issues over the last week"
        }
      }
    ],
    "filter": {
      "event_types": [
        "Mobile"
      ],
      "attributes": []
    }
  }
}