New user of EazyBI here needing some assistance, please…
We’re using standard measures with the week dimension to display a stacked bar graph of the following:
Story Points Committed
Story Points Added
Story Points Resolved
We’re happy with the results we got, but we needed to fill the gap on top of the [Story Points Resolved]
with a new calculated measure to display the difference between the two bars and called it [Story Points Unresolved]
While the graph looks good, drilling through the issues produced WAY MORE issues than what we were expecting. Some issues even have negative values.
I also tried below, but it doesn’t work. It returned [Sprint Story Points added]+[Sprint Story Points committed] without removing items that match [Story Points resolved] records
Aggregate (
Except(
{[Measures].[Sprint Story Points committed],[Measures].[Sprint Story Points added]}
,{[Measures].[Story Points resolved]}
)
)
How can we get just the issues that we expect to see?
Hi @Rhoel,
If you want to analyze your sprint data based on the weeks, I would suggest creating the sprint weekly hierarchy in the “Sprint” dimension and then use the standard sprint scope measures in the report. eazyBI provides measure “Sprint Story Points not completed” that shows total of Story Points from issues that were in the sprint, when the sprint was closed, and which were not completed.
Here is a demo report to demonstrate the sprint story point balance: Story Points balance by sprints
Thank you @gerda.grantina
I have asked our EazyBI admin to add custom weekly heirarchy to our project and the results are strange. I was hoping you can provide some insight as to what could be going wrong here:
Week Number Issue: The week number is incorrect. For instance, a sprint that starts on June 10 should be labeled as W24, but it’s currently showing as W23. I checked the sample provided by eazyBI, and the week number in their example is correct. What could be the issue here?
Missing Data: Some data seems to be missing when using the weekly hierarchy. In our standard sprint report, everything looks fine
