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 thanGT
, less thanLT
, greater than or equal toGET
, less than or equal toLTE
, not equal toNEQ
,BETWEEN
,LIKE
,IN
, andAND
. - 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.