Count of Open, Late and Critical Tasks

A set of high-level indicators to summarize the current status of tasks owned by the user 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 Task (data model class "task" and subtypes)
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 and with the user's name in the owner field
    • Late tasks: snapshot documents (document_history_type field) without complete category on facet current, with the user's name in the owner field, and with project_estimated_finish_date before now
    • Critical tasks: snapshot documents (document_history_type field) without complete category on facet current, with the user's name in the owner field, 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 the user's name in the owner field, and 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 green, blue, orange, and red for count of respectively [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_owner
    • 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)