Document toolboxDocument toolbox

Scatter plot

Overview

The scatter plot chart is often used to visualize the correlation between two variables as it depicts points in a two-axis diagram at the intersection of their values. This is very useful to spot trends easily and analyze matrix variables because you can see at a glance the overall distribution of the different data combinations.

What data do I need for this widget?

The option to create this chart will be disabled unless your query contains at least two columns with numeric values.

Creating a scatter plot

Working with scatter plots

Hover over a point on the chart to view a tooltip with the variables and their values.

You can use the following options to visualize different aspects of your scatter plot:

  • Click one of the partitioning variables in the chart legend at the bottom to filter the chart. They work as toggles you can use to show/hide the points on the chart associated with them.

  • Click and drag to delimit an area to zoom in on and the chart will show only those values included inside. Click the Reset zoom button that appears at the top right to go back to the original visualization.

  • If your data is updated in realtime, the realtime toggle will appear at the top left. Activate it to update the chart with the new incoming data or deactivate it to keep the latest available data up to that moment.

  • Click the by period toggle to show the results per period, showing the latest available period by default and being able to move through the different periods (see the table below to know how).

    • If your data is not grouped, you will see the results per distinct value, showing the latest available value by default and being able to move through them (see the table below to know how).

    • If your data is grouped but not using a temporal aspect, you will see no difference when activating this option.

You can hit the following keys to perform different visualization actions:

Shortcut keys

Description

Shortcut keys

Description

With the by period option activated:

  • If your data is grouped by period, displays the data from the previous period. For example, if your query groups data every 30 seconds press the left arrow to see the data bubble for the previous 30-second period.

  • If your data is not grouped, displays the data from the previous distinct value available.

With the by period option activated:

  • If your data is grouped by period, displays the data from the previous period. For example, if your query groups data every 30 seconds press the left arrow to see the data bubble for the previous 30-second period.

  • If your data is not grouped, displays the data from the next distinct value available.

?

Shows/hides the list of shortcut keys.

Query example

You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:

from demo.ecommerce.data

Required field

Column added

Required field

Column added

X-Axis

timeTaken

Y-Axis

bytesTransferred

Partitioning

method

In case you want another example with the data grouped, here is another query to create it:

from demo.ecommerce.data group every 5m by method, timeTaken, bytesTransferred every 5m

Required field

Column added

Required field

Column added

X-Axis

timeTaken

Y-Axis

bytesTransferred

Partitioning

method

Realtime → deactivated

By period → activated