Powerful Reporting Using Filters
Introduction
When generating compliance reports in PolicyHub, a number of filters are available to allow you to search against specific criteria and concentrate on the data you are most interested in:
Configuration Options
Depending on the type of filter, a number of different configuration options are available by clicking on the cog :
Field Type | Operator | Details |
Text | Equals | Type in text that the field must match exactly |
Equals (Select) | Choose one from the available list of items to search against | |
Equals (Multiple) | Choose multiple from the available list of items to search against | |
Doesn't Equal (Select) | Choose one for the available list that shouldn't be included in the search | |
Doesn't Equal (Multiple) | Choose multiple from the available list that shouldn't be included in the search | |
Like | Type in text that must be contained within the field (but doesn't need to match exactly) | |
Begins With | Type in text that must be at the start of the field | |
Ends With | Type in text that must be at the end of the field | |
Isn't Like | Type in text that mustn't be contained within the field | |
Date | Equals (Calendar) | Enter a date to search against |
Examples of Text field types include:
- Publication Status
- Publication
- Library Item
- Recipient
Examples of Date field types include:
- Date Sent
- Date Actioned
- Date Sent From / To
- Date Actioned From / To
You can use the green plus to add a new filter. The new filter will default to 'Equals' but you can use the cog icon to choose a different operator.
You can use the red cross to remove a filter.
Note: each report has a number of filters which are visible by default and will be visible each time you generate the report, even if you removed one of these filters last time you ran the report.
Examples
#1: Organizational compliance to a particular publication
- Navigate to Users
- Right-click on the top folder and select Reporting > View compliance overview report for this group > Across all dates
- Click on Filters
- Click on the green plus to add a new filter
- Selection Publication from the drop-down list
- Click on the cog to change the operator
- Choose Equals (Select) and click on OK
- Choose the relevant publication from the drop-down list
- Click on Update results
#2: Compliance to publications sent in a specific time period
- Navigate to Users
- Right-click on the top folder and select Reporting > View compliance overview report for this group > Across all dates
- Click on Filters
- For Date Sent From filter, choose the appropriate (e.g. first day of quarter)
- For Date Sent To, choose the appropriate date (e.g. last day of quarter)
- Click on Update results
#3: List of publications send directly to library (bypassing attestation)
- Navigate to Users
- Right-click on the top folder and select Reporting > View compliance overview report for this group > Across all dates
- Click on Filters
- For Compliance Only, select No from the drop-down list
- Use the green plus to add a new filter
- Select Status from the drop-down list
- Click on the cog to change the operator
- Choose Equals (Select) and click on OK
- Choose Direct Into Library from the drop-down list
- Click on Update results