DocumentazioneWorkfrontGuida di Workfront

Query mappa ad albero progetto

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

Creato per:

  • Utente

Puoi utilizzare le query in questo articolo per creare visualizzazioni di dati simili a quelle in Analisi avanzate.

IMPORTANT
Le query produrranno risultati simili a quelli mostrati in Analisi avanzate, ma potrebbero non corrispondere esattamente.

Prerequisiti

Prima di iniziare, è necessario

  1. Stabilire una connessione con lo strumento Business Intelligence (BI):

    1. Creare un account o una connessione di lettura per Snowflake
    2. Stabilire una connessione a Workfront Data Connect

Una volta stabilita una connessione, puoi utilizzare le query in questo articolo per estrarre e visualizzare i dati.

Ore pianificate dei progetti ritirate

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

Ore pianificate dei progetti ritirate: 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

Durata progetti pianificata ritirata

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

Durata progetti pianificata ritirata: 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