Bugs versus Story Points

HI , i’m trying to build a report where I can track the count of bugs per story points raised against a story. Essentially tracking developed code quality against the number of story points of the story that the work was committed against.

i can achieve this at the story level but I’m unable to roll this up to a project level.

I’m using issue story point points which is a property and from what I’ve read properties don’t roll up they only display at the row level. So I’m struggling how to approach this.
below are the rows I’m using, my measures are issues created, issue story points and then a custom measure that divides the number of issues over the story points.

Hi,

You are right; the issue properties does not roll up for other dimensions than issues.

The Story points field is imported into eazyBI as a property and also as several measures, mapped differently to the time dimension:

You should use the Story points created measure instead of the Issue Story points. This measure gives the count of Story points by the issue creation date which seems matching your reporting needs.

Kindly,

Janis, eazyBI support

thanks for reply.
I’m trying to use Story Points Created measure.

but not sure how best to achieve.
should i try to find all issues that are of type Bug or Story bug etc and then write a custom measure to get the parent “Story Points Created”
or should I find all issues that are stories and have children that are bug or story bug.
Sorry I’m a bit of a novice and struggling with some basics.

thanks for any suggestions.

Hi,

The best way for counting bugs is to import the issue link between story and bug. Issue links are not imported in eazyBI by default (except sub-tasks) and you need to provide the configuration of that. Please check the documenation on how to do that: Import issue links

Once you import the links to bugs, you should see a new property holding the bug list per issue:

You may also check the Issue/Bug links with a report like this:

The following formula is for counting the Bugs per issue if you have imported the Bugs link:

Sum(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  not IsEmpty([Measures].[Issue Bugs])
  AND
  [Measures].[Issues created]>0
  ),
  Len([Measures].[Issue Bugs])-
    Len(Replace([Measures].[Issue Bugs],",",""))
  +1
)

The formula for the defect density (ratio of bug count to story points):

CASE WHEN
[Measures].[Story Points created]>0
THEN
Sum(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  not IsEmpty([Measures].[Issue Bugs])
  AND
  [Measures].[Issues created]>0
  ),
  Len([Measures].[Issue Bugs])-
    Len(Replace([Measures].[Issue Bugs],",",""))
  +1
)
/[Measures].[Story Points created]
END

This formula will roll-up for other dimensions as well:

There could other approaches for this use case.

So, let me know if that works or you are looking for something else.

Kindly,
Janis, eazyBI support

1 Like