You can filter your New Relic One dashboards by faceted attributes, making your dashboards more interactive and easy to use.
In New Relic One dashboards, for NRQL queries containing a
FACET clause and meeting other chart-type requirements, you can set up the faceted attributes to filter the current dashboard or a related, linked dashboard. By letting you quickly filter your dashboards, and link to pre-filtered dashboards, your dashboards are more interactive and easy to use.
This feature is available when adding a new chart to a dashboard or when editing a chart on an existing dashboard.
To see this feature in action, see the example use case.
Requirements to use this feature:
- Must be in New Relic One dashboards. Will not work on a standalone chart in the query builder.
- NRQL query must contain a
- Available only for bar charts, heat maps, pie charts, and tables.
Let's say you create the following facet-containing NRQL query for an existing dashboard in New Relic One:
one.newrelic.com > Dashboards: For queries containing a
FACET clause and meeting chart-type requirements, you can set those attributes to be used as an easy dashboard filter. You can set the attribute to filter the current dashboard you're on, or filter a related dashboard that you select.
If you select Filter the current dashboard, that chart will be used to filter the current dashboard by the available
userAgentName attributes. Here's a view of selecting one of those attributes to filter that dashboard. Notice that the chosen attribute appears as a filter in the search bar at the top.
one.newrelic.com > Dashboards: When you select an attribute you've set up for facet filtering, it filters the current dashboard.
For more about this feature, see the Explorers Hub post on facet filtering.
FACET CASES is a NRQL function that allows to group facets based on conditions. We support multiple cases in the same facet.
For example, let's say you query your applications, but you don't know which have been migrated to cloud and which haven't.
SELECT filter(count(*), WHERE duration > 1) as 'On-premises', filter(count(*),WHERE duration < .06) as 'AWS'FROM Transaction WHERE appName NOT LIKE '%Tower%' FACET appName LIMIT 5 since 5 minutes ago
By using FACET cases, you can add the condition and obtain the status of the migration:
SELECT count(*) FROM Transaction WHERE appName NOT LIKE '%Tower%'facet cases(WHERE appName = 'WebPortal' OR appName = 'Plan Service' as '% of Hosts On-Prem',WHERE appName != 'WebPortal'AND appName != 'Plan Service' as '% of Hosts in Cloud')since 10 minutes ago limit 100
Then, using facet linking, you can filter your dashboards by those facets.
If you need more help, check out these support and learning resources:
- Browse the Explorers Hub to get help from the community and join in discussions.
- Find answers on our sites and learn how to use our support portal.
- Run New Relic Diagnostics, our troubleshooting tool for Linux, Windows, and macOS.
- Review New Relic's data security and licenses documentation.