This article covers how to create filters in Advanced Reporting.
Step 1: To create a filter for any of the column fields, go to the column field and right-click to select Create Filter.
You can create a filter for any field column on your Ad Hoc.
Step 2: The filter will show on the right side of your screen.
Step 3: Next to each filter, you can select the dropdown to customize the filter. You will have the following options:
- Is one of
- Is not one of
- Is not equal to
- Does no contain
- Starts with
- Does not start with
- Ends with
- Does not end with
We recommend using is one of to pull more than one activity name or activity status, is equal to for when you want to pull a department name, and contains if you are looking for more than one activity that contains a keyword in the title or code.
Step 4: After you made changes to your filters, click on the Apply button.
Step 5: To save the Ad Hoc, click on the Save icon and select Save Ad Hoc View.
Step 6: Confirm that you are saving the report in your campus folder: CSU_PROD > Custom > Reports > Select your Campus.
Pay attention to which folder you are saving your report as it may default to a previous folder. You can click on any folder to change the location.
Step 7: You can add your Ad Hoc title and include information in the description for ease of referring back to why the report was created.
This concludes how to create filters in Advanced Reporting. Refer to Creating Report View for instructions on how to create a report.