Analysis

Key/Combination Analysis

This function is to evaluate uniqueness of valies in some field or field combination. For example, we need to evaluate if some field or several fields are fit for Primary or Alternative key.

Another goal of this function is to review unique and non-unique values of field or several fields in the table.

Select table in table list, select necessary field or fields in Fields window, then click Operations window, Analysis group, Key/combination analysis.

New analysis window will open.

In the header you can see parameters and metrics.

Parameters:

Table - table for analysis

Fields - fields for analysis, it is separated by comma

If you change Table or Fields, press Refresh button.

Metrics:

* Total records number in the table

* Count of unique records/combinations - how many combination of fields met in the table, with the only record in the table

* Count of non-unique combination - how many combination of fields met in the table, with 2 or many records in the table

* Count of non-unique records - how many records of fields are for non-unique combinations, i.e. combination of fields met in the table, with 2 or many records in the table

Besides metrics you can see details of the table in two kinds:

* Unique records

* Non-unique records: in the header you can see combination, and in nested table you can see records of the table

Field values analysis

This function is close to Key/combination analysis, however it works with individual fields only.

The function allows to evaluate values of fields in the table, and frequency of use the values in the table.

Select table in table list, select necessary field or fields in Fields window, then click Operations window, Analysis group, Field values analysis.

New analysis window will open.

All selected fields will be represented in two fields: <field name>, <field name_cnt>

<field name> (e.g. Name) is selected field, it includes unique values of the field.

<field name_cnt> (e.g. Name_cnt) is number of repetitions that values are met in the table.

Grouping analysis

Grouping analysis is used to track aggregating functions in one grid.

The advantage of this function (as opposed to a query with the standard SQL group by construction) is 1) you can see in one grid (tree grid) grouped results with details of elementary data. Other words at any time you can see what consists some result of grouping. 2) you can get multi-level grouping.

Grouping analysis supports several levels of grouping. Grouping on each next level is based on previous level.

Select table in table list, select necessary field or fields in Fields window, then click Operations window, Analysis group, Grouping analysis.

In appeared window specify level of grouping and grouping functions, then press Refresh.

Results will be appeared in Tree table, every level of the table is level of grouping.