What i would like to measure is the workdays between the current and the previous release and calculate the average or median of this measurements. I would like to use the release date property of jira releases for this.
I’m sure my basic MDX knowledge is the impediment here, i’ve tried to combine many snippets together, but currently i’ve got stucked. Any tip or help is welcomed.
I’ve tried to build something on this filter taken from the link above:
I am happy you found the answer in the linked post useful. The formulas necessary, to reach the requirement may differ if you intend to use the Fix Version dimension “by Name” hierarchy, but the general approach should be the same as for the example below with the default hierarchy.
First, define a new calculated member in the Fix Version dimension, that will aggregate the “Version” level members. Will call it “Versions with release”:
Aggregate(
Filter(
[Fix Version].[Version].Members,
NOT isEmpty([Fix Version].CurrentHierarchyMember.Get('Release date'))
AND
[Measures].[Issues created]>0
))
Next, define a new calculated measure, that will calculate the number of workdays between the release currently in rows and the one prior to it:
DateDiffWorkdays(
ChildrenSet([Fix Version].[Versions with release]).Item(
Rank([Fix Version].CurrentHierarchyMember,
ChildrenSet([Fix Version].[Versions with release])
) - 2).get('Release date'),
[Fix Version].CurrentMember.get('Release date')
)
Finally, you can use Fix Version dimension “Version” level members in rows, select the calculated measure, and then use the standard calculations, to calculate the average. See a screenshot of the report below:
