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
