Slide 2: Activity of Project Managers In-Platform

Active Projects without Status Report

Active Projects without Status Report in Last 30 Days

Active Status Project Missing Executive Summary

Active Project Statuses Missing Schedule Comments

Active Project Statuses Missing Cost Comments

Active Project Statuses Missing Scope Comments

Active Project Statuses Missing Resource Comments

Ven Diagram

(Horizontal Bars) Red/Yellow/Green Projects

(Horizontal Bars) Active Project Status Frequency


Active Projects without Status Report

  • Chart Query Information: This chart pulls all active projects that include at one project status report or more. This value will be reflected in aggregate value.

Active Projects without Status Report in Last 30 Days

  • Chart Query Information: This chart pulls in active projects that do not have a status report created on the last 30 days. This value is aggregated and reflected in the chart value.

Active Status Project Missing Executive Summary

  • Table: project_status

  • Chart Query Information: This chart pulls in status reports which do not include Executive Summary details and also have a parent project that is active. This value will be reflected in the aggregate.

Active Project Statuses Missing Schedule Comments

  • Table: project_status

  • Chart Query Information: This chart pulls in status reports which do not include schedule comments details and also have a parent project that is active. This value will be reflected in the aggregate.

Active Project Statuses Missing Cost Comments

  • Table: project_status

  • Chart Query Information: This chart pulls in status reports which do not include cost comments details and also have a parent project that is active. This value will be reflected in the aggregate.

Active Project Statuses Missing Scope Comments

  • Table: project_status

  • Chart Query Information: This chart pulls in status reports which do not include scope comments details and also have a parent project that is active. This value will be reflected in the aggregate.

Active Project Statuses Missing Resource Comments

  • Table: project_status

  • Chart Query Information: This chart pulls in status reports which do not include resource comments details and also have a parent project that is active. This value will be reflected in the aggregate.

Ven Diagram

(Horizontal Bars) Red/Yellow/Green Projects

  • Table: pm_project

  • Chart Query Information: This chart pulls status report records of all active projects and groups them by their status color. This is reflected in each bar of the Chart.

(Horizontal Bars) Active Project Status Frequency

  • Table: pm_project

  • Chart Query Information: All active status reports are taken and are put into rolling aggregates that reflect the volume of project statuses created in the default time buckets and are the reflected in the bars of the chart. Ex. bar one could be status reports created in the last x number of days and bar two would reflect the same except for a larger or smaller number of days and so on and so forth.

Did this answer your question?