Hello,
I am currently sitting on a planning view for future releases. In order to transfer it to our business KPI, I have grouped different issue types together as Calculated Members.
Now I have the problem that a certain Issuetype should count into different KPI’s depending on the Project. Unfortunately I somehow can’t get it to work as I’d like to.
Those are my issuetypes for “FEATURES”
Aggregate(
{
[Issue Type].[Issue Type].[Story],
[Issue Type].[Issue Type].[Improvement],
[Issue Type].[Issue Type].[Change Request],
[Issue Type].[Issue Type].[Epic],
[Issue Type].[Issue Type].[New Feature],
[Issue Type].[Issue Type].[Sub-Bug],
[Issue Type].[Issue Type].[Sub-Task],
[Issue Type].[Issue Type].[AQA]
}
)
Those are the ones for Support
Aggregate(
{
[Issue Type].[Issue Type].[Tech Support],
[Issue Type].[Issue Type].[Code Freeze Violation],
[Issue Type].[Issue Type].[Change Request],
[Issue Type].[Issue Type].[Incident],
[Issue Type].[Issue Type].[Hotfix]
}
)
And somehow I have to make it work that “Change Request” in Feature is not in Project “Customer Success” .
For Support “Change Request” is only in Project “Customer Success”.
I’ve also tried already to add it into the measures - but somehow I don’t get it to say “NOT IN” Project “Customer Success”
May you could help my out of my struggle of how I have to add that info into the calculated member formula and/or measures?
Many thanks in advance for your help