Knowledge Base

Modify the Layout of the Results Table

Aim

To make sure your results are grouped and displayed in the most useful way possible. This is particularly the case when exporting the results to another application.

Note: This applies to Trial Statistics and Group Statistics.

Prerequisites

• You have run analysis (Analysis > Results > Statistics and Charts > Calculate).

General Procedure

Click the Layout button on the toolbar, or choose Show/Hide > Layout.

By default, the results table shows the dependent variables and their statistics on the columns, and the trials on the rows.

Add a Header to the Table

Example: In the Trial Statistics page, add the independent variable Treatment, so that each row (trial) is labeled with the value of Treatment, either Compound or Vehicle.

1. Click the Layout button on the toolbar.
2. In the Available box, click the header you want to add.
3. Click the arrow button which points to the On Rows box.
4. Optionally, move the header up in the list to have trials separated based on the values of Treatment.

Notes:

• If you click the arrow button which points to On Columns, the variable is placed in columns.
• To add a new dependent variable, do this in the Analysis profile, then return to Analysis > Results > Statistics and Charts.

Remove a Header from the Table

Example: Remove the Arena name from your table headers.

1. Click the Layout button on the toolbar.
2. In the On Columns/On Rows box, click Arena.
3. Click the arrow button which points to the Available box.

• To remove measurement units, in the Layout window de-select Measurement units.
• To remove the detail of a dependent variable, like the body point name, in the Layout window de-select Detail about variable.

Note: Removing an element from the headers does not aggregate the results under that header. For example, if you remove Arena, all results are still displayed for each arena separately. If you want to aggregate results, see Define Groups of Tracks.

Move a Header Between Rows and Columns

Example: The dependent variables (Velocity, In zone, etc.) are placed in columns. Move them to the rows, so that each row represents one trial/dependent variable combination.

1. Click the Layout button on the toolbar.
2. In the On Columns box, click Variable with detail.
3. Click the arrow button which points to the On Rows box.

Swap Rows and Columns

Select each item under On Columns and move it to On Rows. Next, select the items originally under On Rows and move them to On Columns.

Modify the Table Hierarchy

To place a header to a higher level in the table, click the element in the On Columns or On Rows box, and then click the Up button.

To place an element lower in the table hierarchy, click the element in the On Columns or On Rows box, and then click the Down button.

Note: It is not possible to put Time bin above the Selection Result.

Show and Hide Part of the Table

1. Click the Show/Hide button at the top-right corner and select the corresponding element.
2. In the window that appears, select the trials, arenas, subjects, etc. that you want to have in the table.
3. Click OK.

Remove Empty Rows or Columns

Tip: Do this if you have many rows or columns that are empty and you want to export only the rows and columns with significant results.

In the Layout window, select Hide empty rows or columns.

Note: Rows and columns are not removed if at least one dependent variable is calculated for that row or column.

Reset the Table Layout

To return to the default layout, click the Layout button and in the Layout window click the Reset Default button.

Move the Headers in the Group Statistics Results Table

The results of group statistics shows the group statistic under the trial statistic. For example, you may find the group statistic Mean under the trial statistic Total for distance moved, meaning that the result is the mean value of the total distance moved calculated for each trial in that group.

When you click the Layout button, the item Group Statistic with units is selected under On Columns.

You can move the Group statistics headers and the units to the table rows or move them to a higher level in the table.

• Move a header between rows and columns
• Modify the table hierarchy
• To have the track groups in different columns instead of rows, select Selection Result and move it to On Columns.

Special Headers in the Layout Window

• Statistic with unit and Group statistic with unit show the names of the trial statistics and group statistic selected in the Analysis profile, respectively. If you move those headers in the table, the measurement units are moved to the same location.
• Selection Result refers to the dataset specified in the Results boxes of the Data profile. If the Data profile includes two or more Result boxes, for example to group tracks, the headers for the corresponding boxes are automatically added to the table. If you remove Selection Result from the rows and columns, the results for different groups are still kept separate, because the Data profile defines the grouping.