How to group date-and-time data

1	Select the column that contains the date-and-time data. From the context menu, choose Group→Add Group.

2	On Group Detail, 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 to indicate the grouping for the selected interval type. For example, if you selected Weeks, type 2 to group data in two-week periods.

Figure 5-11 shows grouping the Shipped Date column by month.

Figure 5-11

Grouping by shipping date

Copyright Actuate Corporation 2012