Restrictive Conditions for Metric Mapping¶

When configuring metric mappings, you can add restrictive conditions to filter specific fields. The expressions of the restrictive conditions must follow the specifications below:

The expression specification for the where clause in the SQL statement supports operators, including equal EQ, greater than GT, less than LT, greater than or equal to GET, less than or equal to LTE, not equal to NEQ, BETWEEN, LIKE, IN, and AND.
Multiple restrictive conditions for the same metric must be separated by English-script colons.
In Data Source Configuration, when Dimension is set to ALL, dimension attributes are not supported in expressions.
In Data Source Configuration, when the Calculation Method is set to Fact Table Pass-Through, the fields in the fact table can be used in the expression.