DokumentationWorkfrontWorkfront-Handbuch

Projekt-Treemap-Abfragen

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

Erstellt für:

  • Benutzende

Sie können die Abfragen in diesem Artikel verwenden, um Datenvisualisierungen zu erstellen, die denen in Enhanced Analytics ähneln.

IMPORTANT
Abfragen führen zu ähnlichen Ergebnissen wie die in Enhanced Analytics gezeigten, aber sie stimmen möglicherweise nicht genau überein.

Voraussetzungen

Bevor Sie beginnen, müssen Sie

  1. Stellen Sie eine Verbindung mit Ihrem Business Intelligence-Tool (BI) her:

    1. Erstellen eines Leserkontos oder einer Verbindung für Snowflake
    2. Herstellen einer Verbindung mit Workfront Data Connect

Sobald Sie eine Verbindung hergestellt haben, können Sie die Abfragen in diesem Artikel verwenden, um Daten zu extrahieren und zu visualisieren.

Geplante Stunden für Projekte eingestellt

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

Geplante Stunden für Projekte im Ruhestand: Burndown

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

Geplante Projektdauer eingestellt

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

Geplante Projektdauer eingestellt: Burndown

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