View: baseline variance for Duration and Planned Work in a task View

Last update: November 4, 2024

CREATED FOR:

  • User

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.

baseline_variance_in_a_task_view.png

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

Adobe Workfront planAny
Adobe Workfront license*

New:

  • Contributor to modify a filter

  • Standard to modify a report

Current:

  • Request to modify a filter

  • Plan to modify a report

Access level configurations

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a filter

Object permissionsManage permissions to a report

*For information, see Access requirements in Workfront documentation.

View baseline variance for Duration and Planned Work in a task view

  1. Go to a list of tasks.

  2. In the View drop-down menu, select New View or edit an existing view.

  3. Remove all the columns in the view, except the first one.

  4. With the first column selected, click Switch to Text Mode, then click Edit Text View.

  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.

More help on this topic

Previous pageView: assigned user's Company and Home Group
Next pageView: calculate overtime cost in a Timesheet View

Workfront


Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action

Workfront

Tuesday, Mar 4, 6:00 PM UTC

Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.

Register

The Perfect Blend: A New Era of Collaboration with AEM and Workfront

Adobe Customer Success Webinars

Wednesday, Apr 2, 5:00 PM UTC

Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.

Register

A Proven Framework to Boost Campaign Creation Speed

Online | Session | General Audience

Disparate teams, messy workflows, and clunky approvals impede your content production speed and business impact. Stensul’s CEO, Noah...

Wed, Mar 19, 4:00 PM PDT (11:00 PM UTC)

Register

Adobe’s Top 10 Generative AI Capabilities to Accelerate Your Content Supply Chain

Online | Session | General Audience

AI is rapidly transforming marketing content and customer experiences, but many companies face significant questions: How do I safely and...

Tue, Mar 18, 2:00 PM PDT (9:00 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.

Register

Register now