Slide 2: Activity of Project Managers In-Platform
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.