The example below groups the results of the age column into a segment group. People with an age 13 and 18 (inclusive) are grouped as teenagers.
For example:
|
<iframe width="700" height="394" src="https://www.youtube.com/embed/NEOZ_7-T2So?color=white" frameborder="0" allowfullscreen></iframe> |
The grouping form on your menu will open will vary based on the type of column you are grouping. The different types of columns are numeric/date or text. The key fields for these are:
Display | This is the text that will replace the value in the report based on the condition. |
Operator | This is the condition in which the variable name will apply to if the value in the report meets the condition. |
Values | The value in the report or number in which the operator is being applied to. |
Note: groups cannot be defined for a field that has an aggregation applied to it. Remove any aggregation settings to make the Group Data option available.
Operator | Description |
---|---|
Text Based Operators |
|
In List | One or more alphanumeric or string values |
Not In List | Two or more alphanumeric or string values |
Numeric Based Operators |
|
Equal to | Equal to a single alphanumeric or string value |
Greater than | Greater than a single alphanumeric or string value |
Greater than or equal to | Greater than or equal to a single alphanumeric or string value |
Less than | Less than a single alphanumeric or string value |
Less than or equal to | Less than or equal to a single alphanumeric or string value |
Different from | Not equal to or different from a single alphanumeric or string value |
Between | Between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
Not Between | Not between variable 1 and variable 2 these will need to be legitimate parameters such as date, age etc. |
Is Null | Record contains no value for selected attribute. No Parameter can be set |
Is Not Null | Record contains a value for selected attribute. No Parameter can be set |
Like | Records that contain the same letter or letters. |
Starts With | String starts with letter or letters |
Ends With | String end with letter or letters. |