The recently announced Victory Charts Visualizations nerdpack has a new addition – a scatter plot –available for you to try immediately! This post will show you how to make the most of this unique chart that can accept both aggregate and non-aggregate data!
We are excited to share the scatter plot as it provides capabilities other visualizations in New Relic One have not yet offered.
How does it work?
The scatter plot summarizes up to four query attributes in one visualization.
- The x-axis and y-axis present the first two
- The bubble size presents the optional third
- And for aggregate queries, the color of each bubble presents the
FACETattribute on which the data is aggregated.
Why use scatter plots?
The scatter plot provides a quick digestible view into the results for non-aggregate or aggregate NRQL queries. Prior to the scatter plot, the only visualization for non-aggregate data in New Relic One was the table. A table presents all results to scroll and read through but does not make the data more visually digestible. The scatter plot, however, instantly highlights things like outliers, patterns, and correlations without requiring scrolling or reading values to compare.
Getting set up is simple. You can get to scatter plots in three quick steps:
- If not already done, add the “Victory Charts Visualizations” Nerdpack to your account(s).
- Go to the catalog entry for Victory Charts Visualizations, click on the “Artifacts” tab, and click the “Open visualization” button for the scatter plot.
- In the configuration sidebar, set the account ID and set the query using either a non-aggregate or aggregate query as described below.
You can also find a guide in the documentation tab of the Victory Charts pack in New Relic One.
FROM Transaction SELECT externalDuration, duration LIMIT 1000 SINCE 1 day ago
FROM Transaction SELECT databaseDuration, externalDuration, duration LIMIT 500 SINCE 1 day ago
(Note that the third selection, “duration” is represented by bubble size)
To see an aggregate scatter plot, wrap the
SELECT clause entries with aggregate functions and add a
FACET clause attribute.
FROM PageView SELECT percentage(count(*), WHERE firstPaint > 3) as 'Slow first paint', percentage(count(*), WHERE duration > 3) as 'Slow duration', count(*) FACET countryCode LIMIT 200
Like non-aggregate queries, the third
SELECT clause entry that provides the bubble size value is optional. When provided, the bubble size attribute is typically best set to an attribute/function that provides the significance or weight of a given aggregate grouping. With that,
count(*) is a likely candidate.
No data values filtered out: Entries with no data for the x, y or size values are not displayed in the scatter plot. In cases where the attributes in the query are not consistently reported by your instrumentation, you may need to add a
WHEREclause so that the data returned by the query is not full of entries that will get filtered out. For example:
WHERE attributeName IS NOT NULL
See more entries with
LIMITclause: you can increase the number of data points displayed by adding a
LIMITclause to the query.
Hope you enjoy this new chart!
If you have any questions about scatter charts or the Victory Charts Nerdpack, feel free to leave a comment. In the meantime, you can: