Project Overdue

A set of high-level indicators to summarize current task-level status with history overview:

  • Projects overdue: Number of projects whose estimated finish date has passed and current status is not complete.
  • Projects due tomorrow: Number of projects whose estimated finish date is tomorrow or less than 24 hours away.
  • Projects due next week: Number of projects whose estimated finish date is 7 days away or less.
  • Projects due after: Number of projects whose estimated finish date is more than 7 days away.

Business Objects Projects (project_space data model class)
Values (or X-Axis and Y-Axis)
  • X-Axis: timeline (week unit), based on history_weekofyear facet
  • Y-axis: aggregation values on the history_weekofyear facet, based on the SUM of respectively:
    • overdue: number of snapshot documents with project_estimated_finish_date < now and without the complete category on facet current.
    • tomorrow: number of snapshot documents whose project_estimated_finish_date <= now + 24h.
    • next week: number of snapshot documents whose project_estimated_finish_date <= now + 7 days.
    • after: number of snapshot documents whose project_estimated_finish_date > now + 7 days.
Sorting The results are chronologically sorted, the most recent on the right of the chart.
Limits Only the last 12 weeks are displayed.
Colors The color of this chart depends on the ratio between the current value and the average of the 12 values.
  • 0% - 50%: Red
  • 50 % - 100%: Orange
  • 100% - 150%: Blue
  • 150% and beyond: Green
Available Views Indicator values.
Interactions On this chart, you can click the filter icon to refine dashboard on (respectively):
  • Overdue projects
  • Projects due tomorrow
  • Projects due next week
  • Projects due after next week
Technical Details
  • Semantic processing:
  • Consolidation
    • These indicators rely on snapshots computed by the project_getProjectHistoryFromEnovia aggregation processor.
  • Data model
  • Class: project_space (or inherited)
  • Property: document_history_weekofyear
  • Property: document_history_type
  • Property: project_estimated_finish_date
  • Mashup feed

    • Aggregations added on the history_weekofyear facet at feed level:

      • overdue: SUM(#regex_match(document_history_type, 'snapshot') && #ndays(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) < 0 && !#has_category("Top/classproperties/current/complete", categories))
      • tomorrow: SUM(#regex_match(document_history_type, 'snapshot') && ((#nhours(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) > 0 && #nhours(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) < 24) || #ndays(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) == 1))
      • nextweek: SUM(#regex_match(document_history_type, 'snapshot') && #ndays(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) < 8 && #ndays(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) > 1)
      • after: SUM(#regex_match(document_history_type, 'snapshot') && #ndays(#now(),#extract(document_ram_datetime,'project_estimated_finish_date')) > 7)