Skip to main content

Varicent ELT Help Center

Bubble Single-Axis

Abstract

Use the Bubble Single-Axis chart to show data in a linear form.

Use the Bubble Single-Axis chart to show data in a linear form.

Bubble single-axis chart

Use a categorical variable for the Y-axis, such as day of the week. The X-axis can be any type of ordinal variable. Choose a numeric variable for setting the size of the bubbles that appear in the chart.

You can sort this chart by the X-axis values in either ascending or descending order.

Input

The Bubble Single-Axis chart uses both text and numeric columns.

Configuration

Use the following configuration options to configure the Bubble Single-Axis chart.

Note

The Configuring the Bubble Single-Axis chart gives configuration options through the Pipe module. If you have already created charts, you can access them through your Dashboards.

Configuring the Bubble Single-Axis chart

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Add tools to build out your pipe. For more information about adding tools to your pipe, see the Using the Pipe builder canvas documentation.

  5. Create a chart from your pipe by clicking Charts on the canvas toolbar.

  6. Click Create Chart.

    The chart page opens.

  7. In the configuration pane, enter the following information:

    Table 118. Bubble Single-Axis chart configuration

    Field

    Description

    Setup tab

    The Setup tab allows you to define the tool, chart type and other settings.

    Tool

    Select the tool in your pipe that you want to create a chart for.

    Chart type

    Type Bubble Single-Axis and click on the Bubble Single-Axis graphic to select it.

    X axis

    Select the column to use as the X axis.

    Y axis

    Select the numeric column to use as the Y axis.

    Size

    Select the numeric column to use as the size.

    Advanced section

    The Advanced section allows you to configure output settings to ensure accurate and efficient data processing and visualization.

    Show

    Select either Preview or Last built

    • Preview displays the first 100 rows of your data from your last build.

    • Last build displays the first 1000 rows of your entire dataset from your last build.

    Additional data for tooltip

    Choose additional values to display when hovering over data points in your chart.

    Sort

    Select to sort your chart data by None, Ascending or Descending.

    Customize tab

    The Customize tab allows you to configure the output settings to ensure compelling visualizations.

    Chart and axis titles

    Select the following to add titles to your charts:

    • Include chart title

    • Include chart subtitle

    • Include horizontal axis title

    Horizontal axis label angle

    Select the degree from the drop-down list of the angle for the horizontal axis label.

    Left margin

    Enter the padding for the left margin or click the arrows to increase or decrease the number.

    Right margin

    Enter the padding for the right margin or click the arrows to increase or decrease the number.

    Top margin

    Enter the padding for the top margin or click the arrows to increase or decrease the number.

    Bottom margin

    Enter the padding for the bottom margin or click the arrow to increase or decrease the number.

    Bottom margin for each axis

    Enter the padding for the bottom margin for each axis or click the arrow to increase or decrease the number.

    Colour

    Click on the column colour to change it.

    Legend

    Select the Include legend checkbox to add a legend to your chart.