Each attribute contains a set of distinct values. Generating a list of attribute values allows you to see how often a value is repeated within an attribute, which rows contain the value, and which attributes contain more distinct values than others. By following these steps, you identify distinct values and how often they occur in a particular attribute.
To list distinct values and value distribution
List all distinct values in an attribute and how often they occur
To list all distinct values in an attribute and how often they occur
The Values List View displays. Note the following:
- The Value column displays the value name.
-
The Frequency column displays the number of times the value occurs in the attribute.
-
The Dist% column displays the percentage of how much of the attribute contains the value.
List specific rows containing distinct values
To list specific rows containing distinct values