Skip to main content

Grouping

Dashboard allows you to group dimension values and display summaries for entire groups rather than individual values. You can arrange dimension values in groups of different sizes by specifying the appropriate group interval. For instance, date-time values can be grouped by year, month, quarter, etc.

Note

Note that custom grouping is not supported in OLAP mode.

To specify a group interval in the Designer, invoke the data item menu and select the desired group interval. Less common group intervals are organized in the More submenus.

DataShaping_GroupInterval_DateTime_Menu

Use the Dimension.DateTimeGroupInterval and Dimension.TextGroupInterval properties to specify the date-time or textual group interval in code.

The following code snippet shows how to create the date-time and string dimensions with the specified group intervals.

Dimension orderDateDimension = new Dimension("Order Date", DateTimeGroupInterval.MonthYear);
Dimension categoryDimension = new Dimension("CategoryName", TextGroupInterval.Alphabetical);

API Members

API Description
Dimension.DateTimeGroupInterval Gets or sets the group interval for date-time values.
Dimension.TextGroupInterval Gets or sets the group interval for string values.
Dimension.DateTimeGroupInterval Gets or sets the group interval for date-time values.
Dimension.TextGroupInterval Gets or sets the group interval for string values.