Table of Contents
Creating a New Report
This tutorial will walk you through how to create a new report.
Updated
by Niki Budd
Creating a New Report
Video Tutorial:
Step-By-Step Tutorial:
- Select the Reporting tab
- Select Add
- Name your report
- Input a description the report, we suggest being explicit with what you detail in this section
- Select the Data Source you wish to pull from
- Select OK to add your report
- Next set up the reports configuration
- Default Sort: This is how you'd like your data sorted
- Sort Direction:
- Ascending: In alphabetical order
- Descending: In descending alphabetical order
- Group By: This will group rows that have similar values
- Example: Group by Organization will generate all your organizations as separate entities on the report.
- Aggregate By: This allows you the ability to take your grouping (or rows) and apply a column sort to it as wellย Note: aggregate by is used when you want to determine the value (Sum, average, minimum, maximum, or count)
- Aggregation Function: This allows you to set the reporting value
- Now review the current columns and their visibility. To move a column, drag it to the desired location
- To change the parameters around a column, select the three dots to the right of the field and select Edit
- Edit the parameters for the field accordingly, and select OK when complete
Note: All of these fields allow you to enable or disable different column actions on the end report.
Visit: 2.0 Reporting - Tips & Tricks for help adjusting fields
- You can run or save the report once you're happy with your edits. By selecting Run, you can view the changes you've made and come back to edit the report if desired. By selecting Save, you are saving the adjustments to the report so you can run it with the adjustments you've made when returning to the report
- If you choose to Run the report, next set the parameters for the report and select Run
- Once your report is generated, you can continue to export (downward pointed arrow) or go back to editing the report (pencil icon)
Note: if you wish to return to this report without having to recreate the settings, you will want to return to "edit" and then "save"
How did we do?