Grouping

• Dec 22, 2020

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.

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.

C#

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

VB.NET

Dim orderDateDimension As New Dimension("Order Date", DateTimeGroupInterval.MonthYear)
Dim categoryDimension As 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.