Planned and Actuals, Status, Age, Duration, Completion

These charts show the number of projects by different indicators and broken down over different analysis axes.

This page discusses:

Planned and Actual Breakdown

These series of charts display the number of projects in each Planned and Actual state, broken down over different analysis axes, such as organization, owner, etc. These charts share the same configuration for display and interactions, but on a different facet.

Business Objects Project (data model class "project_space")
Values (or X-Axis and Y-Axis)
  • X-Axis: number of projects in each "Planned and Actual" state (stacked).
  • Y-Axis: facet categories (organization, owner, project, or program).
Sorting The results are alphanumerically sorted, by category name.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking .
Colors Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views Stacked bar chart, full screen view, and table view.
Interactions On this chart, you can:
  • Click the Y-Axis label to refine on corresponding category.
  • Click stack elements to refine on corresponding state.
  • Draw a rectangular area on the chart using drag-and-drop zooms on this area.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model

  • Class: project_space

    • Inherited from document

      • Property: owner
      • Property: related_project
      • Property: related_program

    • Inherited from project
      • Property: project_related_organization

  • Mashup feed (project)

    • Aggregations added on facet (depending on chart variant)

      • ontime: SUM(#extract(document_ram_datetime,'project_actual_finish_date') <= #extract(document_ram_datetime,'project_estimated_finish_date') ? 1 : 0)
      • due: SUM(#extract(document_ram_datetime,'project_estimated_finish_date') <= #addperiod(#now(),45,0,0,0) && project_percent_complete < 100 ? 1 : 0)
      • late: SUM(#now() > #extract(document_ram_datetime,'project_estimated_finish_date') && project_percent_complete < 100 ? 1 : 0)
      • missed: SUM(#extract(document_ram_datetime,'project_actual_finish_date') > #extract(document_ram_datetime,'project_estimated_finish_date') && project_percent_complete == 100 ? 1 : 0)
      • notstarted: SUM(actual_start_date_present > 0 ? 0 : 1)
      • notplanned: SUM((#extract(document_ram_datetime,"project_actual_finish_date")?=0)== 0 && actual_start_date_present == 0 && estimated_start_date_present == 0 ? 1 : 0)

"Planned and Actual" Definition

Color Title Description
Green On Time Project [Actual End Date] did not exceed [Estimated End Date]
Blue Due in >45 days Project [Estimated End Date] within next 45 days AND Not 100% Progress
Red Late/Past due Project [Actual End Date] exceeded the [Estimated End Date] AND Less than 100% Progress
Orange Missed Project [Actual End Date] exceeded the [Estimated End Date] AND 100% Progress
- Not started Project has No Actual Start Date, it denotes that the Task has not been started
- No planned Project has No [Estimated Start Date] or [Estimated End Date] or [Actual Start Date] or [Actual Start Date]

Variants

Title Bars Facet Aggregations
Planned and Actual by organization Organization project_related_organization (from project class) ontime, due, late, missed, notstarted, notplanned
Planned and Actual by owner Owner owner (from document class) ontime, due, late, missed, notstarted, notplanned
Planned and Actual by project Project related_project (from document class) ontime, due, late, missed, notstarted, notplanned
Planned and Actual by program Program related_program (from document class) ontime, due, late, missed, notstarted, notplanned

Status Breakdown

These series of charts display the number of projects in each status, broken down over different analysis axes, such as organization, owner, etc. These charts share the same configuration for display and interactions, but on a different facet.

Business Objects Project (data model class "project_space")
Values (or X-Axis and Y-Axis)
  • X-Axis: number of projects in each status.
  • Y-Axis: facet categories (organization, owner, project, or program).
Sorting The results are alphanumerically sorted, by category name.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking .
Colors Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views Stacked bar chart, full screen view and table view.
Interactions On this chart, you can:
  • Click the Y-Axis label to refine on corresponding category.
  • Click stack elements to refine on corresponding state.
  • Draw a rectangular area on the chart using drag-and-drop zooms on this area.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model

  • Class: project_space

    • Inherited from document

      • Property: owner
      • Property: related_project
      • Property: related_program

  • Mashup feed (project)
    • Multidimensional facet from search logic
      • status_by_proj: current and related_project
    • Multidimensional facets created on feed:
      • status_by_org: current and project_related_organization
      • status_by_own: current and owner
      • status_by_prog: current and related_program
    • Aggregations added on facet (depending on chart variant)
      • On status_by_proj and status_by_org
        • total_duration: SUM(project_percent_complete == 100 ? project_actual_duration : project_estimated_duration)

Variants

Title Bars Facet Aggregations
Status by organization Organization status_by_org total_duration
Status by owner Owner status_by_own count
Status by project Project status_by_proj total_duration
Status by program Program status_by_prog count

Age Breakdown

These series of charts display the age of projects (number of days since actual start), broken down over different analysis axes, such as organization, owner, etc. These charts share the same configuration for display and interactions, but on a different facet.

Business Objects Risk (data model class "project_space")
Values (or X-Axis and Y-Axis)
  • X-Axis: average project age.
  • Y-Axis: facet categories (organization, owner, project, or program).
Sorting The results are alphanumerically sorted, by category name.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking .
Colors Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views Bar chart, full screen view, and table view.
Interactions On this chart, you can:
  • Click the Y-Axis label to refine on corresponding category.
  • Draw a rectangular area on the chart using drag-and-drop zooms on this area.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model

  • Class: project_space

    • Inherited from document

      • Property: owner
      • Property: related_project
      • Property: related_program

    • Inherited from project
      • Property: project_related_organization

  • Mashup feed (open_project)
    • Aggregations added on facet (depending on chart variant)
      • age: AVG(num_opening_days * 1.0)

Variants

Title Bars Facet Aggregations
Age by organization Organization project_related_organization age
Age by owner Owner owner age
Age by assignee Assignee task_mgmt_assignee age
Age by project Project related_project age
Age by program Program related_program age

Duration Breakdown

These series of charts display the duration of projects (number of weeks between actual start and actual end), broken down over different analysis axes, such as organization, owner, etc. Those charts share the same configuration for display and interactions, but on a different facet.

Business Objects Project (data model class "project_space")
Values (or X-Axis and Y-Axis)
  • X-Axis: projects duration ranges.
  • Y-Axis: facet categories (organization, owner, project, or program).
Sorting The results are alphanumerically sorted, by category name.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking .
Colors Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views Bar chart, full screen view and table view.
Interactions On this chart, you can:
  • Click the Y-Axis label to refine on corresponding category.
  • Click stack elements to refine on corresponding duration.
  • Draw a rectangular area on the chart using drag-and-drop zooms on this area.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model

  • Class: project_space

    • Inherited from document

      • Property: owner
      • Property: related_project
      • Property: related_program

    • Inherited from project
      • Property: project_related_organization

  • Mashup feed (project)
    • Dynamic date facet created with feed trigger (DynamicDateRangeFacetTrigger)
      • closure_days_custom: #ndays(#extract(document_ram_datetime, 'project_actual_start_date'), #extract(document_ram_datetime, 'project_actual_finish_date'))
    • Multidimensional facets created on feed:
      • duration_by_org: closure_days_custom and project_related_organization
      • duration_by_own: closure_days_custom and owner
      • duration_by_assi: closure_days_custom and task_mgmt_assignee
      • duration_by_proj: closure_days_custom and related_project
      • duration_by_prog: closure_days_custom and related_program

Variants

Title Bars Facet Aggregations
Duration by organization Organization duration_by_org count
Duration by owner Owner duration_by_own count
Duration by project Project duration_by_proj count
Duration by program Program duration_by_prog count

Completion Breakdown

These series of charts display the completion percentage of projects, broken down over different analysis axes, such as organization, owner, etc. These charts share the same configuration for display and interactions, but on a different facet.

Business Objects Project (data model class "project_space")
Values (or X-Axis and Y-Axis)
  • X-Axis: project completion percentage.
  • Y-Axis: facet categories (organization, owner, project, or program).
Sorting The results are alphanumerically sorted, by category name.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking .
Colors Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views Bar chart, full screen view, and table view.
Interactions On this chart, you can:
  • Click the Y-Axis label to refine on corresponding category.
  • Click stack elements to refine on corresponding state.
  • Draw a rectangular area on the chart using drag-and-drop zooms on this area.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model

  • Class: project_space

    • Inherited from document

      • Property: owner
      • Property: related_project
      • Property: related_program

    • Inherited from project
      • Property: project_related_organization

  • Mashup feed (project)
    • Multidimensional facets created on feed:
      • completion_by_org: project_percent_complete and project_related_organization
      • completion_by_own: project_percent_complete and owner
      • completion_by_proj: project_percent_complete and related_project
      • completion_by_prog: project_percent_complete and related_program

Variants

Title Bars Facet Aggregations
Completion by organization Organization completion_by_org count
Completion by owner Owner completion_by_own count
Completion by project Project completion_by_proj count
Completion by program Program completion_by_prog count