檢視:具有所有日期差異的任務

此任務檢視類似於您的Adobe Workfront帳戶隨附的「所有日期」檢視。 此特定檢視包括 變數 欄,計算下列日期之間的天數差異:

  • 計畫與預計開始日期
  • 計畫和實際開始日期
  • 計畫與預計完成日期
  • 計畫和實際完成日期

此檢視表代表計算資料行的範例,您可以在其中從兩個不同的資料行取得值,然後透過計算將它們連線起來,以取得第三個值。 在此情況下,您會從日期2減去日期1。

如需在檢視中使用計算的詳細資訊,請參閱 文字模式的常見用途概觀 中的區段  文字模式的常見用途概觀.

Screen_Shot_2017-04-24_at_11.35.33_AM.png

存取需求

您必須具有下列存取權才能執行本文中的步驟:

Adobe Workfront計畫*
任何
Adobe Workfront授權*

請求修改檢視

計畫修改報表

存取層級設定*

編輯報告、儀表板、行事曆的存取權以修改報告

編輯對篩選器、檢視、群組的存取權以修改檢視

附註

如果您還是沒有存取權,請詢問您的Workfront管理員,他們是否在您的存取層級中設定其他限制。 如需有關Workfront管理員如何修改您的存取層級的資訊,請參閱 建立或修改自訂存取層級.

物件許可權

管理報表的許可權

如需請求其他存取許可權的詳細資訊,請參閱 要求物件的存取權.

*若要瞭解您擁有的計畫、授權型別或存取權,請聯絡您的Workfront管理員。

