I have 2 different issue types and 1 sub-task that could be attached to the 2 issue types.
Both issue types have 1 custom field (number). I wanted to calculate the sum of that custom field for the sub-task issue type inheriting the value from the issue types.
From what I researched I believe I need to have in advanced settings a new field to collect this data.
To describe my scenario better this is the follow relevant data:
Light | ID=10507
Extra | ID=10704
Value | Number | ID=10832
I have 2 different projects.
Light Value 2 and Extra
Light Value 1
Basic Value 1 and Extra
Light Value 1
Basic Value 5 and Extra
I am trying to reach to a table similar to this:
The first step I did, was creating an advanced setting.
I only tried for 1 issue type, to validate if it might work. Although I also feel I should have measure on he properties.
The second step, I added the “Extra Value” to my imported custom fields (Import as dimension, Import as property).
The third step, in a new Analysis. I added “Projects” into rows and created the following new calculated measure:
Sum( Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]), [Measures].[Issue type]= "Extra" ), [Measures].[Extra Value resolved] )
The result is not showing any value in this calculated column measure.
I have the following questions
The update from issue key, I think I need to put the reference to the issue. Not sure if it is well represented.
It is strange to me, how creating the custom field extra value, it will be mapped from the issuetype to the sub-task.
Any help to solve this, would be much appreciated.