blazor-devexpress-dot-blazor-dot-pivottable-bd3e2767.md
Lists values that specify how the values of a column or row field are combined into groups.
Namespace : DevExpress.Blazor.PivotTable
Assembly : DevExpress.Blazor.PivotTable.v25.2.dll
NuGet Package : DevExpress.Blazor.PivotTable
public enum PivotTableGroupInterval
| Name | Description |
|---|---|
Default |
Groups combine unique field values.
|
| Date |
This option is in effect only for fields that store date/time values. Field values are grouped by date, but the time is ignored.
|
| DateDay |
This option is in effect only for fields that store date/time values. Field values are grouped by day. The following groups can be created: 1, 2, 3,…,31.
|
| DateDayOfWeek |
This option is in effect only for fields that store date/time values. Field values are grouped by day, for example, Sunday, Monday, and Tuesday (the names of the days of the week are determined by the culture).
|
| DateDayOfYear |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of the day on which they occur in a year. The following groups can be created: 1, 2, 3,…,365 (,366 in a leap year).
|
| DateWeekOfMonth |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of the week in which they occur in a month. The following groups can be created: 1, 2, 3, 4 and 5. The first week is the week containing the 1st day of the month.
|
| DateWeekOfYear |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of the day in which they occur in a year. The following groups can be created: 1, 2, 3,…,365 (,366 in a leap year).
|
| DateMonth |
This option is in effect only for fields that store date/time values. Field values are grouped by month, for example, January, February, March (the names of the months are determined by the culture).
|
| DateQuarter |
This option is in effect only for fields that store date/time values. Field values are sorted by the quarterly intervals of the year. The following groups can be created: 1, 2, 3 and 4. Each quarter includes three months.
|
| DateYear |
This option is in effect only for fields that store date/time values. Field values are grouped by the year part. Examples of such groups: 2023, 2024, 2025.
|
| YearAge |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of full years that have elapsed till the current date.
|
| MonthAge |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of full months that have elapsed till the current date.
|
| WeekAge |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of full weeks that have elapsed till the current date.
|
| DayAge |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of full days that have elapsed before the current date.
|
| Alphabetical |
Combines field values into categories according to the character that the values start with.
|
| Numeric |
This option is in effect only for fields that store numeric values.
|
| Hour |
This option is in effect only for fields that store date/time values. Field values are grouped by hour, regardless of the current date/time.
|
| Minute |
This option is in effect only for fields that store date/time values.
Field values are grouped by minute, regardless of the current date/time.
|
| Second |
This option is in effect only for fields that store date/time values. Field values are grouped by second, regardless of the current date/time.
|
| DateMonthYear |
This option is in effect only for fields that store date/time values. Field values are grouped by months and years. Examples of groups: August 2013, September 2014, January 2015, …
|
| DateQuarterYear |
This option is in effect only for fields that store date/time values. Field values are grouped by the year and quarter. Examples of groups: Q3 2012, Q4 2012, Q1 2013, Q2 2013, …
|
| DateHour |
This option is in effect only for fields that store date/time values. Field values are grouped by date, including the hour. Examples of such groups: 3/4/2012 0:00, 3/4/2012 1:00, 3/4/2012 2:00, …
|
| DateHourMinute |
This option is in effect only for fields that store date/time values. Field values are grouped by the date part with the hour and minute values. Examples of groups: 3/4/2012 0:00, 3/4/2012 0:01, 3/4/2012 0:02, …
|
| DateHourMinuteSecond |
This option is in effect only for fields that store date/time values. Field values are grouped by date and include hour, minute, and second values, for example, 3/4/2012 0:00:00, 3/4/2012 0:00:01, 3/4/2012 0:00:02, …
|
| DateWeekYear |
This option is in effect only for fields that store date/time values. Field values are grouped by the number of the week in a year in which they occur. The following groups can be created: 1, 2, 3,…,52, 53.
|
The following properties accept/return PivotTableGroupInterval values:
Use the Pivot Table field’s GroupInterval property to specify how the values of a column or row fields should be combined into groups. Refer to the property description for additional information and examples.
See Also