I need create a report that tracks how many times a bug passes through a certain transition.
For each project I must count e show if passes 1 time in X transition or 2 times or 3 … and i present this measures in columns.
For good presentation, I created calculated member that aggregate the issues per project, (with a fancy name), for example, the issues of CBB project, I did “aggregate([issue].[CBB])” and named as “Squad Captação Bancaria”, and when I expand, I can see each issue for the criterias.
When I use only the tuple “[measure].[pre-b]” on columns “Totals”, everything is showing correctly, but when I try separate per “X recorrences” of certain transition per project/issue, my calculated members came back empty.
I need that, for example, the number the appears in “Squad Captação Bancaria” be the same number that appears in “CBB”
This is how my “X Recorrence” calculated measures looks like:
[Measures].[1 Recorrence] =
CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = 'Issue' THEN CASE WHEN [Measures].[Pre-B] = 1 THEN 1 END ELSE CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = '(All)' THEN Sum( Filter([Issue].CurrentHierarchyMember.Children, [Measures].[Pre-B] = 1), [Measures].[Transitions to status] ) ELSE Sum( Filter( - `Preformatted text`- iterate through Issue dimension "Issue" level Descendants([Issue].CurrentMember,[Issue].[Issue]), -- return a set of issues matching condition [Measures].[Pre-B] = 1 ), - - evaluate the set of issues over the measure below [Measures].[Transitions to status] ) END END
My “Totals” :
-- In "[Measures].[Pre-B]" contains ([Measures].[Transitions to status],[Issue Type].[Bug]) [Measures].[Pre-B]