BETWEEN

The BETWEEN operator computes the metric by using attribute values, metrics or macros, from a specified range (including/excluding endpoints). As a filtering operator, it includes only those attribute values that fall within some specified range. The range is specified by two inclusive attribute value endpoints.

Syntax

SELECT … WHERE … BETWEEN … AND …
SELECT metric WHERE attribute BETWEEN attribute_value1 AND attribute_value2

Examples

SELECT Profit WHERE Year BETWEEN 2005 AND 2008
SELECT Sales WHERE (Quarter BETWEEN THIS - 5 AND THIS)

In this last example, the time macro THIS serves as an attribute value, though it can be typed directly into the Metric Editor rather than selecting it from the Project Element Sidebar.