|
Default
|
Groups combine unique field values.
|
|
Date
|
This option is in effect for fields that store date-time values.
Field values are grouped by the date part, the time part is ignored.
|
|
DateDay
|
This option is in effect for fields that store date-time values.
Field values are grouped by the day part. The following groups are supported: 1, 2, 3, ... , 31.
|
|
DateDayOfWeek
|
This option is in effect for fields that store date-time values.
Field values are grouped by the days of the week. The actual names depend on the current culture. For instance: Sunday, Monday, Tuesday.
|
|
DateDayOfYear
|
This option is in effect 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 are supported:: 1, 2, 3,...,365 (366 in a leap year).
|
|
DateWeekOfMonth
|
This option is in effect for fields that store date-time values.
Field values are grouped by the number of the week in a month in which they occur. The following groups are supported: 1, 2, 3, 4, 5 and 6.
|
|
DateWeekOfYear
|
This option is in effect 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 are supported: 1, 2,...,52, 53.
|
|
DateMonth
|
This option is in effect for fields that store date-time values.
Field values are grouped by the month part. The following groups are supported: January, February, ..., December. The actual month names depend on the current culture.
|
|
DateQuarter
|
This option is in effect for fields that store date-time values.
Field values are grouped by the quarterly intervals of the year. The following groups are supported: 1, 2, 3 and 4. Each quarter includes three months.
|
|
DateYear
|
This option is in effect for fields that store date-time values.
Field values are grouped by the year part. For instance: 2017, 2018, 2019.
|
|
YearAge
|
This option is in effect for fields that store date-time values.
Field values are grouped by the number of full years that have elapsed until the current date. The GroupIntervalNumericRange property defines the length of groups.
|
|
MonthAge
|
This option is in effect for fields that store date-time values.
Field values are grouped by the number of full months that have elapsed until the current date. The GroupIntervalNumericRange property defines the length of groups.
|
|
WeekAge
|
This option is in effect for fields that store date-time values.
Field values are grouped by the number of full weeks that have elapsed until the current date. The GroupIntervalNumericRange property defines the length of groups.
|
|
DayAge
|
This option is in effect for fields that store date-time values.
Field values are grouped by the number of full days that have elapsed until the current date. The GroupIntervalNumericRange property defines the length of groups.
|
|
Alphabetical
|
Field values are grouped by the first character of these values.
|
|
Numeric
|
This option is in effect for fields that store numeric values.
Field values are grouped into intervals defined by the GroupIntervalNumericRange property.
|
|
Hour
|
This option is in effect for fields that store date-time values.
Field values are grouped by the hour part regardless of the date to which the current value belongs.
|
|
Minute
|
This option is in effect for fields that store date-time values.
Field values are grouped by the minute part regardless of the date to which the current value belongs.
|
|
Second
|
This option is in effect for fields that store date-time values.
Field values are grouped by the second part regardless of the date to which the current value belongs.
|
|
DateMonthYear
|
This option is in effect for fields that store date-time values.
Field values are grouped by months and years. For instance: January 2018, September 2018, January 2019.
|
|
DateQuarterYear
|
This option is in effect for fields that store date-time values.
Field values are grouped by the year and quarter. For instance: Q3 2018, Q4 2018, Q1 2019.
|
|
DateHour
|
This option is in effect for fields that store date-time values.
Field values are grouped by the date part with the hour value. For instance: 3/4/2018 0:00, 3/4/2018 1:00, 3/4/2018 2:00.
|
|
DateHourMinute
|
This option is in effect for fields that store date-time values.
Field values are grouped by the date part with the hour and minute values. For instance: 3/4/2018 0:00, 3/4/2018 0:01, 3/4/2018 0:02.
|
|
DateHourMinuteSecond
|
This option is in effect for fields that store date-time values.
Field values are grouped by the date part with the hour, minute and second values. For instance: 3/4/2018 0:00:00, 3/4/2018 0:00:01, 3/4/2018 0:00:02.
|