Timeline of Issues Opening

This chart displays a timeline view of how and when the total number of open issues is going to reach 0. The line chart represents the total number of open issues at a given point in time, taking into account the number of issues that are or must be closed at that time. The bar chart represents the number of issues whose actual or estimated finish date occurs in a given interval.

Business Objects Issues (data model class issue)
Values (or X-Axis and Y-Axis)
  • X-Axis: Weeks of the year.
  • Y-Axis: Number of issues (line) and number of issue closures (bars), estimated or actual.
Sorting The results are chronologically sorted. The more recent results are displayed on the right of the axis.
Limits There are no limits.
Colors The line chart is blue and shows the total of open issues. Actual closures are in orange, and estimated closures are in purple. Colors are configured in Preferences. For more information, see Configuring Facet Displays.
Available Views
  • Line and bar chart
  • Full screen chart
Interactions On this chart, you can:
  • Draw a rectangular area on the chart using drag-and-drop to zoom on this area.
  • Hide series by clicking them in the legend.
  • Click to access the different options.
  • Click to add annotations the cart.
  • Click to modify the chart configuration.
  • Click to create an alert.
  • Click to see chart documentation.
  • Click to switch to fullscreen display.
Technical Details
  • Data model
  • Class: issue (and inherited)
  • Property: issue_actual_end_date
  • Property: issue_estimated_end_date
  • Property: issue_actual_start_date
  • Property: issue_estimated_start_date
  • Mashup feed
    • Dynamic date facet closure_state, based on the actual end date if defined, or the estimated end date otherwise:

      • expression: #length(issue_actual_end_date) ? issue_actual_end_date : issue_estimated_end_date
      • aggregation totalopen, created by the Create Custom Aggregation trigger: cumulative sum of issue openings minus issue closures
        • Formula: open_state.opened - closure_state.closed
        • Dynamic date facet open_state, based on the actual start date if defined, or the estimated start date otherwise: #length(issue_actual_start_date) ? issue_actual_start_date : issue_estimated_start_date
        • Dynamic date facet closure_state, as defined above
        • Both aggregations used (opened and closed) are counts

    • Dynamic date facet closuredatedyn, based on the actual end date:
      • expression: issue_actual_end_date
      • aggregation: count
    • Dynamic date facet closureestimateddate, based on the estimated end date if defined (epoch otherwise):

      • expression: #length(issue_actual_end_date) ? #fromunixts(0) : issue_estimated_end_date
      • aggregation: count