Intersection of measures

[Bhavin_Kamani]

Hi

We are evaluating eazy BI for our JIRA setup. We would like to have a custom measure that picks up intersection of “Sprint issues committed” and “Sprint issues removed” measures. We are using following formula. But it is yielding empty result.

Sum(
Intersect(
[Measures].[Sprint issues added],
[Measures].[Sprint issues at closing]
)
)

Can you help us with this issue.

Thanks
Bhavin

[zane.baranovska]

Hi @Bhavin_Kamani,

When applying set functions like Intersect() or aggregate functions over some set of data you might want to provide the set of data for those functions. In your cases, set of Issues that were committed and then removed from the sprint.

The calculation might look like this:

NonZero(Count(
  Filter(
    --filter a set of issues
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    --for each issue validate if it was committed and then removed from Sprint
    [Measures].[Sprint issues committed] > 0 AND
    [Measures].[Sprint issues removed] > 0 )
))

Check out also related community topics on sprint scope analyses:

Missed Commitment Report in EazyBI

Hello EazyBI Community! I am new here and I searching of a way to do the following: Missed commitment report showing the percentage amount of work that was originally committed to at the start of the sprint and not delivered at the end of the Sprint. Any help of feedback is appreciated. Thanks! CC

Planned and Completed Measure

Hi Folks, I’m looking to create a measure that will display the story points completed, from the original story points committed to i.e. essentially ignore any stories which were completed, but which were added after the sprint started. I was trying to create a User defined measure, based on the Sprint Story Points committed, and trying to work in a transition status of Done (as you can see below) - obviously without success. ( [Measures].[Story Points added], [Transition Field].[Sprint sta…

You might find interesting also report on sprint issue balance in Demo account:
https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance

Best,
Zane / support@eazyBI.com