Viewing Data Using Tables
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:
-
From the View Data tab, 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.
-
There are two ways to add fields to the table in the initial view.
-
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.
-
-
Use the Select columns to show drop-down to add a field from the dataset.
-
To view only the table, click the View Table icon. No charts will be showing after selecting the icon.
- 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.
- 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.
- 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.See Modifying Column Display.
- Use the Group by Columns drop-down to select columns to use for grouping.See Modifying Column Display.
- Use the Aggregate Columns link select columns used to aggregate values. Values available in a column can be Min, Max, Mean, Count, and Sum. See Modifying Column Display.
- 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.