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

Customer Dashboard: Comprehensive CMS Board

rfb
shared-dashboards

#1

This board was created to show the good and bad performing parts of a CMS, enabling three different filters that have been placed at the top: Device Type, Connection Type, and Browser.



If you’re interested in any of the Queries that were used to create one of the widgets, let me know and I’m glad to share.


#2

This is awesome @frankdornberger - Thanks for posting. I think adding some queries here would be a great help to anyone trying to replicate this dashboard.


#3

The top bar filters are done that way, removing “Unknown” devices and empty ConnectionTypes:

SELECT count(*) FROM PageView WHERE appName = 'MyApp' AND deviceType != 'Unknown' FACET deviceType

SELECT count(*) FROM PageView WHERE appName = 'MyApp' AND ConnectionType IS NOT NULL FACET ConnectionType

SELECT count(*) FROM PageView WHERE appName = 'MyApp' FACET userAgentName

These are the full width table widgets NRQLs:

SELECT count(*), percentile(duration, 50, 90, 95, 99) as 'page load duration' FROM PageView WHERE appName = 'MyApp' AND pageUrl LIKE '%domain.TLD%' FACET ConnectionType

SELECT count(*), percentile(pageRenderingDuration, 50, 90, 95, 99) as 'page render duration' FROM PageView WHERE appName = 'MyApp' AND pageUrl LIKE '%domain.TLD%' AND deviceType != 'Unknown'  FACET deviceType

The pageUrl filter is used to deal with a multi-brand CMS and visualise values for a given brand only.

The billboards are simple Queries with two thresholds to colour the number accordingly:

SELECT average(duration) FROM PageView WHERE appName = 'MyApp' and (pageUrl like '%domain.TLD/' or pageUrl like '%domain.TLD')

SELECT average(pageRenderingDuration) FROM PageView WHERE appName = 'MyApp' and (pageUrl like '%domain.TLD/' or pageUrl like '%domain.TLD')

SELECT average(domProcessingDuration) FROM PageView WHERE appName = 'MyApp' and (pageUrl like '%domain.TLD/' or pageUrl like '%domain.TLD')

SELECT average(backendDuration) FROM PageView WHERE appName = 'MyApp' and (pageUrl like '%domain.TLD/' or pageUrl like '%domain.TLD')

The three smaller table widgets are created with these queries:

SELECT count(*), average(duration) FROM PageView WHERE appName = 'MyApp' FACET userAgentName

SELECT count(*), average(duration) FROM PageView WHERE appName = 'MyApp' FACET userAgentOS

SELECT count(*), average(duration) FROM PageView WHERE appName = 'MyApp' AND deviceType != 'Unknown' FACET deviceType