Filter Wizard - Slip page
You use the Filter Wizard to create and edit the criteria of filters, which items must meet in order to be included in a filter. This page of the Filter Wizard appears if you have chosen to filter for tasks that are ahead of, or behind schedule - ie tasks that have slip. You use this page to specify the amount of slip - either positive or negative - that you want to filter for.
For tasks, slip is the difference between the report date of a specified progress period and the start or resume date of a task. A positive value indicates that work is ahead of schedule; a negative value indicates that work is behind schedule. For summary and expanded tasks, slip is calculated as being the difference between the report date and the task's effective progress date. The effective progress date for a summary or expanded task is calculated from the task's percentage complete and duration. The percentage complete for a summary or expanded task is calculated as the total actual duration of the child tasks, divided by the total duration of the child tasks.
How to access the Filter Wizard
To access the Filter Wizard, click Insert or Edit within the Filter Properties dialog.
Explanation of the fields on the dialog
| Field | Description |
|---|---|
| Behind schedule | Click this radio button to filter for tasks that are behind schedule - ie those with negative slip. |
| Ahead of schedule | Click this radio button to filter for tasks that are ahead of schedule - ie those with positive slip. |
| By |
Specify whether you want to filter for tasks with amounts of slip that are greater than, less than, or equal to the specified amount, and enter the amount of slip in which you are interested, for example 10d or 1w.
Even if you are filtering for tasks that are behind schedule - ie those with negative slip - you must enter a positive value. For example, to filter for tasks that are 2w or more behind schedule, click the Behind schedule radio button and select More than and 2w in these fields; to filter for tasks that are 2w or more ahead of schedule, click the Ahead of schedule radio button and select More than and 2w in these fields. |
| Slip to be calculated against which progress period? | Select the progress period against which you want slip to be calculated. |
| Ask me about the slip filter settings each time the filter is applied | Select this check box if you want to be able to specify the slip parameters each time you apply the filter, or clear the check box to use the parameters specified in this wizard each time. |
How do I...
... specify the slip parameters on which to filter?
- Click the appropriate radio button to specify whether you want to filter for tasks that are Behind schedule or Ahead of schedule.
- Specify the amount of slip for which to filter in the by fields. For example, you could filter for tasks that have exactly 2w of slip, more than 4d of slip, or less than 1w of slip.
Even if you are filtering for tasks that are behind schedule - ie those with negative slip - you must enter a positive value. For example, to filter for tasks that are 2w or more behind schedule, click the Behind schedule radio button and select More than and 2w in these fields; to filter for tasks that are 2w or more ahead of schedule, click the Ahead of schedule radio button and select More than and 2w in these fields. - Select the progress period against which you want slip to be calculated in the Slip to be calculated against which progress period field.
- If you want to be able to specify the slip parameters each time you apply the filter, select the Ask me about the slip filter settings... check box.
- Click Next to access the following page.