How to do the same action for to type of issues

Questions & Answers
, ,
1

Hello, I’m a very begginner in MDX and I’m sorry for that.

I would like to do this :

[Measures].[Sprint Story Points at closing],
[Transition Status].[Story Done]

For issues of type “Story”, it’s working fine, but for issues of type “Feature”, it’s not working because it’s not the same status, it’s “Feature Done”

I can’t use [Transition Status.Category].[Done], because, there a lot of other statuses that I don’t want to count.

Do you have an idea ?

2

I explored a little bit and I tested that

CASE WHEN [Issue Type].CurrentMember.Name = 'Story'
  OR [Issue Type].CurrentMember.Name = 'Task'
  THEN ([Measures].[Sprint Story Points at closing],
  --[Transition Status.Category].[Done]
  [Transition Status].[Story Done])
  WHEN
  [Issue Type].CurrentMember.Name = 'Feature'
  OR [Issue Type].CurrentMember.Name = 'Enabler Feature'
  THEN ([Measures].[Sprint Story Points at closing],[Transition Status].[Feature Done])
  END

But I have the followin error

Formula is not valid:
Internal error: Cannot deduce type of call to function ‘_CaseTest’

3

Hi,

If you track the story points for both issue types and use closing statuses exclusively for specific issue types, the following formula should do:

([Measures].[Sprint Story Points at closing],
[Transition Status].[Story Done])+
([Measures].[Sprint Story Points at closing],
[Transition Status].[Feature Done])

This formula is the sum of two tuples. The first part gives results with the stories selected, the second part with the features.

Kindly,
Janis, eazyBI support

4

Oh thank you, it’s work great.

1 Like