Dokumentation Workfront Workfront-Handbuch

Projekt-Treemap-Abfragen

Letzte Aktualisierung: 25. April 2025

Themen:

Erstellt für:

Benutzende

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

WICHTIG

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

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