Viewing Data Using Table
Besides plotting charts, the KS6800A PathWave Measurement Analytics software lets you view the actual values of your measurement / property data in a tabular form. This feature is useful for comparative analysis of values in a dataset.
To view data as a table:
1. Select the Measurements button for the dataset being analyzed. See Viewing Measurements in a Dataset.
The initial view of the dataset displays. This view shows previously plotted fields, if any, and the Full Data (with Global Filter Applied) table.
2. There are two ways to add fields to the table in the initial view:
i. Plot data of one or more fields as charts in a dataset. See Plotting Data as Charts. The plotted field will be added as a column to the Full Data table.
ii. Use the Select columns to show drop-down to add a field from the dataset.
3. To view only the table, click the View Table icon. No charts will be showing after selecting the icon.
The Full Data (with Global Filter Applied) page displays.
4. Select the Show Sample Values link to populate the table with sample values. This action displays the values available in a column. Note there are no duplicates displayed because these are not measurements.
The sample values are displayed in tabular form in the Full Data page.
5. Select the Show Real Values link to populate the table with real values. These values are real data and each row shows a specific measurement. Note that duplicate values appear because the rows represent measurements.
The real values in the plotted charts are displayed in tabular form in the Full Data page.
6. You may perform the following actions on the Full Data page.
- Select columns to display from the Selected drop-down. The drop-down also provides a search filter and Select All option to assist in field selection.
- Use the Group by Columns drop-down to select columns to use for grouping.
- Use the Aggregate Columns link select columns used to aggregate values. Values available in a column can be Min, Max, Mean, Count, and Sum.
- Select Download CSV to save the table as a CSV file.
- Select Save As CSV to save the table as renamed CSV file.
- Select a value from the Items per page drop-down to modify the number of values to be displayed in each column per page. By default, 20 values are displayed
- Use the navigational buttons to view data on the next / previous pages or last / first pages.