Cloud Software Group, Inc. EBX®
Insight Add-on (New) Documentation > Reference Guide > Function reference
Navigation modeInsight Add-on (New) Documentation > Reference Guide > Function reference

Table functions

T01 - Table record count

Label:

Table record count

Description:

Calculates the number of records in a table.

Input label:

N/A

Output label:

Number of records

T02 - Completeness rate

Label:

Completeness rate

Description:

Computes the completeness rate of a table.

Input label:

N/A

Output label:

Completeness rate

T03 - Table validation report

Label:

Table validation report

Description:

Executes the validation report on a table and saves the number of fatal errors, errors, warnings and information.

Input label:

N/A

Output labels:

Fatal error

Error

Warning

Information

T04 - Number of operations

Label:

Number of operations

Description:

Computes the number of created, updated, and deleted records for a given table.

Input label:

N/A

Output labels:

Number of creations

Number of updates

Number of deletions

T05 - Number of users by operation

Label:

Number of users by operation

Description:

Computes the number of users that perform creations, updates, and deletions in a given table.

Input label:

N/A

Output labels:

Creation

Update

Delete

T06 - Last modification date

Label:

Last modification date

Description:

Provides the last update date of the asset.

Input label:

N/A

Output labels:

Last modification date

T07 - Number of missing values

Label:

Number of missing values

Description:

Counts of the number of missing values for a table (it computes the number of missing values in each field and for each record in the table).

Input label:

N/A

Output labels:

Number of missing values

T08 - Table freshness

Label:

Table freshness

Description:

Computes table freshness (the average of each record's freshness score). A record's score is calculated using the following method: subtract the indicator's last execution date from the record's last modification date. The lower the score, the fresher the data.

Input label:

N/A

Output labels:

Table freshness (in days)