51黑料不打烊

文档WorkfrontWorkfront 指南

项目树状图查询

Last update: Fri Apr 25 2025 00:00:00 GMT+0000 (Coordinated Universal Time)
  • 主题：

创建对象：

  • 用户

您可以使用本文中的查询来创建类似于增强型分析中的数据可视化图表。

IMPORTANT
查询将产生与增强型分析中所示类似的结果，但它们可能不完全匹配。

先决条件

在开始之前，您必须

  1. 与Business Intelligence (BI)工具建立连接：

    1. 为厂苍辞飞蹿濒补办别创建搁别补诲别谤帐户或连接
    2. 建立与奥辞谤办蹿谤辞苍迟数据连接的连接

建立连接后，您可以使用本文中的查询来提取和可视化数据。

已弃用项目计划小时数

WITH task_daily_work as (
??? SELECT
??????? taskid,
??????? projectid,
??????? workrequired,
??????? percentcomplete,
??????? calendardate,
??????? (workrequired - (workrequired * percentcomplete)) as remainingMinutes
??? FROM tasks_daily_history
)

SELECT
??? p.name,
??? p.projectid,
??? sum(tdw.workrequired) as projectTotalWork,
??? sum(tdw.remainingMinutes) as projectRemainingWork,
??? tdw.calendardate
FROM projects_current p
??? JOIN task_daily_work tdw ON p.projectid = tdw.projectid
GROUP BY p.projectid, p.name, tdw.calendardate

已弃用项目计划小时数：燃尽

WITH task_daily_work as (
??? SELECT
??????? taskid,
??????? projectid,
??????? workrequired,
??????? percentcomplete,
??????? calendardate,
??????? (workrequired - (workrequired * percentcomplete)) as remainingMinutes
??? FROM tasks_daily_history
)

SELECT
??? p.name,
??? p.projectid,
??? sum(tdw.workrequired) as projectTotalWork,
??? sum(tdw.remainingMinutes) as projectRemainingWork,
??? tdw.calendardate
FROM projects_current p
??? JOIN task_daily_work tdw ON p.projectid = tdw.projectid
GROUP BY p.projectid, p.name, tdw.calendardate

已弃用项目计划持续时间

WITH task_daily_work as (
??? SELECT
??????? taskid,
??????? projectid,
??????? planneddurationminutes,
??????? percentcomplete,
??????? calendardate,
??????? (planneddurationminutes - (planneddurationminutes * percentcomplete)) as remainingDurationMinutes
??? FROM tasks_daily_history
)

SELECT
??? p.name,
??? p.projectid,
??? sum(tdw.planneddurationminutes) as projectTotalWork,
??? sum(tdw.remainingDurationMinutes) as projectRemainingWork,
??? tdw.calendardate
FROM projects_current p
??? JOIN task_daily_work tdw ON p.projectid = tdw.projectid
GROUP BY p.projectid, p.name, tdw.calendardate

项目计划持续时间已停用：燃尽

WITH task_daily_work as (
??? SELECT
??????? taskid,
??????? projectid,
??????? planneddurationminutes,
??????? percentcomplete,
??????? calendardate,
??????? (planneddurationminutes - (planneddurationminutes * percentcomplete)) as remainingDurationMinutes
??? FROM tasks_daily_history
)

SELECT
??? p.name,
??? p.projectid,
??? sum(tdw.planneddurationminutes) as projectTotalWork,
??? sum(tdw.remainingDurationMinutes) as projectRemainingWork,
??? tdw.calendardate
FROM projects_current p
??? JOIN task_daily_work tdw ON p.projectid = tdw.projectid
GROUP BY p.projectid, p.name, tdw.calendardate
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43