Time Spent Vs Completion Table

This chart displays the time spent versus the completion percentage for Project table.

Business Objects

Allocated Resource (data model class "allocated_resource")

Resource Request (data model class "resource_request")

Values (or X-Axis and Y-Axis)
  • Axis-1: Project (related_project)
  • Axis-2: Time spent in FTE (resource_rel_fte)
  • Axis-3: Completion Percentage (project_percent_complete)
Sorting The results are not sorted.
Limits There is no limit.
Colors There are no colors.
Available Views Table.
Interactions On this chart, you can:
  • Click the project name to filter on corresponding project.
Technical Details
  • Data model
    • Class: document
      • Property: related_project
    • Class: project
      • Property: project_percent_complete
    • Class: resource
      • Property: resource_rel_fte
  • Mashup feed (allocated)
    • Aggregations added on facet related_project
      • fte: SUM(#has_category("Top/classproperties/type/allocated", categories) ? resource_rel_fte : 0)
      • completion: SUM(#has_category("Top/classproperties/type/resource plan", categories) ? resource_rel_fte : 0)