Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Overview

You can change the data returned for selected fields on your report by grouping the values. This provides you with the ability to add additional layers of analysis to your reports.

...

Section
Column
width5%

Age

Sales

16

$1,500

17

$750

25

$1,300

Column
width10%

Update ages to group all between 13 and 18 into a Teen bucket.

Column
width5%

Age

Sales

Teen

$2,250

25

$1,300

Column
width80%
 

Creating a Grouped Variable

...

  1. Select Group Data from the field drop down menu.
  2. You will now have a list of groups currently applied to the field, which you can click on to edit or delete, and an Add Group option to define a new group.
  3. 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.
    For more details see below.

    Values

    The value in the report or number in which the operator is being applied to.

    Image Modified

  4. Once these fields have been filled in you can add it to the grouping list by pressing Save. The grouping will appear in a list.
  5. To delete a grouping from the report simply click the delete button located next to the group name.
  6. To edit a grouping from the list, select the grouping by clicking the group name hyperlink. This will open the edit form where you can make your changes.
  7. When you have finished with the groupings press save and the report will refresh with the new groupings applied.

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.