Column Frequency- Frequency by Frequency report

The Column Frequency by Frequency report includes the value, the frequency of the value, and the cumulative frequency of values in the report, line by line.

The cumulative percentage will only include the total percent through the values displayed in the report. The summary will include the total record count as well as the total records included in the report.

Parameters

Specify the parameters for the report:

Project Name

Select the name of the project that contains the columns that you want included in the report.

Host Name

Select the host name that has the columns that you want to be included in the report.

Data Store Name

Select the data store on the selected host computer. A data store is a virtual entity that has connection details to the source repository.

Database Name

Select the name of the database that you want to include in the report.

Table Name

Select the tables that you want included in the report.

Column Name

Select the columns that you want to find frequency values for that you want included in the report.

Enter data collection parameter

Select the columns that you want included in the report.

Display notes

Select this option if you want any notes associated with the column included in the report.

Show Custom Definitions

Select this option to include aliases and definitions that you created in the report.

Frequency Limit

Enter an optional frequency cutoff value to reduce the values generated. To see all values enter 0. This will display values that have occur 0 or more in the columns you select.

Comments

Enter any comments you want included in the report output.

Locale specification [Language,Territory]

Select the language and demographic region for the data included in the report.

Output format

Specify the format that you want for your report. You can select HTML, XML, RTF, PDF, or TXT.

Expiration

Specify when you want your report to expire.

History policy

Specify whether you want your report data to replace older versions each time it is run, or if you want to archive each individual report you run.

Report name

Specify a name for the report.

Save report

Select this option if you want to save this report so you can run it again in the future. If you want to save your report, then you must select the folder in which you want to save the report. You have the option of adding the report to your favorites folder, and of viewing the report after the processing finishes.

Content

The following defines the structure of the report:

Heading

Column Frequency- Frequency by Frequency

Main Section

Column Level Summary

Cardinality Count

Null Count

Actual Row Count

Frequency Cut Off

Total Rows Covered

% Rows Covered

Frequency Distribution Data

Distinct Value

Frequency Count

Frequency %

Cumulative %