Page History

DIMENSION 

Dimensional Value. The report builder will use dimensional filter paradigm for this column, and restrict aggregation types to COUNT and COUNT DISTINCT. 

METRIC 

Metric/Measure value. The report builder will use metric filter paradigm for this column, and allow all available aggregation types. 

UNKNOWN 

Unknown column type. This should not be used. 

COUNT 

Count all values of a column. 

COUNTDISTINCT 

Count all distinct values of a column. 

AVG 

Average the values of a column. 

MAX 

Return the maximum value of a column. 

MIN 

Return the minimum value of a column. 

SUM 

Return the sum of the values in the column. 

EQUAL 

Values are equal. 

NOTEQUAL 

Values are not equal. 

INLIST 

Value is within a defined list of values. 

NOTINLIST 

Value is not withing a defined list of values. 

GREATER 

Value is greater than a value. 

GREATEREQUAL 

Value is greater than or equal to a value. 

LESS 

Value is less than a value. 

LESSEQUAL 

Value is less than or equal to a value. 

BETWEEN 

Value is between two bounds. 

NOTBETWEEN 

Value is not between two bounds. 

ISNULL 

Value is null. 

ISNOTNULL 

Value is not null. 

STARTSWITH 

Text starts with a value. 

NOTSTARTSWITH 

Text does not start with a value. 

ENDSWITH 

Text ends with a value. 

NOTENDSWITH 

Text does not end with a value. 

CONTAINS 

Text contains a value. 

NOTCONTAINS 

Text does not contain a value. 

ISEMPTYSTRING 

Text is empty string. 

ISNOTEMPTYSTRING 

Text is not an empty string. 

TYPE_UNKNOWN 

Unknown Value. 

TYPE_NUMERIC 

Numeric Value. 

TYPE_TEXT 

Text Value. 

TYPE_PASSWORD 

Password Value. 

TYPE_BOOLEAN 

Boolean Value.