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.
Apply three filters: two to exclude staff who have left the University and one to select staff only.
- Expand the Email filter and tick Select all.
- Then untick (Blank).
- Expand the Person Number filter and select Select all.**
- Then untick (Blank).
- Expand the Staff or Student filter and select Staff.
Note: **If you are analysing college data, you can skip steps 3 and 4 as college staff may not have a person number.
If you cannot find an individual in your filtered results, try re‑running your export or refreshing your dataset and include the blank Person Number. Occasionally, users with multiple affiliations only have a Person Number recorded against one of their affiliations, which means they may not appear unless the blank value is included.