...
Based on Hicom’s response have filtered out Grade is NULL from Application Count Dashboard. Current filter excludes ‘In Progress’, 'Application withdrawn before submission' and Grade IS NULL.
Added additional filters to Applications Dashboard, Round Type and Derived Round Type (need a better name). Derived Round Type uses a combination of Staff Group, Offer Round Name and Specialty Name. There is a taxonomy on a spreadsheet for review. Also moved the filter view to enable filters to be more readable. If both are useful will apply to other workbooks.
View file name Filter Taxonomy.xlsx After conversation with Alice, there is an issue with the Staff Group field where it is showing recruitment offices as well as Staff Groups. To be raised with Hicom.
Previous Actions -
Questions from Data Analytics Team
...