Group By

{{if this.groupByItems.length (concat this.groupByItems.length " group" (if (gt this.groupByItems.length 1) "s")) "No grouping"}}

{{#if this.canGroup}}

Group By Column

{{option.label}} {{option.type}}

Calculate

{{option.label}}

Of Column

{{option.label}} {{#if option.type}} {{option.type}} {{/if}}

{{#if this.groupByItems.length}}

Active Groupings

Group by {{item.groupBy.label}} → {{item.aggregateFn.label}} of {{item.aggregateBy.label}}

{{/if}} {{else}}

{{this.groupingMessage}}

{{#unless @selectedColumns.length}}

Select columns in the "Select Fields" section first

{{/unless}}

{{/if}} {{#if this.canGroup}}

Grouping Rules:

• You can only group by columns that are selected
• Aggregate functions calculate values for each group
• Use COUNT(*) to count records in each group

{{/if}}