Hello,
I am trying to create a calculated member that consists of issues types that have a particular label.
In this case techdebt. In the end I will have 3 calculated members - stories created by product, stories created by dev (techdebt) and bugs.
I can’t figure out how to create the calculated member for stories with techdebt label- which is actually and aggregate of several variations of techdebt.)
any help would be appreciated.
Thanks
Steve
Hi,
The recommended solution for this use case is to use the tuples in the formulas:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Tuples
The number of bugs:
([Measures].[Issues created],
[Issue Type].[Bug])
The number of stories with specific labels:
([Measures].[Issues created],
[Issue Type].[Story],
[Label].[app_1])
You can also create an aggregated member in the Label dimension as described here and refer to them in tuples if several labels must be covered in the calculation:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions
As the Label is the multiple value dimension, you may wish to use the distinct count of issues:
([Measures].[Issues created count],
[Issue Type].[Story],
[Label].[some_label])
Kindly,