You can use groups and sets to organize your results. These options are available in the Calculation engine menu of the Query Builder.
A set is a list of selected attribute values. For example, if you want to create a report by state, but only for a specific region, you can create a set from your States attribute to include only the relevant states. Using a set will both filter and label results for your chosen values.
An ordered set is useful when you want to arrange values in an order that is not alphabetical or numerical. For example, you could organize a sales funnel to display results by workflow.
To create an ordered set
- In the Query Builder, click the Calculation engine icon ().
- Select the Ordered set option.
- Enter a name. In the example above, the ordered set is named Stages.
- Select your attribute.
- Drag and drop values until they are in the preferred order.
- Click the Save button when you are finished.
- Add your ordered set as an attribute to Columns.
- Your results will now be displayed in the new order.
A renamed set can be used to shorten results, create aliases, or replace technical text with more common labels. If you give the same new name to several values, renaming sets can be an alternative to grouping.
To create a renamed set
- In the Calculation engine menu, select Renamed set.
- Enter a name for your renamed set.
- Select your attribute.
- Enter the new value names in the textboxes.
- Click the Save button when you are finished renaming your values.
- Add your renamed set to Columns.
A group is an additional way to organize your attribute values. A group has some advantages over a set.
First, you can use your group to look at the aggregated results for its members. Second, you can create multiple, exclusive, groups from an attribute. This means that the groups can be used to compare results at an aggregate level, or with the original attributes to organize results into a hierarchy.
To create a new group
- In the Calculation engine menu, select Group.
- Enter the group name.
- Select the attribute from which you wish to create your group.
- Click the + icon to add values to a group. The example below adds values from the Location attribute to a new group.
- Once you have chosen the values for all your groups, you have three choices for the values left. You can put them into another group, show them individually (leave 'as is'), or remove them.
- Click the Save button when you are finished selecting your values.
- Add the group attribute to Columns.