Follow
View: Baseline Variance for Duration and Planned Work in a Task View

This view not only displays task information with baseline task information, it also shows the difference between duration and the default baseline duration, and 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. 

baseline_variance_in_a_task_view.png

To apply this custom view to a task list:

  1. Navigate to a list of tasks.
  2. In the View drop-down menu, select New View.
  3. Remove all the columns in the view, except the first one.
  4. With the first column selected, click Switch to Text Mode.
  5. 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



  6. Click Save View.