Creating data groups
You can organize the column data into custom groups so that the data is easier to read and analyze.
For example, in the Employee code column, you can group employees into ranges, such as 0-100, 101-200, 200+. In the Manager column, you can group managers according to their rank, such as First line manager, Senior manager.
About this task
- Numeric style.
Each data group includes a range of values. By default, this style is available for columns with numeric data types. However, while you create the data group, you can switch to the text style, and continue switching between the two styles until you save the group.
- Text style.
Each data group includes individual values. By default, this style is available for columns with text data types. For columns with numeric data types, you can switch to this style when you create a data group.
For stand-alone (global) calculations, data grouping is available only when the Aggregate property on the calculated column is set to None, and the data type is numeric or string.
Procedure
What to do next
To edit the data group, click its context menu icon , and select Edit data group. If you need to modify the group
expression, go to Properties, and for the Expression
property, click the View or edit link. After you modify the expression and
save it, the Edit data group option is no longer available from the data
group context menu. The only way to edit the data group in the future is through the View
or edit link.