This documentation outlines the basic features of the New Reports.
Administrators can view all reports, but users with other roles will only be able to view the reports and data that they have permissions to access. For example, a speaker can access the evaluation details report but only the sessions they are associated to.
In a report with a data table, the data is grouped with a hierarchy that goes from the left to the right. Columns can be sorted alphabetically according to the group they are in to the left. For instance in the below screenshot, the merge field names associated to “Custom Profile Field” merge field type can be sorted alphabetically but will stay grouped by the merge field type.
Undo/Redo, Revert, Refresh, and Pause
- Undo/Redo any changes you have made to the filtering
- Revert to the original view. For example, click this button if you made some changes to the report and want to revert to the original
- Refresh loads the most current data in the report view
- Pause prevents the data from refreshing while the report is open
Filter a report
Filtering can either be done by choosing the dropdown filtering found on the right or by clicking on a field and choosing to either “Keep Only” or “Exclude”. Whatever the contents of that field are the report will be filtered to in that column.
Save how a report is filtered as a custom view
Any user can change how a report is filtered and save the modified report as a custom view. This view can only be accessed by the user that created the view, and it appears in the My Reports section (Main Menu > Reports > New Reports > My Reports).
- Change how a report is filtered. For example, filter the Session Attendance Counts report to only include specific sessions.
- Click View: Original.
- Enter a name for your custom view.
- Check Make it my default if this view should be your default view of this report.
- Click Save.
Download a Report
Click Download to download a report. If the report has been filtered, the data that is downloaded will also be filtered. If there is more than one visual for the report, whatever visual is clicked on will be what is downloaded.
- Crosstab - The most useful and commonly downloaded. It is a .csv file that can be saved as an Excel file so that you can manipulate the data
- Tableau Workbook - Not useful because the data is not accessible outside of the Hubb site
Adding Hidden Fields
If there a plus next to a column header, clicking on it will add hidden fields. Only 16 fields can be shown at once so if a field is “unhidden”, it may cause the first couple of fields to merge together. The field can be re-hidden by clicking the minus button next to.
If the edit functionality has been enabled on the event, an edit button appears in the top right corner of the report. Click edit to add or remove fields, add filters, or change widths of columns or rows. The edited report is only accessible to the user that created it in the My Reports section (Main Menu > Reports > New Reports > My Reports)
Fields that can be added to a report are found on the left. To add a field, click and drag it to the “Rows”. Only 16 fields can be added as rows. If there are more than 16 fields added, they will begin to be combined automatically. For example, in the screenshot below, the session title and the session type will show as one field. To remove a field, click on it and press delete.
To add a field to filter by, right click and choose “Show Filter”. It will be added on the right. It will be defaulted to a multiselect checkbox. To change the filter type, click the arrow in the top right of the filter.
Some reports represent a dashboard rather than a worksheet, for example, the Attendance Summary report. Fields cannot be added to a dashboard; they must be added to a worksheet. The different worksheets and dashboards can be selected at the bottom of the report. The dashboard will have squares to left of the name.