Percentage of Gate Completion

This chart displays the percentage of gate completion per project (drill-down on subproject) for tasks owned by the user. Gate completion is calculated by taking the weighted average of all gates completion weighted on their length.

Business Objects Tasks (data model class "gate")
Values (or X-Axis and Y-Axis) X-Axis: gate completion percentage (total time of completed gates vs. total time of all gates).

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 gates (aggregation completion_by_duration) with total time of all gates (aggregation total_duration)