Hello Community,
I have started using Eazybi from some time and would like to create a report of issues which are in active sprint and are spilled over from more than 4 sprints. I have tried from few community posts but it’s not working for me.
Any help on this?
BR,
Salvinder
Hi @Sal
If you are using Sprints in your Jira and importing them in eazyBI, then the Issues will have an additional property called “Issue Sprints” that you can find in your Measures dimension.
For a report like this, you can use the Sprint dimension in Pages with the necessary Sprint selected and Issue dimension in Rows with individual issues selected.
Next, you can define a new calculated measure “Previous Sprint count” in the Measures dimension that will take the “Issue Sprints” property and count the commas in that property, thus finding out- in how many sprints it has been in.
Use this formula for the “Previous Sprint count” measure:
Len([Measures].[Issue Sprints])
-
Len(Replace([Measures].[Issue Sprints], ',', ''))
When you select this measure for your report, it should show up as a column of numbers of “count of issue sprints minus one”. If you wish the count to show the number of all sprints, just add “+1” to the formula of the measure.
Lastly, you can filter the issues by clicking on the “Previous Sprint count” column header and selecting the “Filter rows” → “>= 4” option.
Let me know if this fits your use case or if you have any additional questions!
Best regards,
Nauris / eazyBI support
