You can organize column data into custom groups so that the data is easier to read and
analyze. Create custom data groups directly in a dashboard without having to open the data modeling
component.
About this task
Complete the following steps to create a group, see what columns are included in the group, edit
the name of the group, or remove a group.
Note: Custom data groups can be applied to measures and to relational databases only. If you are
using an OLAP package, the Custom data group option is not available.
Procedure
- Open a visualization that has a measure.
- Click any white space in the visualization.
A toolbar
appears.
- Click the Select tool
icon in the toolbar.
- Select the columns that you want to include in a custom group.
Tip: Alternatively, Ctrl+click one or more columns that you want to include in a custom
group.
- Ctrl+click one of the columns.
A menu appears.
- From the menu, click the Custom data group
icon.
- Type a name for your custom data group and click OK.
- To see what columns are included in a custom data group:
- Ctrl+click the custom data group column on a visualization and click the
Drill down
icon.
The separate individual columns that make up the custom
data group are displayed.
- To redisplay the custom data group as one column, Ctrl+click a column and click the
Back
icon.
- To edit the name of a custom data group:
- Ctrl+click the custom data group column on a visualization and click the
Custom data group
icon.
- Click Rename, type a name and click
OK.
- To remove a custom data group:
- Ctrl+click the custom data group column on the visualization and click the
Custom data group
icon.
- Click Ungroup.
The custom data group is
removed from the visualization.
Results
Your custom data groups appear in the data tray for the dashboard and in the data slots for the
visualizations that use the custom data groups. Custom data groups are not displayed in the
Selected sources panel.