Category table

Overview

When you want to take a close look at individual values in your data, you can view your series in a table. When the series you’re viewing are category series, this will be a category table. The first column of a category table displays the labels of the categories, and each column after that displays the values of each series in the document. In the analysis tree, you can add a category table after doing an analysis that outputs category series, such as scalar or slice.

Settings

 

Properties for Table

The table’s main properties are adjustable at the top of the window, under the presentation properties tab.

Appearance

Here, you can change the order and format in which the time variable is presented, as well as lock the format in which the values are presented.

Checking the oldest first option will reverse the default order of the category column.

Disable formatting locks the current format in which the series values are presented. When this box is checked, the formatting options scale and decimals, located in the table layout window, are disabled.

Display range

In a category chart, scale adjusts what categories are displayed on the chart. Instead of typing dates into the display range, you should type absolute or relative index values such as #1 or -1. If you select start at shortest or end at shortest, the display range of the chart will be adjusted based on the categories for which all series have values (if the chart includes more than one series).

Table layout

To access the table layout window, right-click anywhere on the table and select table layout. Here, you can select which series to include or exclude in the table and adjust the order in which they’re presented. Unchecking the auto box also enables you to change the number of decimals displayed and scale the values of the series.

Additional options

When you select all or part of your table and right-click, the following additional options are available.

Copying the data

You can copy the selected data in one of two ways:

  • Copy creates a standard copy of the selected date and values of the table
  • Copy special opens an window where you can specify advanced settings of the copy