Hi, I’d like to measure count of issues done by quarter by issue type. However, I’d like to create a new grouping called “features” that groups epics, stories, and tasks. I’d like to show “Features” vs “Bugs”. So 2 groups measured over time to show % completion comparison between Features and Defects. Thanks!
You can group several issue types by defining a new calculated member in the Issue Types dimension and using the following formula for the member:
Aggregate({
[Issue Type].[Epic],
[Issue Type].[Story],
[Issue Type].[Task]
})
You can then use this calculated member together with the “Bug” member that you can search for and bookmark in the Issue Type dimension:
For the issues resolved vs created measure, you can simply define a new calculated measure in the Measures dimension with the following formula:
[Measures].[Issues resolved]
/
[Measures].[Issues created]
With the formatting set to Percentage → Decimal Percentage.
Let me know if this fits your use case or if you have any additional questions on this!
Best regards,
Nauris / eazyBI support
1 Like
This works great; thanks!
1 Like