How to use the new scatter plot visualization

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!

Introducing Scatter Plots

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 SELECT clause entries.
  • The bubble size presents the optional third SELECT clause entry.
  • And for aggregate queries, the color of each bubble presents the FACET attribute 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.

Guide to using scatter plots in New Relic One

Getting set up is simple. You can get to scatter plots in three quick steps:

  1. If not already done, add the “Victory Charts Visualizations” Nerdpack to your account(s).
  2. Go to the catalog entry for Victory Charts Visualizations, click on the “Artifacts” tab, and click the “Open visualization” button for the scatter plot.
  3. 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.

Scatter Plots for Non-aggregate queries

With two select clause entries (2 variables)

Example query:

FROM Transaction SELECT externalDuration, duration LIMIT 1000 SINCE 1 day ago

With three select clause entries (3 variables)

Example query:

FROM Transaction SELECT databaseDuration, externalDuration, duration LIMIT 500 SINCE 1 day ago

(Note that the third selection, “duration” is represented by bubble size)

Scatter Plots for Aggregate queries

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.

Additional Tips

  • 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 WHERE clause 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 LIMIT clause: you can increase the number of data points displayed by adding a LIMIT clause to the query.

Hope you enjoy this new chart!

Want to learn more?

If you have any questions about scatter charts or the Victory Charts Nerdpack, feel free to leave a comment. In the meantime, you can:

1 Like