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

Is it possible to update where attributed based on dashboard filter

nrql
insights

#1

Hi,

I have NRQL something like this.

SELECT average(duration) FROM SyntheticCheck WHERE monitorName=‘ABC’ FACET locationLabel since 1 day ago TIMESERIES

Now in my dashboard I have filter on monitor name so if I change monitor name in filter so it should update NRQL, can we do so with current functionality or any other option availble.

Thanks
Nikhil


#2

Hi, @Nikhil.Anand: Dashboard filters can add a WHERE clause to a NRQL query, but they cannot modify an existing WHERE clause. In order to allow filtering of your dashboard, you must omit a WHERE clause from your query:

SELECT average(duration) FROM SyntheticCheck 
FACET locationLabel SINCE 1 day ago TIMESERIES

Another option is to add a widget to the dashboard that facets by monitor name:

SELECT average(duration) FROM SyntheticCheck 
FACET monitorName SINCE 1 day ago

Then link the monitorName widget to your dashboard, so that selecting a monitor name filters the dashboard by that name:


Single parameter to control all graphs on dashboard
Feb. 10, 2017 Post of the Week—NRQL, Alerts, and Browser
#3

Thanks Phil , will try to tune my usecase based on Facets.