Grouping in a WinForms Dashboard Designer
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, and other date-time intervals.
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.
Dimension orderDateDimension = new Dimension("Order Date", DateTimeGroupInterval.MonthYear);
Dimension categoryDimension = new Dimension("CategoryName", TextGroupInterval.Alphabetical);
API Members
- 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.
Limitation
Custom grouping is not supported in OLAP mode.