| Business Objects |
Task (data model class "task") |
| Values (or X-Axis and Y-Axis) |
- X-Axis: Task completion percentage
(
project_percent_complete).
- Y-Axis: Week of the year.
|
| Sorting |
The results are sorted by date, from oldest to newest result. |
| Limits |
There is no limit. |
| Colors |
The chart is blue. |
| Available Views |
Bar chart. |
| Interactions |
On this chart, you can:
- Click
 to
switch to fullscreen display.
|
| Technical Details |
- Data model
- Class: task
- Property:
task_percent_allocation
- Class: project
- Property:
project_estimated_duration
- Property:
project_percent_complete
- Mashup feed (project_history)
- Aggregations added on facet
type
- allocation_after_one_week:
SUM((#sum(task_percent_allocation)
/ 10000) * (project_estimated_duration * (100 -
project_percent_complete)) / 100<6 ? (project_estimated_duration *
(100 - project_percent_complete)) / 100: 5)
- allocation_after_two_week:
SUM((#sum(task_percent_allocation)
/ 10000) * (project_estimated_duration * (100 -
project_percent_complete)) / 100<11 ? (project_estimated_duration *
(100 - project_percent_complete)) / 100: 10)
- allocation_after_three_week:
SUM((#sum(task_percent_allocation) / 10000) *
(project_estimated_duration * (100 - project_percent_complete)) /
100<16 ? (project_estimated_duration * (100 -
project_percent_complete)) / 100: 15)
- allocation_after_four_week:
SUM((#sum(task_percent_allocation)
/ 10000) * (project_estimated_duration * (100 -
project_percent_complete)) / 100<21 ? (project_estimated_duration *
(100 - project_percent_complete)) / 100: 20)
|
