If your report is using the Table template, the Aggregation tab is disabled by default until the following requirements are met on the report’s Data > Fields tab:
At least one of the columns is assigned to a group.
At least one of the columns must be set with a function.
The following scenario describes the process to enable the Aggregation tab.
Define the query. For example, you want to look at event names by priority. In the query’s Fields tab, select the columns you need (Name and Priority in this case). After selecting the columns, add these same columns to the GROUP BY list. In the Conditions tab, define the conditions for the query (for example, you are interested in Priority greater than 3).
Create a report. On the Template tab, use one of the table templates (for example, Simple Table Portrait). In the Data tab, specify the query defined in the beginning of this procedure as your data source. The Fields tab is automatically populated by the columns from the query, in this case, Name and Priority.
On the Fields tab, create a group for one of the columns (for example, for Priority), then select a function for another column (for example, for Name) from the drop-down list. Columns with functions can be filtered through the Aggregation tab. For instructions on how to add columns to groups and how to apply functions to columns, see Query Fields.The Aggregation tab is enabled after you click Apply.