This view displays the following in a task view:
- Task information with baseline task information.
- The difference between Duration and the Default Baseline Duration.
- The difference between the Planned Work and the Default Baseline Planned Work.
NOTE The data displayed in the following view compares actual task values to the values associated with the Default Baseline tasks.
To apply this custom view to a task list:
- Navigate to a list of tasks.
- In the View drop-down menu, select New View.
- Remove all the columns in the view, except the first one.
- With the first column selected, click Switch to Text Mode.
- Copy the text below and paste it in the first column of the view:
column.0.descriptionkey=name
column.0.link.linkproperty.0.name=ID
column.0.link.linkproperty.0.valuefield=ID
column.0.link.linkproperty.0.valueformat=int
column.0.link.lookup=link.view
column.0.link.valuefield=objCode
column.0.link.valueformat=val
column.0.linkedname=direct
column.0.listsort=string(name)
column.0.namekey=name.abbr
column.0.querysort=name
column.0.shortview=false
column.0.stretch=100
column.0.valuefield=name
column.0.valueformat=HTML
column.0.width=150
column.0.displayname=Task Name
column.1.descriptionkey=duration
column.1.linkedname=direct
column.1.listsort=intAsInt(durationMinutes)
column.1.namekey=duration.abbr
column.1.querysort=durationMinutes
column.1.shortview=false
column.1.stretch=0
column.1.valuefield=durationFieldLong
column.1.valueformat=compound
column.1.viewalias=duration
column.1.width=100
column.1.displayname=Task Duration
column.2.descriptionkey=view.relatedcolumn
column.2.descriptionkeyargkey.0=defaultbaselinetask
column.2.descriptionkeyargkey.1=duration
column.2.linkedname=defaultBaselineTask
column.2.listsort=intAsInt(durationMinutes)
column.2.namekey=duration
column.2.namekeyargkey.0=defaultbaselinetask.abbr
column.2.namekeyargkey.1=duration.abbr
column.2.querysort=defaultBaselineTask:durationMinutes
column.2.shortview=false
column.2.stretch=0
column.2.valuefield=defaultBaselineTask:durationFieldLong
column.2.valueformat=compound
column.2.viewalias=defaultBaselineTask:duration
column.2.width=100
column.2.displayname=Dflt Baseline Tsk: Dur
column.2.durationunitfield=durationUnit.value
column.3.description=Duration Variance
column.3.linkedname=direct
column.3.listsort=intAsInt(durationMinutes)
column.3.name=Duration Variance
column.3.querysort=durationMinutes
column.3.shortview=false
column.3.stretch=0
column.3.valueexpression=CONCAT(SUB({duration},{defaultBaselineTask}.{duration})/480," Days")
column.3.valueformat=HTML
column.3.viewalias=duration
column.3.width=100
column.3.displayname=Duration Variance
column.4.descriptionkey=workrequired
column.4.linkedname=direct
column.4.listsort=doubleAsDouble(workRequired)
column.4.namekey=workrequired.abbr
column.4.querysort=workRequired
column.4.shortview=false
column.4.stretch=0
column.4.valuefield=workFieldLong
column.4.valueformat=compound
column.4.viewalias=workrequired
column.4.width=100
column.4.displayname=Wrk Req
column.5.descriptionkey=view.relatedcolumn
column.5.descriptionkeyargkey.0=defaultbaselinetask
column.5.descriptionkeyargkey.1=workrequired
column.5.linkedname=defaultBaselineTask
column.5.listsort=doubleAsDouble(workRequired)
column.5.namekey=view.relatedcolumn
column.5.namekeyargkey.0=defaultbaselinetask.abbr
column.5.namekeyargkey.1=workrequired.abbr
column.5.querysort=defaultBaselineTask:workRequired
column.5.shortview=false
column.5.stretch=0
column.5.valuefield=defaultBaselineTask:workFieldLong
column.5.valueformat=compound
column.5.viewalias=defaultBaselineTask:workrequired
column.5.width=100
column.5.displayname=Dflt Baseline Tsk: Wrk Req
column.6.descriptionkey=workrequired
column.6.linkedname=direct
column.6.listsort=doubleAsDouble(workRequired)
column.6.name=Effort Variance
column.6.querysort=workRequired
column.6.shortview=false
column.6.stretch=0
column.6.valueexpression=CONCAT(SUB({workRequired},{defaultBaselineTask}.{workRequired})/60," Hours")
column.6.valueformat=HTML
column.6.viewalias=workrequired
column.6.width=100
column.6.displayname=Effort Variance
- Click Save View.
Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.