After creating and then generating a report in Planning, you can apply filters to the fields within any template that has been incorporated as Primary Data. These filters allow you to only see items that meet the criteria that you specify. Member Campuses have utilized filters to answer questions like these—and many more.
- How many strategic objectives for this review cycle still aren’t marked complete?
- Are there any units that haven’t yet reported on their use of results?
- Which units are using indirect assessment methods?
- How many goals has the Academic Success Center unit identified this year?
- Which units have included the words continuous improvement in their assessment plans?
To add filters to a report, first click on the blue arrow on the top left-hand side of the report preview screen. This will reveal your filtering options.
You will see all Primary Data templates listed in the filter bar along the left side of the screen. These are the templates to which filters can be applied. Related Data templates will not be included. From here you can select + Filter to choose a specific field to filter. Multiple filters may be applied to the same template.
Once you have selected the field to which you would like to apply a filter you will next select the type of filter you would like to apply. Below you will find a summary of the different filters that can be applied to the various field types within Planning templates. Only the fields that are included within the template and in the report definition can have filters successfully applied.
|Field Type||Filter Options|
|Campus Labs Data Source||Is Empty, Is Not Empty|
|Sources||Is Empty, Is Not Empty|
|Large Rich Text Box||Is Empty, Is Not Empty|
|Small Rich Text Box||Is Empty, Is Not Empty|
|Text Box Single Line||Is Empty, Is Not Empty, Contains|
|Confidence||Is Empty, Is Not Empty|
|Description||Is Empty, Is Not Empty, Contains|
|Number||Equals, Does Not Equal, Contains|
|Start Date||Is Empty, Is Not Empty, Greater Than, Less Than|
|End Date||Is Empty, Is Not Empty, Greater Than, Less Than|
|Providing Org Unit||Is Empty, Is Not Empty, Equals, Does Not Equal, Contains|
|Progress||Is Empty, Is Not Empty, Items Contain Any|
|Choice||Is Empty, Is Not Empty, Equals, Does Not Equal, Items Contains Any|
|Responsible User||Is Empty, Is Not Empty|
|Currency||Is Empty, Is Not Empty|
|True/False||Is Empty, Is Not Empty, Equals, Does Not Equal|
|Percent Complete||Is Empty, Is Not Empty, Equals, Does Not Equal, Greater Than, Less Than|
|Recipient Role||Is Empty, Is Not Empty, Search|
|Role||Is Empty, Is Not Empty|
|Date||Is Empty, Is Not Empty|
For example, if you wanted to see any Operational Objective items that are not marked as Complete, you would add a filter to the Progress field. Then you would select the Items Contains Any option. From there you can select the all the Progress indicators except Complete. Once you have the filter established, you will need to select Apply Filter. This will show you any Objectives that have a progress indicator other than Complete.
Saving a Filter
After you apply a filter or set of filters to a report you created, you have the option to save that filter set. This will allow you to quickly access and apply those specific filters in the future. To save a filter set, select Save As New Filter Set. From there you will be asked to supply that filter set with a name. Be as specific as possible so you can easily identify this filter set in the future. Avoid generic names like “Test.”
Please note: Only the creator of the report can save filter sets, but all user with access to generate the report can apply filters or apply existing saved filter sets.
Default Report Filter
If you would like a saved filter set to be automatically applied when a report is generated, you can click on the report name to apply a default filter. Once you are within the report configuration screen simply select your preferred default filter from among the saved filters created for that report.