Table Functions

<< Click to Display Table of Contents >>

Navigation:  User Interface > Ribbon Bar > Table >

Table Functions

Previous pageReturn to chapter overviewNext page

Group

Shows a window where you can check columns you want to use for grouping. As a result, a new document is opened where records are grouped by the columns you have selected. The new document contains columns you have selected and a number of records of the original table that have the same values in these columns.

You can also group data by a sub string. In this case enter the start position and the length in the group dialog.

The grouped result can be expanded to the original data if the original table is still opened. You can do it by the Expand group command from the pop-up menu.

If the original table is not opened any more then the Expand group command is unavailable.

 

clip0110

 

When you group your data in the Group By window you can also specify some aggregate functions. They are specified by function codes entered in the last column. Function codes can be entered only for unselected columns and every letter entered creates a new column with result of the aggregation. For example, if you want to display minimal and maximal values of a column then enter IX on its line.

Available function codes are:
 
I - minimum

X - maximum
A - average
S - sum

 

clip0009

 

Statistics

Scans the whole table and displays its statistics. The statistics contains numbers of not empty records of every column and minimal and maximal values of each column.

 

All

Shows a menu with available line commands for the current display and executes the selected line command for every line of the table. This function can take a long time in some cases and therefore you should use it carefully.

When no line commands exist for the current table then this command is inaccessible.

 

clip0029

 

Subtable

Creates a new document (table) that contains only lines selected in the original table.

 

Graph

When the current document contains data that can be shown as a graph (netplans, barcharts), then the graph can be displayed by pressing that icon. A combination of Subtable and Graph functions can be very useful for graphical displays as it helps you to create graphs of only selected records.