Skip to main content

Varicent ELT Help Center

Boxplot

Use the Boxplot chart to show the frequency of events within a group. A Boxplot is a distribution chart that represents groups of data by using quartiles.

Boxplot.svg

Each box shows the middle quartiles of the data set. The "whiskers" show the remaining quartiles of the data set. Outliers (if you choose to include them) appear as points outside of the box and whisker plot.

Input

The Boxplot chart can use both text and numeric columns.

Configuration

Use the following configuration options to configure the Boxplot chart.

Note

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

Configuring the Boxplot 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 Input tool.Data Input

  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. From the configuration pane, go to the Setup tab, and select the tool that you want to create a chart for.

    Note

    Whatever tool you select in your pipe when you add the chart is selected by default.

  8. Under Chart type, start typing Box plot to filter the list, then click the Box plot graphic to select it.

  9. Under Y axis, select the text or numeric column. The Y axis populates the data along the chart's vertical axis.

  10. Under Partition by, select the numeric column to use to partition.

  11. Under Min, select the numeric column to use for the minimum quartile.

  12. Under Lower, select the numeric column to use for the lower quartile.

  13. Under Median, select the numeric column to use for the median quartile.

  14. Under Upper, select the numeric column to use for the upper quartile.

  15. Under Max, select the numeric column to use for the maximum quartile.

  16. Under Series, select the numeric column to use for the chart.

  17. Expand the Advanced field, click Show to 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.

  18. Under Sort, select to sort your chart data by None, Ascending or Descending.

  19. Click the Customize tab to add custom styling to your chart.

    Table 115. Customize tab configurations

    Field

    Description

    Chart and axis titles

    Select the following to add titles to your charts. To update the title from "Untitled" to something meaningful, click on the title to edit.

    • 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. This option is useful if you have longer labels, as angling the text can free up more space in your chart.

    Include vertical axis title checkbox

    Select to add the vertical axis title.

    Vertical axis label angle

    Select the degree from the drop-down list of the angle for the vertical 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 arrows to increase or decrease the number.

    Colour

    Expand the Colour field, click on the column colour, and select a new colour.

    Legend

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



  20. Click Return to pipe to go back to your pipe. To view your chart or create a dashboard for your charts, read the Dashboards documentation.