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.
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:
--filter a set of issues
--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: