BI features a number of tools for aggregating data, and for adding totals and subtotals to reports.
Watch the following video, and continue reading below it for additional information on how to make use of this with your reports.
Totals can be applied to any column with a number of different calculations. In the following example, the total number of events is being displayed.
To add a total to the end of the table:
1. Click the drop down arrow on the Event ID field, move to Totals and select Count Distinct.
This will count every unique row (ID) in this column.
This adds a total to the end of the column.
Where the Event ID has already had a count aggregation applied; the Total 'type' will need to be changed to Sum.
Adding a Subtotal
With a total aggregation already applied to a column; add a subtotal to the Type of Event
1. Click the drop down arrow on Type of Event, scroll to Format and click on Edit.
2. Expand the 'Summary' Menu
3. Toggle on the Sub Total and close out of the menu.
This adds a sub total for each event type