Metric | Values |
|---|---|
Compare to Constant, Operator | Select one of the following options: • Equal (default) • Greater • Greater or Equal • Lesser • Lesser or Equal • Not Equal |
ComparetoField, Operator | Select one of the following options: • Equal (default) • Greater • Greater or Equal • Lesser • Lesser or Equal • Not Equal |
Distinct Values, Sort Order | Select one of the following options: • Field Data (Faster) • Frequency Count (Slower) Note: Frequency Count (Slower) sorts the results in descending order and hence the sorting is slower compared to Field Data sort option. |
Duplicate Values, Sort Order | Select one of the following options: • Field Data (Faster) • Frequency Count (Slower) Note: Frequency Count (Slower) sorts the results in descending order and hence the sorting is slower compared to Field Data sort option. |
Duplicate Values, Min Count | Click on the text box to specify the required value. Default value is 2 |
Equal Range Binning, Range Count | Click on the text box to specify the required range count. Default value is 10 |
Matches Regex, Regex Pattern | Click on the text box to specify the required regex pattern. Default value is .* Specifying “.*” matches against any sequence of characters. |
String to Date, Date Pattern | Click on the text box to specify the required date pattern. Default value is yyyy-MM-dd |
String to Timestamp, Timestamp Pattern | Click on the text box to specify the required timestanp pattern. Default value is yyyy-MM-dd HH:mm:ss |
String to Time, Time Pattern | Click on the text box to specify the required time pattern. Default value is HH:mm:ss |
Most Frequent Values, Top How Many | Click on the text box to specify the required most frequent values. Default value is 25 |