When running a query, only employees with the following review' statuses will appear:
In Progress.
Shared.
Closed.
Open.
To know the employees who haven't started their reviews, create a query on all employees:
Click Access Button
then click HR Admin.
Go to Queries then click on Create A New Query [+].
Select Employee Details.
First Name.
Last Name.
Click on Export to Excel and click Save.
Create another Query showing who has Open/Shared/Closed/In Progress performance reviews:
Click on Create A New Query [+] then select Performance.
From the right hand list, select the following:
Performance Name.
Employee Performance Status.
Click on Export to Excel & Save.
Then, copy all the results from the second review into Excel, and paste it onto the first review. Any employee who isn't shown in both columns are the ones who haven't opened it.
📌Note: You can export both queries to the same Excel file using Hotsheets feature.