Faceting Column Data

Faceting regroups your data according to your configurations. When working on a column, you can apply various faceting methods.

TIBCO Clarity provides the following faceting methods specific to a column:

Text facet: Use the text faceting to see what different values are for a column and the number of occurrences of each value.
Custom text facet: Use a regular expression to see what different values are for a column and the number of occurrences of each value.
Numeric facet: Use the numeric faceting to get an overview of the number distribution for the cell values in a column.
Note: This option is available only when the column data type is Integer, Long, Float, or Double.
Custom numeric facet: Use a regular expression to get an overview of the number distribution for the cell values in a column.
Note: This option is available only when the column data type is Integer, Long, Float, or Double.
Text pattern facet: Use the text pattern faceting to find out the patterns used in a column and filter out inconsistent data formats.
Timeline facet: Use the timeline faceting to check data formats. Before you apply the timeline facet, you have to define the validation rules.
Note: This option is available only when the column data type is Date, DateTime, or Time.
Scatterplot facet: Use the scatterplot faceting to get a graphical representation of numerical values.
Customized facets: Use the following supported customized facets to analyze your data:
- World facet lists all the different words used in a column. A word is a text string defined between two whitespace characters.
- Duplicates facet detects duplicate values in a column.
- Numeric log facet displays the logarithm of numbers instead of actual values.
- 1-bunded numeric log facet displays the logarithm of numbers.
- Text length facet organizes the objects according to the number of characters contained in a string.
- Log of text length facet displays a chart to analyze text length.
- Unicode char-code facet lists the characters used in a string.
- Facet by error lists invalid values in a column.
- Facet by blank lists the blank values in a column.

The following is text faceting result of the Gender column in the Sample-students_records dataset. Hover you mouse on a faceting result to view the matched data.