Column Values
The column values include values for columns and the frequency in which the value appears for the column. The column values also include a pie chart that represents the values and their percentages. The Analyst tool displays a pie chart only if the total number of rows for the top 10 values on the Values tab is greater than 25% of the total number of rows in the data source.
The following table describes the properties for the column values:
Property | Description |
|---|
Value | List of all values for the column in the profile. Note: The Analyst tool excludes the CLOB, BLOB, Raw, and Binary data types in column values in a profile. |
Frequency | Number of times a value appears for a column, expressed as a number, a percentage, and a chart. |
Percent | Percentage that a value appears for a column. |
Chart | Chart for the percentage. |
Drill down | Drills down to specific source rows based on a column value. |
Note: To sort the Value and Frequency columns, select the columns. When you sort the results of the Frequency column, the Analyst tool sorts the results based on the data type of the column.