# Feature AGILE-308 - Rework burndown chart

Project: Stream agile
Status: in test
URL: https://community.openproject.org/work_packages/AGILE-308

## Planning

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Target versions | 18.0.0 |
| Sprint | Sprint 13 |
| Backlog bucket |  |
| Votes |  |
| List | Agile Reporting |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Features and Chunks

| ID | Subject | Type | Status | Assignee | Target versions | Spent time |
| --- | --- | --- | --- | --- | --- | --- |
| AGILE-430 | Create data fetching model for graphs based on work package journals | Implementation | closed |  | 18.0.0 |  |
| AGILE-440 | Burndown chart with hour granularity, guideline and project data series, non working days | Implementation | closed |  | 18.0.0 |  |
| AGILE-472 | Close sprint before moving work packages out | Implementation | closed |  | 18.0.0 |  |

## Bugs and other work packages

| ID | Type | Subject | Status | Assignee | Target versions | Spent time | Module |
| --- | --- | --- | --- | --- | --- | --- | --- |
| AGILE-497 | Bug | Burndown chart: missing start date label | confirmed |  | 18.0.0 |  | Modules and project features / Backlogs |
| AGILE-496 | Bug | Burndown chart: initial story point label missing on Y-axis | confirmed |  | 18.0.0 |  | Modules and project features / Backlogs |

## Technical Details

| Attribute | Value |
| --- | --- |
| Module | Modules and project features / Backlogs |
| Feature Flag |  |
| Requires doc change | Yes |
| Enterprise plan | Community (COM) |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups | https://www.figma.com/design/owpxg3fdqZONIGL6SBSG8M/Agile--Sprint-reports?node-id=1-78845&t=MUEBFP23fLVPrXBe-1 |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee | Ivana Šugić |
| Accountable |  |
| Product manager |  |
| Developers | Jens Ulferts |
| Designer | Julia Racsko |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

**As** a an agile user  
**I want to** have an easy to understand burndown graph  
**so that** I can quickly understand the sprint progress

<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/923223/content">

**Acceptance criteria**

  - The existing burndown graph is reworked.

  - The y-axis is the sum of story points (this unit needs to be flexible later - <mention class="mention" data-id="74098" data-type="work_package" data-text="###AGILE-198" data-display-id="AGILE-198">\#\#\#AGILE-198</mention>)

  - The x-axis is the days between the sprint start and finish date
    
      - \[open\] format of the dates - what's consistent with the Dashboard charts?

  - Three data series exist
    
      - "Remaining story points" represents the actual reduction of work
        
          - The series represents the sum of story points per hour of the work packages associated to the sprint in the project that are not closed (according to the backlogs settings for the project).
            
              - The story point value factored in for a work package is the value at the end of each hour (local time for the user), or the current time depending on which is earlier.
        
          - The series stops at the current date if that is earlier than the sprint's finish date
    
      - "Guideline" represents the ideal reduction of work
        
          - The series starts from the sum of story points at the sprint's start date and finishes at 0 at the sprint's planned finish date. Between those two, the series declines with a constant reduction. On non working days, there is no reduction as no work is expected to take place.
        
          - Story points added/removed after the sprint's start date (e.g. by removing/adding work packages or changing the work packages's story points) do not affect the Guideline-dataset
        
          - If the sprint runs longer than anticipated (complete button not pressed after finish date), the Guideline series still points to the planned date as this is what was planned with.
        
          - If the sprint runs shorter than anticipated (completed button pressed before finish date), the Guideline series still points to the planned date but that will not be visible as the graph is cut off at the finish time. The Guideline will not reach 0 then.
    
      - "Remaining story points (projection)" is similar to "Guideline" but starts from the point where "Remaining story points" ends. From there, the data series decreases in a straight line to 0 (only non working days stop the decrease).
        
          - This series only exist if the sprint is ongoing (started but not finished). It is also not existing if the current time exceeds the planned end of the sprint.

  - The non working days are displayed as a gray bar with lower opacity (see if it's implementable this way)

  - Chart.js can display specific data points on hover, so the user can see the number at each point the value changes
    
      - open: what could we include here? just the number, or also links and IDs to the WPs?

  - A blankslate is displayed instead of a graph [(mockup link)](https://www.figma.com/design/owpxg3fdqZONIGL6SBSG8M/Agile--Sprint-reports?node-id=2454-19983&t=mOl1xRIFT1sxRayJ-1) - done in <mention class="mention" data-id="81952" data-type="work_package" data-text="###AGILE-471" data-display-id="AGILE-471">\#\#\#AGILE-471</mention>
    
      - If the sprint doesn't have a start and an end date
        
          - If the user has the "create sprint" permission, the blankslate includes the ability to set the date
    
      - If the current date is before the sprint's start date
    
      - If no work package has had any story point set throughout the sprint's interval
    
      - If the sprint takes more than a year

  - The start/finish dates of the graph are determined as specified by  <mention class="mention" data-id="78631" data-type="work_package" data-text="###AGILE-399" data-display-id="AGILE-399">\#\#\#AGILE-399</mention>

**Technical notes**

  - 
    <br>

**Permissions and visibility considerations**

  - If the user is able to see the sprint and by that enter the report, the graph is visible.

**Out of scope**

  - A change in the backlogs setting for the statuses considered closed affect the whole graph.

*Set the* **To be informed/consulted teams** *field to include all teams necessary to be informed of the changes.*
