You can split your data into buckets that cover certain ranges using the
buckets function .
Create bucketed NRQL query
To return bucketed results, use the
FACET buckets() clause in a NRQL query.
SELECT function(attribute) FROM source FACET buckets(attribute, ceiling, number of buckets)
Bucketing can be used with any attribute that is stored as a numerical value in the New Relic Insights event database.
To create a chart that shows the average duration of ranges of database calls:
- Create a NRQL statement with a
SELECTstatement for an attribute; for example,
- Add a
FACETclause that facets on buckets for another attribute; for example,
This query computes the average duration for each of the 10 buckets, with an upper limit of 400. All values above our upper limit of 400 are grouped in the last bucket, “>=360.0”.
SELECT average(duration) FROM Transaction SINCE 12 hours ago FACET buckets(databaseCallCount, 400, 10)
This query returns the following results in Insights: