All Collections
Chart Templates
Strategic Portfolio Management
Project - Chart Templates
Project - Chart Templates
G
Written by Gary Ditsch
Updated over a week ago

1.

Title: No Program

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^primary_programISEMPTY

2.

Title: No Planned Cost

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^cost=javascript:global.getCurrencyFilter('pm_project','cost', 'USD;0')^ORcostISEMPTY

3.

Title: No Description

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^descriptionISEMPTY

4.

Title: No Business Case

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^business_caseISEMPTY

5.

Title: No Investment Class

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^investment_class=

6.

Title: No Planned Benefit

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^benefits=javascript:global.getCurrencyFilter('pm_project','benefits', 'USD;0')^ORbenefitsISEMPTY

7.

Title: No Portfolio

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^primary_portfolioISEMPTY

8.

Title: No Budget Cost

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^budget_cost=javascript:global.getCurrencyFilter('pm_project','budget_cost', 'USD;0')^ORbudget_costISEMPTY

9.

Title: No Investment Type

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^investment_type=

10.

Title: No ROI

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^roiISEMPTY

11.

Title: No Manager

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

project_managerISEMPTY^work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

12.

Title: Active Projects

Table: pm_project

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true

Projects by Priority Charts

13.

Title: Projects by Priority

Table: pm_project

Chart Type: Donut

Aggregate Type: Count

Group by: Priority

Conditions:

sys_class_name=pm_project

14.

Title: Projects by Priority

Table: pm_project

Chart Type: Horizontal Bar

Aggregate Type: Count

Group by: Priority

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

15.

Title: Projects by Priority

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Priority

Conditions:

Projects by State Charts

16.

Title: Projects by State

Table: pm_project

Chart Type: Donut

Aggregate Type: Count

Group by: State

Conditions:

sys_class_name=pm_project

17.

Title: Projects by State

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: State

Conditions:

Projects by Investment Type Charts

18.

Title: Projects by Investment Type

Table: pm_project

Chart Type: Donut

Aggregate Type: Count

Group by: Investment Type

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

19.

Title: Projects by Investment Type

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Investment Type

Conditions:

Projects by Business Unit

20.

Title: Projects by Business Unit

Table: pm_project

Chart Type: Donut

Aggregate Type: Count

Group by: Business Unit

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

21.

Title: Projects by Business Unit

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Business Unit

Conditions:

Projects by Investment Class Charts

22.

Title: Projects by Investment Class

Table: pm_project

Chart Type: Donut

Aggregate Type: Count

Group by: Investment Class

Conditions:

work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

23.

Title: Projects by Investment Class

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Investment Class

Conditions:

24.

Title: Projects by Risk

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Risk

Conditions:

25.

Title: Active Projects by Manager

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Project manager

Conditions:

stateIN-5,1,2^phase=initiating

26.

Title: Active Projects Planned Cost

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Sum

Aggregate field: Total planned cost

Conditions:

active=true

27.

Title: Active Projects Actual Costs

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Sum

Aggregate field: Total actual cost

Conditions:

active=true

28.

Title: Active Projects Planned Benefits

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Sum

Aggregate field: Planned benefit

Conditions:

active=true

29.

Title: Active Projects Actual Benefits

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Sum

Aggregate field: Actual benefit

Conditions:

active=true

30.

Title: Active Projects Estimate At Completion

Table: pm_project

Chart Type: Vertical Bar

Aggregate Type: Sum

Aggregate field: Estimate at completion

Conditions:

active=true
Did this answer your question?