In this example, TRUNCATE(SendDate,DAY) is the top-level grouping field and
Tags is the second-level grouping field. The query creates groups based on the cross-product of all grouping field values, and a metric is computed for each combination for which at least one object has a value. A perspective object is included in the metric computation for each group for which it has actual values. A
summary value is computed for each non-leaf group, and a
totalobjects value is computed for the top-level group. An example result in XML is shown below:
Each non-leaf group has an inner
groups element containing its corresponding lower-level
group elements and a
summary element that provides a group-level metric value. Leaf-level groups have a
metric element. This structure is recursive if there are more than two grouping levels.