Indicator parameters
This section describes indicator parameters displayed in the different
Indicators Settings dialog boxes.
Bins Designer
| Possible value | Description |
|---|---|
| Minimal value | Beginning of the first bin. |
| Maximal value | End of the last bin. |
| Number of bins | Number of bins. |
Blank Options
| Possible value | Description |
|---|---|
| Aggregate nulls with blanks | When selected, null data is counted as zero length text field. This means that null data is treated as an empty string. When not selected, null data is treated as any other text data. |
| Aggregate blanks | When selected, blank texts (e.g. " ") are all grouped together
and considered as an empty string. When not selected, blank texts
are treated as any other text data. Information noteNote: In Oracle, empty strings
and null strings are the same objects. Therefore, you must
select or clear both check boxes in order to get consistent
results.
|
Data Thresholds
| Possible value | Description |
|---|---|
| Lower threshold | Data smaller than this value should not exist. |
| Upper threshold | Data greater than this value should not exist. |
Value Frequency Parameters
| Possible value | Description |
|---|---|
| Number of results shown | Number of displayed results. |
Indicator Thresholds
| Possible value | Description |
|---|---|
| Lower threshold | Lower threshold of matching indicator values. |
| Upper threshold | Higher threshold of matching indicator values. |
| Lower threshold(%) | Lower threshold of matching indicator values in percentage relative to the total row count. |
| Upper threshold(%) | Higher threshold of matching indicator values in percentage relative to the total row count. |
| Expected value | Only for the Mode indicator in the Advanced Statistics. Most probable value that should exist in the selected column. |
Java Options
| Possible value | Description |
|---|---|
| Characters to replace | List of the characters to be replaced. |
| Replacement characters | List of the characters that will take the place of the replaced
characters. Information noteNote: Each character of the first field will be
replaced by the character at the same position from the second
field. For example, with the values "abc0123ABC,;.:" in the
first field and "aaa9999AAApppp" in the second field any "a",
"b" or "c" will be replaced by "a" and any "0", "1", "2" or "3"
will be replaced by "9".
|
Phone number
| Possible value | Description |
|---|---|
| Country | Country ISO2 code of the phone number. |
Text Parameters
| Possible value | Description |
|---|---|
| Ignore case | When selected, comparison of text data is not case sensitive. |
Text Length
| Possible value | Description |
|---|---|
| Count nulls | When selected, null data is counted as zero length text field. |
| Count blanks | When selected, blank texts (e.g. " ") are counted as zero length text fields. |