Modifying Column Display in Tables
The appearance of a table is modified by using options available from the toolbar and footer of the Full Data (With Global Filter Applied) display panel.
The Full Data (With Global Filter Applied) panel loads when dataset measurements are loaded from the View Data tab. It also displays when the View Table icon is selected from the right-hand toolbar.
When Full Data panel loads, it will show the column for the last field plotted for the dataset. If no fields have been plotted for a data set, you will see a message to choose the Fields button to select fields to view. See Plotting Data as Charts for more information.
If you have already plotted a field as a chart, you will see the last plotted field showing as a header in the Full Data table, and it will appear in the Select Columns to show drop-down.
With a field displaying, you can add fields by using the Select columns to show drop-down or plotting a field as a chart.
Selecting Columns Using Select Columns to Show
To select columns to display:
-
Select the down arrow next to the field name currently displayed.
-
Select the checkbox next to the fields you want to display.
The column will be added. If it isn’t already displaying, data for selected columns will load with the selected columns. The following options can also be used to select or deselect all columns at the same time:
-
Use the Select All option to see all field columns in the table at once.
-
If all columns are already selected, the Deselect All option displays allowing you to clear all columns from the table.
-
You can also remove columns from the table by selecting the check next to the field you want to remove.
If you try remove a field that is used in Group By or Aggregated By, you will receive a dialog stating the column is still being used. Remove the field from Group By or Aggregate By (see section below) in order to deselect it from Select columns to show.
Grouping and Aggregating Columns
The Group By and Aggregate By drop-down menus allow you to create basic summary views of data.
To group and aggregate columns:
-
Select the columns you are interested in examining.
-
Select the column to be used for grouping results.
-
Select the column and measurement summary to aggregate the results. In the example below, pedal_width mean is used for aggregation.
The resulting table will show the aggregate measurements group as specified. In this example, the petal_width mean is grouped by petal_length.