Status of Tasks by Project

This chart shows the total duration of tasks owned by the user, by status, stacked by project. The total duration is the sum of the actual duration of completed tasks and the estimated duration of other tasks.

Business Objects Risk (data model class "risk")
Values (or X-Axis and Y-Axis)
  • X axis: total duration, in days, of tasks in each status.
  • Y axis: task related_project.
Sorting The results are alphabetically sorted, by 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 Percentage bar chart.
Interactions On this chart, you can:
  • Click the bars 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
  • Property: current
  • Mashup feed (project)

    • Multidimensional facet from search logic

      • status_by_proj: current and related_project

    • Aggregations added on facet status_by_proj
      • total_duration: SUM(real_duration)
    • Virtual field added on hits:
      • real_duration: (project_percent_complete == 100 ? project_actual_duration : project_estimated_duration)