Aggregate Reports allow you to pull reports in a Pivot Table format. Within the Report you can chose to Pivot by a few basic filters or by form responses. You can then select the Dimensions of the Report as well as the Columns you wish to show the Counts for.
- How to Create a New Aggregate Report
- Adding Data to the Aggregate Report
- How to Filter your Report
- Extra Options
- Click Analyze Results
- Click Report Builder
- Under the Reports title, click the Basic: CSV dropdown.
- Click Aggregate and select the XLS report format.
- Give your report a name and a description.
- Select the datasource from the Source dropdown.
NOTE: The only datasource available for this type of report is Submissions - Click Save.
Editing Your Reports Name and Description
To edit the report name and description:
- Under Basic Information, enter in a name for your report.
- Next to the description, enter in some text to help you distinguish between reports.
In an aggregate report, there are three data points used to configure your report:
- Begin by clicking the Pivot By drop down
NOTE: you are not required to Pivot, you may leave this as the default No Pivot (aggregates only) - Within the dropdown select an option from the Left List
- Once an option from the Left list is selected more options will appear within the right list.
- Select the applicable Pivot you wish to add to your report.
- Click Done
- Under Pivot By, you can select a Dimension from the drop down.
- Within the dropdown select an option from the Left List
- Once an option from the Left list is selected more options will appear within the right list.
- Select the applicable Dimension you wish to add to your report.
- Click Done
- Under Dimension, you can select Columns you wish to add to your report as well as the counts you wish to show
- Within the dropdown select an option from the Left List
NOTE: This will include a list of Basic Fields, as well as forms applicable to the Submission Source. - Once an option from the Left list is selected more options will appear within the right list.
- Select all applicable columns you wish to add to your report.
Previewing your data
- Once you have selected all of your Data, you will see a Preview
- Ensure your data points are correct and amend if necessary
Filters refine your report by only displaying results that match the criteria you've entered. They can be useful for only viewing information for specific submissions. For example, you can filter out submissions that have a status of Archived, Deleted, or Withdrawn. In addition, you can filter form responses to fully customize your data.
- Click the Please Select dropdown
- Choose an option on the Left list
- Once an option from the Left list is selected more options will appear within the right list.
- For each Filter you select there will be additional drop downs to complete.
- Optional: Click Add Rule to add another condition to your criteria
Prepare your report by adding these Extra options.
Option | Description |
Show header |
Export report with a header containing report title and description. |
Horizontal totals |
Computes and shows row totals. |
Vertical totals and averages |
Computes and shows column totals, or averages when applicable. |