We have all been there, spent a couple of hours working on a query to get a dashboard that your team/manager or product owner just has to have. How about some community spirit and helping our fellow Data Nerds to get a running start with some dashboards by posting some here?
Please ensure that you post a short description of the purpose of your query along with the NRQL.
This query will get the number of PageViews broken into Mobile, Desktop and Tablet:
SELECT percentage(count(*), WHERE deviceType = 'Mobile') AS 'Mobile', percentage(count(*), WHERE deviceType = 'Desktop') AS 'Desktop', percentage(count(*), WHERE deviceType = 'Tablet') AS 'Tablet' FROM PageView SINCE 1 week ago
This query will get the biggest resources used in the pages in your synthetic tests:
SELECT max(responseBodySize) FROM SyntheticRequest FACET URL