Hello,
I would like to build a chart showing the burndown for N sprints with the 1… Nth sprint day on x axis and story points on Y axis, so that it would be possible to compare different burndowns from the same board overlaying them in the same chart.
Could it be possible?
I guess I should create some kind of “sprint day #” dimension.
Thanks for posting your question!
This is a bit of a challenging request and initially I though I would direct you to a similar report created in our Demo account for version comparisons, you can take a look at an example here - Open issues in version comparison by release date - Issues - Jira Demo - eazyBI
But I’ll give you an alternative option which in my opinion is a little more simple.
Step 1
Create 14 calculated members in the Time dimension (or as many members as yhow long your Sprints typically are), where you name the members from 0 to 13. You will need to select all these members in your report with Time dimension being in Rows
See example below
Step 2
Create a calculated member in the Sprint dimension (Calculated members in other dimensions) where you aggregate some of the latest sprints.
This is a member I use in my example, where I aggregate srpints from 8 months ago to 1 month from now. You can adjust this member according to your needs. Sprint dimension should be placed in Columns next to Measures. In my example in the screenshot below, you will see that I have selected the member “Latest sprints” and expanded it to sprint level
Aggregate(
Order(
Filter([Sprint].[Sprint].Members,
[Sprint].CurrentMember.getBoolean('Closed') AND
NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
DateBetween([Sprint].CurrentMember.get('Complete date'),
"8 months ago" , "1 month from now") ),
[Sprint].CurrentMember.Get('Complete date'),
BASC
)
)
Step 3
Define a new calculated measure in the Measures dimension with the formula below. This will return the Remaining story points at the sprint start date + days you have defined in the Time dimension. When you select the Time members you created, this measure will dynamically return the remaining story points for Day 0 (start date) Day 1 (the second day of sprint and so on)
(
[Measures].[Sprint Story Points remaining],
[Time].[Day].DateMember(DateAddDays([Sprint].CurrentMember.get('Start date'),
cast([Time].CurrentHierarchyMember.Name as numeric)))
)
This is how your report may look:
Let me know if this works for you or if you have any follow-up questions!
Best wishes,
Elita from support@eazybi.com
Greetings @Elita.Kalane
thanks very much for your reply!
I’m trying it and it seems to work… I just have an additional question:
How may I filter the resulting report by board?
I unfortunately have projects with multiple boards belonging to different contexts, so I find myself with a bunch of sprints that appears on the same overlayed graph but they don’t mean really anything to each other.
I thought I could add a custom “board” dimension, but I can’t understand how.
thanks again.
Thanks for the follow up and for confirmation it works 
To filter by board, you may adjust the Latest Sprints member similarly like this, but replace D1 Board in the third line with the name of the board you want to include for your analysis
Aggregate(
Order(
Filter([Sprint].[D1 board].Children,
[Sprint].CurrentMember.getBoolean('Closed') AND
NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
DateBetween([Sprint].CurrentMember.get('Complete date'),
"8 months ago" , "1 month from now") ),
[Sprint].CurrentMember.Get('Complete date'),
BASC
)
)
Best wishes,
Elita from support@eazybi.com
Hi @Elita.Kalane ,
this would limit the measure to one board only, I need a way to select the board so that I might write one report only for all boards.
What I see now is that the “latest sprints” now in the report belong to different boards, so the diagram is mixed up.
Hello @Mauro_Bennici
You don’t necessarily need to create a calculated member in the Sprint dimension, if that is not needed. You can follow the steps shown below.
Expand Sprint dimension you have in Columns and add it to Pages
Make sure you have the Sprint level selected in the Sprint dimension in Columns and all Sprints in the Sprint dimension in Pages. Then you can filter out the sprints you want to analyze from different boards.
See the screenshot below with details.
Best wishes,
Elita from support@eazybi.com
2 things… I don’t have a “page filters” button, just a “pages” button.
Aaaaand… this means I have to select sprint by sprint everytime, right? I cannot filter the “last x closed sprints” anymore.
Hello @Mauro_Bennici
Page filters and Pages are the same thing. Most likely you have not yet upgraded to the latest - 8.1.0 version yet - Changelog - eazyBI for Jira
If you still want to include the last x sprints instead and also be able to filter by boards, please look at this loom video for steps to take: eazyBI - eazyBI-support Jira - 9 June 2025 | Loom
If you don’t have a measure “Last closed sprints by boards”, I’m pasting the measure below so that you can create it in your account. The row filter I apply on this measure in the Loom video is for filtering out the last 4 closed sprints (Row filter less than 5 on the measure). This is where you can apply however many last closed sprints you require.
CASE
WHEN
([Measures].[Issues created],
[Sprint].CurrentHierarchyMember.Parent) > 0
THEN
NonZero(
Rank(
[Sprint].CurrentHierarchyMember,
Order(
Filter(
[Sprint].CurrentHierarchyMember.Parent.Children,
NOT isEmpty([Sprint].CurrentHierarchyMember.Get('Start date'))
AND [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
),
[Sprint].CurrentHierarchyMember.Get('Start date'), DESC)
)
)
END
Best wishes,
Elita from support@eazybi.com
thank you again, I have that, didn’t imagine it was good to be used in that scenario.
regards