The following steps will show how to create a series of filters to refine the data as the Harassment in Higher Education course is only one of the courses included in the Compliance Report. These can be bookmarked for convenience when running reports in the future.
Filter the data down to the Harassment in Higher Education course
- Navigate to the right-hand side of the data, where there are pre-set filters for each field.
- Scroll towards the bottom of the list and select Training Providers.
- In the Training Provider filter, select Equality and Diversity Unit.
- Select the filter directly above the Training Provider called Training Course Name. This filter will now only include the Harassment in Higher Education course in the report. Tick to select it.
Apply two filters to exclude staff who have left the University
- Expand the Email filter and tick Select all.
- Then untick (Blank).
- Expand the Person Number filter and select Select all.**
- Then untick (Blank).
Note: **If you are analysing college data, you can ignore steps 3 and 4.
Create a bookmark to make these filters your default
- Find the Bookmarks icon (from the list of icons in the top right-hand corner of the page) and select the drop-down arrow next to it.
- Select Add a personal bookmark.
- Name the bookmark.
- Select Make it the default view (optional). If set, the filters will be applied by default every time the report is opened.
- Select Save.
