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.
Date ranges
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 a window where you can specify advanced settings of the copy. For more information see Copy special from Time table
What analyses work with this chart type?
All types of analyses which remove time parameter and turn series into category series or use such series.
Example
In this example we presented available types of charts.