Percentage of Task Completion

This chart displays the percentage of task completion per project (drill-down on subproject). Task completion is calculated by taking the weighted average of all tasks completion weighted on their length.

Business Objects Project (data model class "task")
Values (or X-Axis and Y-Axis)
  • X-Axis: task completion percentage (total time of completed tasks vs. total time of all tasks)

    Y-Axis: task related_project
Sorting The results are sorted by project name, from A to Z.
Limits By default, only the top 10 categories are displayed.
Note: You can change the pagination to display all the categories by clicking the menu .
Colors Colors are green if the task is complete and otherwise blue.
Available Views Percentage bar chart.
Interactions On this chart, you can:
  • Click the bar names to filter on corresponding project.
  • Click to get all results and enable chart pagination.
  • Click to switch to fullscreen display.
  • Click to switch to table display.
Technical Details
  • Data model
  • Class: document
  • Property: related_project
  • Mashup feed (project)
    • Aggregations added on facet related_project
      • completion_by_duration: SUM(project_percent_complete*real_duration)
      • total_duration: SUM(real_duration)
    • Aggregation trigger to combine total time of completed tasks (aggregation completion_by_duration) with total time of all tasks (aggregation total_duration)