Open Issues

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

  • Open issues: number of open issues (with statuses other than closed)
  • Open late issues: number of issues with statuses other than closed, whose estimated end dates have passed
  • High priority issues: number of issues with high priority

Business Objects Risk (data model class "risk")
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:
    • open: number of snapshot documents without the closed category on facet current.
    • late: number of snapshot documents without the closed category on facet current and whose issue_estimated_end_date < now.
    • high: number of snapshot documents with the high category on facet priority.
Sorting The results are chronologically sorted.
Limits Only 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 the dashboard on:
  • Open issues
  • Open issues whose estimated end dates have passed
  • High priority issues
Technical Details
  • Consolidation
    • These indicators rely on snapshots computed by the project_getIssueHistoryFromEnovia aggregation processor
  • Data model
  • Class: issue (or inherited)
  • Property: document_history_weekofyear
  • Property: document_history_type
  • Property: document_current
  • Property: document_priority
  • Property: issue_estimated_end_date
  • Mashup feed

    • Aggregations added on the history_weekofyear facet at feed level:

      • open: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/closed", categories))
      • late: SUM(#regex_match(document_history_type, 'snapshot') && #ndays(#extract(document_ram_datetime,"issue_estimated_end_date"),#now()) > 0 && !#has_category("Top/classproperties/current/closed", categories))
      • high: SUM(#regex_match(document_history_type, 'snapshot') && #has_category("Top/classproperties/issue/priority/high", categories))