How do I create a group of issue types

[Elizabeth_Jones]

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!

[nauris.malitis]

Hi @Elizabeth_Jones

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

[Elizabeth_Jones]

This works great; thanks!