When you want to take a close look at individual values in your data, you can view your series in a table. When these are time series, they will be presented in a time table. The first column of a time table displays the dates and each column after that displays the values of each series in the document. In the analysis tree, you can add a table after the series list or after any analysis.
Properties for Table
The table’s main properties are adjustable at the top of the window, under the presentation properties tab.
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 order the date column from oldest at the top to newest at the bottom. By default, dates are presented from newest to oldest.
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.
The setting under period date is available when the frequency of your document is lower than daily. It determines the format in which the date for the period is presented in the table. There are three options here:
- Label displays the name of the entire period
- First displays the first date of the period
- Last uses last date of the period.
Here, you can change the first and last dates which are displayed in your table by typing in dates next to Display range.
If you select Start at shortest or End at shortest, the display range of the table will be adjusted based on the start or end date of the shortest series (if the table includes more than one series).
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. Include new series automatically option is by default checked, it means any new series added to document will be included in the time table. You can uncheck it, so new series won't be added automatically.
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
Save series as in-house
You can save the selected data as an in-house series in two ways. Save values saves only the values that are visible in the table and Save calculations saves the calculations that resulted in the visible values. If you save the calculations, new values can be automatically calculated and added to this in-house series.
NOTE: Both Series name and Document name should start with a letter and contain only lower case letters and numbers. Each should contain between 2 and 24 characters.