|
Year
|
Values are grouped by the year.
Example: 2010, 2011, 2012
|
|
Quarter
|
Values are grouped by the quarter.
Example: Q1, Q2, Q3, Q4
|
|
Month
|
Values are grouped by the month.
Example: January, February, March, … December
|
|
Day
|
Values are grouped by the day of the month.
Example: 1, 2, 3, … 31
|
|
Hour
|
Values are grouped by the hour.
Example: 0, 1, 2, … 23
|
|
Minute
|
Values are grouped by the minute.
Example: 0, 1, 2, … 59
|
|
Second
|
Values are grouped by the second.
Example: 0, 1, 2, … 59
|
|
DayOfYear
|
Values are grouped by the day of the year.
Example: 1, 2, 3, … 365 (366 in a leap year)
|
|
DayOfWeek
|
Values are grouped by the day of the week.
Example: Sunday, Monday, Tuesday, … Saturday
|
|
WeekOfYear
|
Values are grouped by the week of the year.
Example: 1, 2, 3, … 52
|
|
WeekOfMonth
|
Values are grouped by the week of the month.
Example: 1, 2, 3, 4, 5
|
|
QuarterYear
|
Values are grouped by the year and quarter.
Example: Q3 2012, Q4 2012, Q1 2013, Q2 2013, …
|
|
MonthYear
|
Values are grouped by the year and month.
Example: January 2012, February 2012, … December 2012, January 2013, …
|
|
WeekYear
|
Values are grouped by the date of the first day of the week (uses culture settings)
Example: 7/1/2018, 7/8/2018, 7/15/2018
|
|
DayMonthYear
|
Values are grouped by the date part.
Example: 3/4/2012, 3/5/2012, 3/6/2012, …
|
|
DateHour
|
Values are grouped by the date part with the hour value.
Example: 3/4/2012 0:00, 3/4/2012 1:00, 3/4/2012 2:00, …
|
|
DateHourMinute
|
Values are grouped by the date part with the hour and minute values.
Example: 3/4/2012 0:00, 3/4/2012 0:01, 3/4/2012 0:02, …
|
|
DateHourMinuteSecond
|
Values are grouped by the date part with the hour, minute and second values.
Example: 3/4/2012 0:00:00, 3/4/2012 0:00:01, 3/4/2012 0:00:02, …
|
|
None
|
Each value is displayed “as is”.
|