How to Use the Summary Table

• To set up the summary table:

1. Select the filters that represent the columns you want to add to your summary table.

2. Drag that filters into the summary table.

   Response: Two drop-targets are displayed.
    

3. Drop the filters onto the leftmost drop-target, . This will show measures for all of the selected columns in the summary table.

4. Optionally, if you want separate statistics for different subsets of data, select the desired categorical column from the filters panel and drop it onto the categorization drop-target, . This 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 on 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 on 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 on a column header and select Move First or Move Last from the pop-up menu.

• To remove measures:

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

   Response: The measure is removed from the table.

• To add measures:

1. Right-click on 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 on 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. Click on the New Summary Table button on the toolbar, .

   Comment: You can also select Insert > New Visualization > Summary Table from the menu.

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

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

See also:

What is a Summary Table?

Summary Table Properties