Hey there my fellow Data Nerds!
As a consultant for all things in and around the New Relic ecosystem (and much more), I recommend the following solution for this use case that’s really easy to use.
Basically, you’re just trying to do a two-part filter. This is natively supported from within the NR1 dashboarding UI already. To do it, you just need to have two queries on the same dashboard that facet by types of data in the same NR data namespace.
Steps to solve:
- Create dashboard widget 1 with query:
FROM dataTable SELECT * FACET dataTypeA
- Create dashboard widget 2 with query:
FROM dataTable SELECT * FACET dataTypeB
- Set both widgets to filter the current dashboard
- Filter by a primary field in widget 1
- Filter by a secondary field in widget 2
In the above example, dataTypeB becomes the $variableA in the original ask:
select * from Table where someField = $variableA
Example data set:
Example with the filters on:
(note that the screenshot number values don’t relate bc I took the screenshots at different times.)
Going beyond that, you can (and should) add an additional dimension for the data which is: time. I typically default many of my queries to include the time clause of “SINCE this month” to understand the current month’s performance. You can add another tab in NR1 where all of the same widgets are included, but on a different timeline so for example “SINCE last month UNTIL this month”. Then using the same filters, you can toggle back in forth to get a more complete understanding of what’s actually going on. Additionally, the time interval can be changed between week/month/quarter/year for maximal data representation options.
For those with additional questions, please feel free to reach out to me directly for additional support. Always happy to help fellow NR enthusiasts and data nerds.
Principal Consultant, Digital Performance Management