# Sprint burn-down chart on Sprint issues & Linear trend based on Sprint issues committed

**URL:** <https://community.eazybi.com/t/sprint-burn-down-chart-on-sprint-issues-linear-trend-based-on-sprint-issues-committed/16753>\
**Category:** Questions & Answers\
**Tags:** report-specific, eazybi\
**Created:** [April 4, 2024, 10:21am UTC](https://community.eazybi.com/t/sprint-burn-down-chart-on-sprint-issues-linear-trend-based-on-sprint-issues-committed/16753 "2024-04-04T10:21:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emanuela\_Bauleo](https://community.eazybi.com/user_avatar/community.eazybi.com/emanuela_bauleo/32/12274_2.png) [@Emanuela\_Bauleo](https://community.eazybi.com/u/Emanuela_Bauleo)\
**Post date:** [April 4, 2024, 10:21am UTC](https://community.eazybi.com/t/sprint-burn-down-chart-on-sprint-issues-linear-trend-based-on-sprint-issues-committed/16753/1 "2024-04-04T10:21:30Z")

</div>

Hello everyone,

I’m interested in generating a Sprint burn-down chart based on the remaining sprint issues rather than the remaining story points. Additionally, I’d like to include a linear trend guideline based on the sprint issues committed, not on the committed story points.

Below, you’ll find the measure “Sprint Issues guideline” (from [Sprint burn-down or burn-up chart](https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/sprint-burn-down-or-burn-up-chart)) :

> CASE WHEN  
> DateBetween([Time].CurrentHierarchyMember.StartDate,  
> DateWithoutTime([Sprint].CurrentMember.get(‘Start date’)),  
> [Sprint].CurrentMember.get(‘End date’)  
> )  
> THEN  
> [Measures].[Sprint issues committed] \*  
> (  
> DateDiffWorkdays(  
> DateWithoutTime([Sprint].CurrentMember.get(‘Start date’)),  
> DateAddDays(DateWithoutTime([Sprint].CurrentMember.get(‘End date’)), 1)  
> ) -  
> DateDiffWorkdays(  
> DateWithoutTime([Sprint].CurrentMember.get(‘Start date’)),  
> [Time].CurrentHierarchyMember.NextStartDate  
> )  
> ) /  
> DateDiffWorkdays(  
> DateWithoutTime([Sprint].CurrentMember.get(‘Start date’)),  
> DateAddDays(DateWithoutTime([Sprint].CurrentMember.get(‘End date’)), 1)  
> )  
> END

Here below is the measure “Sprint Issues remaining” :

> CoalesceEmpty([Measures].[Sprint issues at closing], [Measures].[Issues history]) -  
> [Measures].[Cumulative Issues resolved]

The measure “Linear trend Sprint Issues remaining” is derived from “Sprint Issues remaining” → Add calculated → Linear trend. Ideally, this line should be straight and reach 0; however, this is not the case :

 ![Burn-down chart](https://community.eazybi.com/uploads/default/original/2X/9/93e66168f13b96fc6d38ad6034fd893b5cbda1da.png)

Just to clarify, I cannot use the default Jira report as I need to focus on specific issues within the sprints, rather than all of them.

Any suggestions are appreciated 😊

Thanks in advance for your help!

Best regards,  
Emanuela

---

<div class="post-metadata">

**Author:** ![ilze.mezite](https://community.eazybi.com/user_avatar/community.eazybi.com/ilze.mezite/32/15077_2.png) [@ilze.mezite](https://community.eazybi.com/u/ilze.mezite)\
**Post date:** [April 18, 2024, 12:38pm UTC](https://community.eazybi.com/t/sprint-burn-down-chart-on-sprint-issues-linear-trend-based-on-sprint-issues-committed/16753/2 "2024-04-18T12:38:58Z")

</div>

Hi, @Emanuela_Bauleo

Welcom to the eazyBI community.

The trend isn’t a straight line cause there are no weekends added to the Time axes.  
A linear trend may continue indefinitely in the same direction without approaching zero.

Kindly,  
Ilze