GROUP INTERVAL

DESCRIPTION

EXAMPLES

Week of the

Month

Values are grouped by the week of the month.

1, 2, 3, 4, 5

Week-Year

Values are grouped by the date of the first day of the week (uses culture settings).

7/1/2018, 7/8/2018, 7/15/2018, ... 11/4/2018, 11/11/2018, 11/18/2018, ...

Month-Year

Values are grouped by the year and month.

January 2012, February 2012, ... December 2012, January 2013, ...

Quarter-Year

Values are grouped by the year and quarter.

Q3 2012, Q4 2012, Q1 2013, Q2 2013, ...

Day-Month-Year

Values are grouped by date.

3/4/2012, 3/5/2012, 3/6/2012, ...

Date-Hour

Values are grouped by date with the hour value.

3/4/2012 0:00 AM, 3/4/2012 1:00 AM, 3/4/2012 2:00 AM, ...

Date-HourMinute

Values are grouped by date with the hour and minute values.

3/4/2012 0:00 AM, 3/4/2012 0:01 AM, 3/4/2012 0:02 AM, ...

Date-Hour-

Minute-Second

Values are grouped by date with the hour, minute and second values.

3/4/2012 0:00:00 AM, 3/4/2012 0:00:01 AM, 3/4/2012 0:00:02 AM, ...

Exact Date

Each value is displayed "as is".

2009, Q2 2009, 6/15/2009 1:45:30 PM, ...