Compare to Range

The Compare to Range criterion allows you to create a criterion that compares an attribute against a range of values.

The following criterion properties must be defined:

•       ‘From’ and a ‘to’ values: the data type of the values must be appropriate for the data type of the attribute upon which the criterion is based: 

o  String: all values appropriate

o  Integer: only integer values appropriate

o  Decimal: only numeric values appropriate

o  Date/time: only date/time values appropriate (note that date picker controls are provided if creating a criterion based on a date/time attribute). 

Note that range values are inclusive.

Note that, if running RPI against a Splice Machine data warehouse, that database’s lexicographic ordering of strings has the potential to impact a standard selection rule's count results when performing a range comparison between numeric values stored as strings.