How to Use the Summary Table

To set up the summary table:

1. In the Data in analysis flyout, drag one or more columns, which you want statistical measures for, to your summary table.

Response: Different drop-targets are displayed.

2. Drop them on to show statistical measures for these particular columns only, or drop them on to add them to the list of existing columns.

3. Optionally, if you want separate statistics for different subsets of data, select the desired categorical column from the flyout and drop it onto any of  the categorization drop-targets, (used to categorize by the selected column only) or (used to add this categorization to the existing ones). The column should not contain a large number of unique values, since it will be used to split the selected columns into categories.

   Comment: You can also use the Columns page of the Visualization Properties dialog to set up the summary table.

   Note: If a calculated column is added in Spotfire, it will automatically be included in the summary table.

To sort the summary table:

1. Click the header for the measure by which you wish to sort the summary table.

   Response: The columns are sorted in an ascending order by that measure.  If categorization is applied, the values for the different categories are sorted within each column.

   Comment: Click again to sort in a descending order, and click once more to return to the original sort order.

To change the order of the measures in the summary table:

1. Right-click a measure header and select Properties.

2. Select the Statistical measures page in the dialog.

3. Select the measure you wish to move and click Move Up or Move Down. Repeat for other measures until you obtain the desired order.

   Comment: You can also right-click a column header and select Move First or Move Last from the pop-up menu.

To remove measures:

1. Right-click a measure header and select Remove.

   Response: The measure is removed from the table.

To add measures:

1. Right-click the summary table and select Properties.

2. Select the Statistical measures page in the dialog.

3. Select the measures you want to insert from the Available measures list.

4. Click Add >.

   Response: The measure is inserted to the right of all previously added measures.

   Comment: Click a measure in the Selected measures list and then click Move Up or Move Down to change the order of the measures.

5. Click Close.

To change the measure column width:

1. Place the mouse pointer at the right edge of the measure header you want to resize. The cursor changes into a cross with arrows.

2. Adjust the width by holding down the mouse button and moving the mouse horizontally.

   Comment: You can also right-click on the desired header and select Column Width... from the pop-up menu, if you want to specify a column width in number of pixels.

To create a new summary table:

1. On the authoring bar, click    to open the Visualization types flyout.

2. Drag the Summary table visualization to the wanted position on the analysis page.

   Response: A first attempt to set up a suitable summary table is made.

3. Adjust the summary table to display the columns and measures of your choice.