Search and Filter the Assignments Gantt
Objective
To search and filter Assignments Gantt and see a multi-day view of workforce requests and workforce assignments.
Background
Assignments Gantt allows you to view workforce requests and workforce assignments across all projects and people within your company. Assignments Gantt provides a multi-day view from one (1) day up to three (3) years. You can search and filter the Assignments Gantt to find the information you need such as all active projects, time off, percent allocation of workforce and all open requests. See How do I view workforce allocation percentage?
Things to Consider
- Required User Permissions:
- 'Read Only' level permissions or higher on the Workforce Planning tool and 'Admin' level permissions within the Workforce Planning tool. See Create Permissions Templates for Workforce Planning.
OR
'Read Only' level permissions or higher on the Workforce Planning tool with 'Access to Gantt Page' granular permissions within the Workforce Planning tool. See Create Permissions Templates for Workforce Planning.
- 'Read Only' level permissions or higher on the Workforce Planning tool and 'Admin' level permissions within the Workforce Planning tool. See Create Permissions Templates for Workforce Planning.
- Additional Information:
- To filter on a custom field, the Enable Use as Filter tickbox must be marked in the custom field's configuration. See Configure Custom Fields for Workforce Planning.
- When filtering Tags, you can apply AND logic or OR logic.
Prerequisites
Steps
You can select any one of the options below to locate workforce assignments.
Note: These steps can be completed in any order.
Search for People
Complete the steps below to search for people.
- Navigate to the Company level Workforce Planning tool.
- Click Assignments and select Assignments Gantt.
- Select People.
- Enter a person's first name, last name or employee ID in the Search People box. Then click the magnifying glass icon or press the ENTER/RETURN key on your keyboard to initiate your search.
Search for Projects
Complete the steps below to search for a project.
- Navigate to the Company level Workforce Planning tool.
- Click Assignments and select Assignments Gantt.
- Select Projects.
- Enter a project name or project number in the Search Requests box. Then click the magnifying glass icon or press the enter/return key on your keyboard to initiate your search.
Filter People
Complete the steps below filter the items in the Assignments Gantt.
- Navigate to the Company level Workforce Planning tool.
- Click Assignments and select Assignments Gantt.
- Select People.
- Click the filter icon.
- Click Matches to filter by terms that match your filters or click Doesn't Match to show time off that does NOT match the filter.
- Select to filter by:
- Gender. Select this to filter by gender, then select the gender.
- Hide Empty People. Select this to hide people without workforce assignments, then select True.
- Job Titles. Select this to see a list of job titles, then select the Job Title.
- Only Show. Select this to only show certain kinds of entries, then select Assignments or Time Off.
- Projects. Select this to filter by a specific project, then select the project.
- Tags. Tags that have been configured for people. See Configure Tags for Workforce Planning.
Tip
To apply AND logic to your tag filters, mark all the tickboxes for your filter selection.- For example, if wanting to see people with both Tag A and Tag B:
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickboxes for Tag A and Tag B.
- Click the tick to apply the filter(s).
- For example, if wanting to see Users OR Assignable Users:
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickbox for Tag A.
- Click the tick in the modal.
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickbox or Tag B.
- Click the tick in the modal.
- Click the tick to apply the filter(s).
- For example, if wanting to see people with both Tag A and Tag B:
- [Custom Fields]. Custom fields that have been configured for assignments and are filterable, will display at the end of this list. Select the custom field, then select the option by which you want to filter.
Note: To filter on a custom field, the Enable Use as Filter tickbox must be marked in the custom field's configuration. See Configure Custom Fields for Workforce Planning.
- Click the tick to apply the filter(s).
- If you want to clear filters that you have applied, click the 'x' next to the filter, then click tick to clear the filter(s).
- If you want to clear additional filters and revert back to default filters, click the rubbish can icon.
Examples
To see Time Off over time, select the following filters:
- Select 'Only Show' and click Time Off.
- Select 'Hide Empty People' and click True.
To hide people without assignments use the following filter:
- Select 'Hide Empty People' then click True.
Filter Projects
Complete the steps below filter the items in the Assignments Gantt.
- Navigate to the Company level Workforce Planning tool.
- Click Assignments and select Assignments Gantt.
- Select Projects.
- Click the filter icon.
- Click Matches to filter by terms that match your filters or click Doesn't Match to show time off that does NOT match the filter.
- Select to filter by:
- Tender Rate. Select this to filter by the project's estimated average rate that are Less Than, Less Than or Equal To, Equal To, Greater Than or Equal To or Greater than a specific value, then enter the value of the estimated average rate.
- Est. End Date. Select this to filter by projects that end On or Before, On or On or After a designated date, then select the date.
- Hide Empty Projects. Select this to hide projects with no workforce assignments or workforce requests, then select True.
- Job Titles. Select this to see a list of job titles, then select the Job Title.
- Only Show. Select this to only show certain kinds of entries, then select Assignments or Requests.
- Percent Complete. Select this to filter by projects where the percent complete is Less Than, Less Than or Equal To, Equal To, Greater Than or Equal To or Greater than a specific percent, then enter the percent.
- Start Date. Select this to filter by projects that start On or Before, On or On or After a designated date, then select the date.
- Status. Select this to filter by status, then select Active, Pending or Inactive.
- Tags. Tags that have been configured for people. See Configure Tags for Workforce Planning.
Tip
To apply AND logic to your tag filters, mark all the tickboxes for your filter selection.- For example, if wanting to see people with both Tag A and Tag B:
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickboxes for Tag A and Tag B.
- Click the tick to apply the filter(s).
- For example, if wanting to see Users OR Assignable Users:
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickbox for Tag A.
- Click the tick in the modal.
- Click the filter icon.
- Click Matches.
- Select to filter by Tag.
- Mark the tickbox or Tag B.
- Click the tick in the modal.
- Click the tick to apply the filter(s).
- For example, if wanting to see people with both Tag A and Tag B:
- [Custom Fields]. Custom fields that have been configured for assignments and are filterable, will display at the end of this list. Select the custom field, then select the option by which you want to filter.
Note: To filter on a custom field, the Enable Use as Filter tickbox must be marked in the custom field's configuration. See Configure Custom Fields for Workforce Planning.
- Click the tick to apply the filter(s).
- If you want to clear filters that you have applied, click the 'x' next to the filter, then click tick to clear the filter(s).
- If you want to clear additional filters and revert back to default filters, click the rubbish can icon.
Examples
To see all Open Requests, select the following filters:
- Select 'Hide Empty Projects' and click True.
- Select 'Only Show' and click Requests.
To hide projects without assignments, select the following filters:
- Select 'Hide Empty Projects' and click True.