- There are many ways to achieve a goal in Insights, tell us a bit about your end goal. What insights are you hoping to gain?
In addition to specific facets/groups, I’d like summary data to be displayed in-line. For instance:
Region | State | Sales
Midwest | All | $1M
Midwest | Illinois | $250K
Midwest | Ohio | $200K
Midwest | Indiana | $550K
Southeast | All | $2.3 M
In this example, I can get the state-level sales, but not the summary for the full midwest. Every variant I show (for instance using manually-added “FACET CASE” statements) deducts from the region and doesn’t display at a summary level.
I’ve also tried a multi-level FACET or FACET CASES statement and it still doesn’t provide a summary row.
My goal is a tabular export of apdex and other performance data, with a summary row for all data and specific (or all) facets below.
- Let us know which NRQL queries you have tried so far:
I’d imagine this is similar in concept to to the MrBigShot Apdex here: https://docs.newrelic.com/docs/insights/nrql-new-relic-query-language/nrql-query-examples/app-data-query-examples-using-nrql#key-acct-apdex, but I’d like a single tabular export that already calcs the summary rows for all included transactions.