檢視具有所有日期差異的任務

  1. 前往工作清單。

  2. 檢視 下拉式功能表,選取 新檢視.

  3. 在​ 欄預覽 區域,排除所有欄,一個除外。

  4. 按一下剩餘欄的標頭,然後按一下 切換到文字模式.

  5. 將滑鼠移到文字模式區域上,然後按一下 按一下以編輯文字.

  6. 移除您在「 」中找到的文字 文字模式 方塊,並以下列程式碼取代:

    column.1.descriptionkey=name
    column.1.link.linkproperty.0.name=ID
    column.1.link.linkproperty.0.valuefield=ID
    column.1.link.linkproperty.0.valueformat=int
    column.1.link.lookup=link.view
    column.1.link.valuefield=objCode
    column.1.link.valueformat=val
    column.1.linkedname=direct
    column.1.listsort=string(name)
    column.1.namekey=name.abbr
    column.1.querysort=name
    column.1.shortview=false
    column.1.stretch=95
    column.1.styledef.case.0.comparison.attribute=css
    column.1.styledef.case.0.comparison.isrowcase=true
    column.1.styledef.case.0.comparison.leftmethod=intAsInt(numberOfChildren)
    column.1.styledef.case.0.comparison.lefttext=numberOfChildren
    column.1.styledef.case.0.comparison.operator=gt
    column.1.styledef.case.0.comparison.operatortype=int
    column.1.styledef.case.0.comparison.righttext=0
    column.1.styledef.case.0.comparison.trueproperty.0.name=fontstyle
    column.1.styledef.case.0.comparison.trueproperty.0.value=bold
    column.1.styledef.case.0.comparison.truetext=
    column.1.styledef.case.0.comparison.usefield=false
    column.1.valuefield=name
    column.1.valueformat=HTML
    column.1.width=150
    column.2.descriptionkey=plannedstartdate
    column.2.linkedname=direct
    column.2.listsort=atDateAsAtDate(plannedStartDate)
    column.2.namekey=plannedstartdate.abbr
    column.2.querysort=plannedStartDate
    column.2.shortview=false
    column.2.stretch=0
    column.2.valuefield=plannedStartDate
    column.2.valueformat=atDate
    column.2.width=75
    column.3.descriptionkey=projectedstartdate
    column.3.linkedname=direct
    column.3.listsort=atDateAsAtDate(projectedStartDate)
    column.3.namekey=projectedstartdate.abbr
    column.3.querysort=projectedStartDate
    column.3.shortview=false
    column.3.stretch=0
    column.3.valuefield=projectedStartDate
    column.3.valueformat=atDate
    column.3.width=75
    column.4.descriptionkey=plannedstartdate
    column.4.displayname=Projected Start Variance
    column.4.linkedname=direct
    column.4.listsort=atDateAsAtDate(plannedStartDate)
    column.4.namekey=plannedstartdate.abbr
    column.4.querysort=plannedStartDate
    column.4.shortview=false
    column.4.stretch=0
    column.4.styledef.case.0.comparison.attribute=css
    column.4.styledef.case.0.comparison.isrowcase=false
    column.4.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedStartDate)
    column.4.styledef.case.0.comparison.lefttext=plannedStartDate
    column.4.styledef.case.0.comparison.operator=notnull
    column.4.styledef.case.0.comparison.operatortype=date
    column.4.styledef.case.0.comparison.righttext=
    column.4.styledef.case.0.comparison.trueproperty.0.name=bgcolor
    column.4.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
    column.4.styledef.case.0.comparison.truetext=
    column.4.styledef.case.0.comparison.usefield=false
    column.4.valueexpression=ROUND(DATEDIFF({projectedStartDate},{plannedStartDate}))
    column.4.valueformat=HTML
    column.4.width=75
    column.5.descriptionkey=plannedstartdate
    column.5.linkedname=direct
    column.5.listsort=atDateAsAtDate(plannedStartDate)
    column.5.namekey=plannedstartdate.abbr
    column.5.querysort=plannedStartDate
    column.5.shortview=false
    column.5.stretch=0
    column.5.valuefield=plannedStartDate
    column.5.valueformat=atDate
    column.5.width=75
    column.6.descriptionkey=actualstartdate
    column.6.linkedname=direct
    column.6.listsort=atDateAsAtDate(actualStartDate)
    column.6.namekey=actualstartdate.abbr
    column.6.querysort=actualStartDate
    column.6.shortview=false
    column.6.stretch=0
    column.6.valuefield=actualStartDate
    column.6.valueformat=atDate
    column.6.width=75
    column.7.descriptionkey=plannedstartdate
    column.7.displayname=Actual Start Variance
    column.7.linkedname=direct
    column.7.listsort=atDateAsAtDate(plannedStartDate)
    column.7.namekey=plannedstartdate.abbr
    column.7.querysort=plannedStartDate
    column.7.shortview=false
    column.7.stretch=0
    column.7.styledef.case.0.comparison.attribute=css
    column.7.styledef.case.0.comparison.isrowcase=false
    column.7.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedStartDate)
    column.7.styledef.case.0.comparison.lefttext=plannedStartDate
    column.7.styledef.case.0.comparison.operator=notnull
    column.7.styledef.case.0.comparison.operatortype=date
    column.7.styledef.case.0.comparison.righttext=
    column.7.styledef.case.0.comparison.trueproperty.0.name=bgcolor
    column.7.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
    column.7.styledef.case.0.comparison.truetext=
    column.7.styledef.case.0.comparison.usefield=false
    column.7.valueexpression=ROUND(DATEDIFF({actualStartDate},{plannedStartDate}))
    column.7.valueformat=HTML
    column.7.width=75
    column.8.descriptionkey=plannedcompletiondate
    column.8.linkedname=direct
    column.8.listsort=atDateAsAtDate(plannedCompletionDate)
    column.8.namekey=plannedcompletiondate.abbr
    column.8.querysort=plannedCompletionDate
    column.8.shortview=false
    column.8.stretch=0
    column.8.valuefield=plannedCompletionDate
    column.8.valueformat=atDate
    column.8.width=75
    column.9.descriptionkey=projectedcompletiondate
    column.9.linkedname=direct
    column.9.listsort=atDateAsAtDate(projectedCompletionDate)
    column.9.namekey=projectedcompletiondate.abbr
    column.9.querysort=projectedCompletionDate
    column.9.shortview=false
    column.9.stretch=0
    column.9.valuefield=projectedCompletionDate
    column.9.valueformat=atDate
    column.9.width=75
    column.10.descriptionkey=plannedcompletiondate
    column.10.displayname=Projected Completion Variance
    column.10.linkedname=direct
    column.10.listsort=atDateAsAtDate(plannedCompletionDate)
    column.10.namekey=plannedcompletiondate.abbr
    column.10.querysort=plannedCompletionDate
    column.10.shortview=false
    column.10.stretch=0
    column.10.styledef.case.0.comparison.attribute=css
    column.10.styledef.case.0.comparison.isrowcase=false
    column.10.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedCompletionDate)
    column.10.styledef.case.0.comparison.lefttext=plannedCompletionDate
    column.10.styledef.case.0.comparison.operator=notnull
    column.10.styledef.case.0.comparison.operatortype=date
    column.10.styledef.case.0.comparison.righttext=
    column.10.styledef.case.0.comparison.trueproperty.0.name=bgcolor
    column.10.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
    column.10.styledef.case.0.comparison.truetext=
    column.10.styledef.case.0.comparison.usefield=false
    column.10.valueexpression=ROUND(DATEDIFF({projectedCompletionDate},{plannedCompletionDate}))
    column.10.valueformat=HTML
    column.10.width=75
    column.11.descriptionkey=plannedcompletiondate
    column.11.linkedname=direct
    column.11.listsort=atDateAsAtDate(plannedCompletionDate)
    column.11.namekey=plannedcompletiondate.abbr
    column.11.querysort=plannedCompletionDate
    column.11.shortview=false
    column.11.stretch=0
    column.11.valuefield=plannedCompletionDate
    column.11.valueformat=atDate
    column.11.width=75
    column.12.descriptionkey=actualcompletiondate
    column.12.linkedname=direct
    column.12.listsort=atDateAsAtDate(actualCompletionDate)
    column.12.namekey=actualcompletiondate.abbr
    column.12.querysort=actualCompletionDate
    column.12.shortview=false
    column.12.stretch=0
    column.12.valuefield=actualCompletionDate
    column.12.valueformat=atDate
    column.12.width=75
    column.13.descriptionkey=plannedcompletiondate
    column.13.displayname=Actual Completion Variance
    column.13.linkedname=direct
    column.13.listsort=atDateAsAtDate(plannedCompletionDate)
    column.13.namekey=plannedcompletiondate.abbr
    column.13.querysort=plannedCompletionDate
    column.13.shortview=false
    column.13.stretch=0
    column.13.styledef.case.0.comparison.attribute=css
    column.13.styledef.case.0.comparison.isrowcase=false
    column.13.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedCompletionDate)
    column.13.styledef.case.0.comparison.lefttext=plannedCompletionDate
    column.13.styledef.case.0.comparison.operator=notnull
    column.13.styledef.case.0.comparison.operatortype=date
    column.13.styledef.case.0.comparison.righttext=
    column.13.styledef.case.0.comparison.trueproperty.0.name=bgcolor
    column.13.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
    column.13.styledef.case.0.comparison.truetext=
    column.13.styledef.case.0.comparison.usefield=false
    column.13.valueexpression=ROUND(DATEDIFF({actualCompletionDate},{plannedCompletionDate}))
    column.13.valueformat=HTML
    column.13.width=75
    row.0.styledef.applyallcases=true
    row.0.styledef.case.0.comparison.attribute=css
    row.0.styledef.case.0.comparison.isrowcase=true
    row.0.styledef.case.0.comparison.leftmethod=intAsInt(numberOfChildren)
    row.0.styledef.case.0.comparison.lefttext=numberOfChildren
    row.0.styledef.case.0.comparison.operator=gt
    row.0.styledef.case.0.comparison.operatortype=int
    row.0.styledef.case.0.comparison.righttext=0
    row.0.styledef.case.0.comparison.trueproperty.0.name=fontstyle
    row.0.styledef.case.0.comparison.trueproperty.0.value=bold
    row.0.styledef.case.0.comparison.truetext=
    row.0.styledef.case.0.comparison.usefield=false
    
  7. 按一下 儲存檢視.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43