Hi community,
I’m calculating a Sprint Story Points committed completion % in eazyBI using the formula below (it’s eazyBi default) and I want to visualize it on a quarterly level in a bar chart:
Sprint Story Points committed completion %:
CASE WHEN [Measures].[Sprint Story Points committed] > 0
THEN
CoalesceEmpty([Measures].[Sprint Story Points completed of committed], 0) /
[Measures].[Sprint Story Points committed]
END
This works correctly at the sprint level, but the issue appears when using the Time dimension.
The measure per quarter should be calculated as: the sum of all sprint story points committed for sprints in that quarter divided by the sum of all sprint story points completed or committed for those same sprints.
What I need is: for a sprint that goes from Month 1 → Month 2, both committed and completed-of-committed story points for that sprint should be counted in Month 1 / the quarter of the sprint start date. In Month 2 / the next quarter, this sprint should not be counted at all for this measure. I have cases where story points are committed in one month and completed in the next, and right now eazyBI spreads the values across months/quarters, which breaks the calculation.
How can I change the calculation so that the percentage is always grouped by the sprint start date (or the sprint end date), even when the commitment/completion happens in the previous or the next month?
Thanks in advance!
Hi @Leonor_Costa
Welcome! It is great that you’ve joined the community! I have answered your question via the support email, feel free to continue in our email thread if you have further questions; however, I will post the answer below for the benefit of other community members.
Your observations are correct. Story Points committed and Story Points completed (and completed of committed) are related to different dates (sprint start and end dates). When you add the Time dimension to the sprint report, sprints that start and end in different periods will have one or the other value empty.
There are two options to overcome this.
Option 1: Modify sprint metrics to count by sprint start date
Create a report where you combine the Time dimension with modified sprint metrics to count committed and completed story points by time period when sprints were started.
Check out this report in the demo account: https://eazybi.com/accounts/1000/cubes/Issues/reports/185871-sprint-cycles-by-time .
This report provides a timeline view of sprint cycles (i.e., sprints started in the same time period) and their story points metrics, organized by sprint start dates.
You can use the same approach to define the custom measure “Completed of Commited Story Points in Sprint cycle”.
Option 2: Import the sprint start month as a sprint property and create a custom Sprint hierarchy
Import the month of the sprint start date as a sprint property (like May 2025, June 2025, etc.) using the REST API, and then create a new sprint hierarchy with the sprint month as another level.
Then you would build a report based on this new hierarchy using standard Sprint metrics (and without using Time dimension in that report)
Please follow the example in our documentation (in the example, a sprint week is imported as a property instead month): https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/sprint-reports-for-sprint-week-cycles-sprint-custom-hierarchies
IlzeLA, support@eazybi.com