Trend Reports

In trend reports, you can use formulas to perform any row-based calculations in the Measure By section. If you are looking to transform any dimensions in the Compare By section, you will need to edit these using the Custom Action Schema Properties

🚧
Trend Reports
Trend reports are limited to number type operations only.

You can add a formula by clicking to add a column under the Measure By section. Here you'll select to add a formula.

Once you select to add a formula, you can choose which operation you'd like to perform. In the example below, we simply choose to add the People column + 10.

1265 — You can perform any row based operations and even combine multiple operations when using Formulas.

Profile Reports

In Profile Reports, you can use formulas to perform row-based operations using numbers, booleans or strings.

To add a formula, you can click to add a column and select Formulas.

Once you add a formula, you can select which operation you'd like to use. For example, if I wanted to concatenate two columns together, I could use the CAT operations like so:

Operations

These are the various operations you can use when using formulas. Trend Reports are limited to Number type operations only.

OPERATION	DEFINITION	TYPE	PARAMETERS
MAX	Returns the largest number in a list of numbers	Number	<number> number
SUM	Returns the sum of the numbers	Number	<operand> number
AVG	Returns the average of the numbers	Number	<input> number
SQRT	Returns the square root of <number>	Number	<number> number
MULTIPLY	Returns the multiplication of the numbers	Number	<operand> number
SUBTRACT	Returns the subtraction result {0} - {1}	Number	<operand> number
CEIL	Rounds <number> up	Number	<number> number
POW	Returns the value of <number> ^ <exponent>	Number	<number> number <exponent> number
DIVIDE	Returns the division result of <divisor> / <dividend>	Number	<dividend> number <divisor> number
MIN	Returns the smallest number in a list of numbers	Number	<number> number
ABS	Returns the absolute value of <number>	Number	<number> number
FLOOR	Rounds <number> down	Number	<number> number
REGEX_GROUP	Finds the subsequence at <index> of the input sequence <pattern> that matches <input>	String	<pattern> string <input> string <index> number
TO_LOWER_CASE	Converts <text> to lowercase	String	<text> string
TO_UPPER_CASE	Converts <text> to uppercase	String	<text> string
SUBSTRING	Returns a string that is a substring of <text>. The substring begins with the character at <beginIndex> and extends to the end of the string	String	<text> string <beginIndex> number <endIndex> number
URL_TO_HOST	Extracts the host part of <url>	String	<url> string
IF_THEN_ELSE	Returns <true result> if <condition> is True, else returns <false result>	String	<condition> boolean <true result> string <false result> string
CAT	Concatenates a list of strings	String	<part> object
CONTAINS	Returns True if <input> contains <matcher> Will include partial match	Boolean	<input> string <matcher> string
EMPTY	Returns True if <input text> is empty	Boolean	<input text> string
MATCH	Returns True if <input> matches <matcher> Includes exact match (case insensitive)	Boolean	<input> string <matcher> string
EXACTMATCH	Returns True if <input> matches <matcher> (case sensitive) Includes exact match (case sensitive)	Boolean	<input> string <matcher> string
STARTS	Returns True if <input> starts with <matcher>	Boolean	<input> string <matcher> string
ENDS	Returns True if <input> ends with <matcher>	Boolean	<input> string <matcher> string
REGEX_MATCH	Returns True if <input> matches against <pattern>	Boolean	<input> string <pattern> string
OR	Returns TRUE if at least one of its arguments is True	Boolean	<condition> boolean
AND	Returns TRUE if all of its arguments are True	Boolean	<condition> boolean
NOT	Reverses the logic state of <input>	Boolean	<input> boolean
LTE	Returns True if <Number A> is less than or equal to <Number B>	Boolean	<Number A> number <Number B> number
NEQ	Returns True if <Number A> is not equal to <Number B>	Boolean	<Number A> number <Number B> number
EQ	Returns TRUE <Number A> is equal than to <Number B>	Boolean	<Number A> number <Number B> number
LT	Returns TRUE <Number A> is less than to <Number B>	Boolean	<Number A> number <Number B> number
GT	Returns True if <Number A> is greater than <Number B>	Boolean	<Number A> number <Number B> number
GTE	Returns True if <Number A> is greater or equal to <Number B>	Boolean	<Number A> number <Number B> number

Overview

Trend Reports

🚧
Trend Reports

Profile Reports

Operations

Trend Reports

🚧Trend Reports

Profile Reports

Operations

🚧
Trend Reports