Boxplots

Pre-calculated boxplot

Chart setup to build a pre-calculated boxplot:

Configuration option

Configuration value

Axis

Drag the dimension to plot on the axis (e.g., Date: Year, Month).

Values parameter

Drag multiple measures to compare (e.g., Upper Quartile, Lower Quartile, Median, Whisker Max, Whisker Min).

Chart type

Select Boxplot from the Chart Type dropdown menu.

Boxplots are a standardized way of displaying the distribution of data based on a five-number summary: minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum. To render a boxplot, you need to add the lower quartile, median, and upper quartile measures.

When the inter-quartile ranges are pre-calculated, i.e., the 5-number summary is already calculated, you can directly pass the values to render the boxplot.

1. Pivot data settings for boxplots

1.1. Boxplot auto sorting

Analytics+ automatically detects and assigns the lower/upper quartiles and the median and whisker values when this toggle is enabled. You can also manually select and assign the values in the settings pane by disabling this option.

2. Customization & formatting under canvas settings

2.1. Lower Quartile/ Upper Quartile/ Median/ Whisker Min/ Whisker Max

These dropdowns are enabled only when the Boxplot auto-sorting toggle is turned off. You can select the quartile, median, and whisker values from the dropdown menus.

You can disable the Median and Whisker toggles if you do not need to plot them.

2.2. Box format

Set the color and style (Solid, Outlined, Hatched) of the box.

2.3. Whisker format

You can set the style, thickness, and color of the whiskers.

2.4. Median format

Set the style, thickness, and color of the median line.

2.5. Stem line format

Set the style, thickness, and color of the stem lines that connect the boxes to the whiskers.

3. Conditional formatting for boxplots

When you select the Charts option from the Impacts on dropdown, you will be able to highlight the boxes based on the quartiles/median/whisker values.

Overlapped boxplot

Chart setup to build an overlapped boxplot:

Configuration option

Configuration value

Axis

Drag the dimension to plot on the axis (e.g., Date: Month).

Values parameter

Drag multiple measures to compare (e.g., Upper Quartile, Upper Quartile PY, Lower Quartile, Lower Quartile PY, Median, Whisker Max, Whisker Min).

Chart type

Select Boxplot from the Chart Type dropdown menu.

Overlapped boxplots can be used to compare previous year quartile values against current values. The upper and lower quartiles for the previous year should be assigned to the Box (Overlapped) data well in the pivot data window.