How to group date-and-time data

1	Select the column that contains the date-and-time values by which to group.

2	Choose Add Group.

3	On Group Details, select one of the group options. If you opt to group by interval:

Select an interval type, such as weeks, months, or quarters, from the drop-down list.

Type a number by which to group the selected interval type. For example, if you selected Weeks, type 2 to group data in two-week periods.

Figure 4-10 shows grouping the SHIPPEDDATE column by month.

Figure 4-10

Grouping dates by month

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2