Count of Open, Late and Critical Tasks

This chart displays a set of high-level indicators to summarize current task-level status with history overview:

  • Open tasks: count of open tasks before their estimated end date.
  • Late tasks: count of open tasks after their estimated end date.
  • Critical tasks: count of open tasks with critical priority and before their estimated end date.
  • Critical late tasks: count of open tasks with critical priority and after their estimated end date.

Business Objects Project (data model class "task")
Values (or X-Axis and Y-Axis)
  • X-Axis: timeline (week unit), based on history_weekofyear facet
  • Value and Y-Axis of timeline: aggregation value corresponding respectively to SUM of
    • Open tasks: snapshot documents (document_history_type field) without complete category on facet current
    • Late tasks: snapshot documents (document_history_type field) without complete category on facet current and with project_estimated_finish_date before now
    • Critical tasks: snapshot documents (document_history_type field) without complete category on facet current and with true category on facet task_mgmt/critical_task
    • Late tasks: snapshot documents (document_history_type field) without complete category on facet current, with true category on facet task_mgmt/critical_task and with project_estimated_finish_date before now
Sorting The results are sorted by time, the most recent on the right of the chart.
Limits Only the last 12 weeks are displayed.
Colors The color of this chart is customizable and predefined to Red, Orange, Blue, and Green for count of [0; 0.5[, [0.5; 1[, [1; 1.5[, [1.5; 100000[.
Available Views Indicator values with history.
Interactions On this chart, you can click the filter icon to refine dashboard on (respectively):
  • Open tasks
  • Late tasks
  • Critical tasks
  • Critical late tasks
Technical Details

  • Consolidation

    • These indicators rely on snapshots computed by project_getProjectHistoryFromEnovia aggregation processor

  • Data model
  • Class: task (or inherited)
  • Property: document_history_datetime
  • Property: document_history_type
  • Property: project_estimated_finish_date
  • Mashup feed: project_history

    • history_weekofyear facet is added aggregations on feed

      • open: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories))
      • openlate: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories) && #ndays(#extract(document_ram_datetime,"project_estimated_finish_date"), #now()) > 0)
      • opencritical: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories) && #has_category("Top/classproperties/task_mgmt/critical_task/true", categories))
      • openlatecritical: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories) && #has_category("Top/classproperties/task_mgmt/critical_task/true", categories) && #ndays(#extract(document_ram_datetime,"project_estimated_finish_date"), #now()) > 0)