| Business Objects |
Task (data model class "task") |
| Values (or X-Axis and Y-Axis) |
- X-Axis: Task effort (
task_task_total_effort).
- Y-Axis: Week of the year.
|
| Sorting |
The results are sorted by date, from oldest to newest result. |
| Limits |
Only the 4 incoming weeks. |
| 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: project
- Property:
project_percent_complete
- Mashup feed (project_history)
- Aggregations added on facet
type
- effort_after_one_week:
SUM(#int(project_percent_complete *
project_estimated_duration / 100)> 0 ?
(#float(#int(#sum(task_task_total_effort) / 100)/
#int(project_percent_complete * project_estimated_duration / 100)) *
(remaining_days<6 ? (project_estimated_duration * (100 -
project_percent_complete)) / 100: 5)) : 0)
- effort_after_two_week:
SUM(#int(project_percent_complete *
project_estimated_duration / 100)> 0 ?
(#float(#int(#sum(task_task_total_effort) / 100)/
#int(project_percent_complete * project_estimated_duration / 100)) *
(remaining_days<11 ? (project_estimated_duration * (100 -
project_percent_complete)) / 100: 10)) : 0)
- effort_after_three_week:
SUM(#int(project_percent_complete *
project_estimated_duration / 100)> 0 ?
(#float(#int(#sum(task_task_total_effort) / 100)/
#int(project_percent_complete * project_estimated_duration / 100)) *
(remaining_days<16 ? (project_estimated_duration * (100 -
project_percent_complete)) / 100: 15)) : 0)
- effort_after_four_week:
SUM(#int(project_percent_complete *
project_estimated_duration / 100)> 0 ?
(#float(#int(#sum(task_task_total_effort) / 100)/
#int(project_percent_complete * project_estimated_duration / 100)) *
(remaining_days<21 ? (project_estimated_duration * (100 -
project_percent_complete)) / 100: 20)) : 0)
|
