Content Comparison

This section describes the syntax used when creating calculated fields in Ad Hoc views. 

...

• • Span
    style color:#000000;
    BooleanExpression: any expression that takes on Boolean values, including the label of a Boolean field or measure, a Boolean calculation, or a Boolean value. You can create a BooleanExpression using the following: comparison operators: "(==, !=, >, >=, <, <=, in)." Functions that return Boolean values: "StartsWith," "EndsWith," "IsNull," "Contains," and logical functions: "AND," "OR," "NOT."

    
    
    

  • Span
    style color:#000000;
    DateExpression: any type of date or timestamp values, including the label of a date field or measure, or a calculation that returns dates.

    
    
    

  • Span
    style color:#000000;
    DateTimeExpression: date expressions that contain time values, including the label of a date field or measure, or a calculation that returns dates. These values are also known as timestamp values.

    
    
    

  • Span
    style color:#000000;
    Expression: any valid date, date-time, numeric, or string expression.

    
    
    

  • Span
    style color:#000000;
    NumericExpression: numeric values, including the label of a numeric field or measure, or a calculation that returns numbers.

    
    
    

  • Span
    style color:#000000;
    TextExpression: text values, including the label of a text field or measure, or a text string.

    
    
    

  • Span
    style color:#000000;
    Level: for aggregate functions, specifies the set of values used to compute the calculation. Possible values include: "Current" (not available for "PercentOf"), "ColumnGroup," "ColumnTotal," "RowGroup," "RowTotal," and "Total."

    
    
    

...

...

...