Adding measures to the statistics table

You can specify which statistical measures to show in a box plot. It is also possible to add predefined measures, write your own expressions, and specify formatting settings.

Procedure

In the visualization properties panel for your box plot, locate the Statistics table card.
Click Add measure to open a drop-down list. You can either select a predefined measure or click Add custom expression to write your own expression. See Statistical functions for more help on how to write statistical measures as expressions.
Optionally, expand an existing statistical measure and click to edit it using the expression editor. You can also select the preferred formatting type from the Format as drop-down list. See Formatting details to learn more about the formatting options.
The order of the measures in the card determines the order of the measures in the statistics table, and you can move measures as desired using drag-and-drop.
See Aggregations and statistical measures for details about the different measures.

Results

The visualization is updated with the selected statistical measures.

You can select which measure to sort the table by and whether to sort ascending or descending by either clicking directly on the measure in the visualization or under Sort by in the Category axis card.

Converting measures from earlier versions

About this task

You will see statistical measures in the Statistical measures (legacy version) card if you have configured a box plot using an earlier version of the settings:

In the Statistics Table page of the visualization properties dialog.
In the Statistical measures card of Spotfire versions older than 14.6.0.

The legacy card does not have any configuration options, but still provides measures to the box plot. If you need to modify the measures, you must convert them to use them in the new card.

Procedure

In the visualization properties for your box plot, locate the Statistical measures (legacy version) card.
Hover over the Information icon in the upper part of the card.
Click Convert measures to expressions in the tooltip.

A new Statistics table card containing the converted measures is shown in the visualization properties panel. The Statistical measures (legacy version) card is removed.

Note: Once you have converted the measures to expressions and saved the analysis, it might not work as expected if you open the analysis again in a Spotfire version older than 14.6.0.

Configuring default measures

About this task

In the installed client, you can save your configuration of statistical measures as default and reuse it in new box plots. Default statistical measures can be set in the Statistics table card of the visualization properties panel. These default settings allow more customization than the defaults in Tools>Options, including custom expressions and formatting.

Procedure

Locate the Statistics table card when your measures are configured.
Open the menu in the upper part of the card.
Click Set the current measures configuration as default.

The configuration you have saved as default is used in all new box plots.

Note: If you specify the default in the card, the dialog in Options will be disabled. Click Reset default specified in the panel to revert the default to the one specified in the dialog. Note that all custom expressions and formatting settings will be removed, and predefined measures will be used.