Can somebody help creating this table?

Questions & Answers
1

Hi,
I would like to calculate the average between implementations and errors for a version

We have many aplications in one jira project, so we need component to discrimine versions.

image
image887×162 3.25 KB

Can somebody help me?
Thanks

2

Hi @aelexpuru,

Thanks for posting your question.

For a report with Component in Pages and Fix version in Rows, you will need to create new Calculated measures

Issues (issuetype xxx in fixversion):

This will return a number of Issues created in Fix version in a specific issue type.

([Measures].[Issues created],
[Issue Type].[xxx])

Issues (issuetype yyy in affectsversion):

This will return a number of issues of a specific issue type in Affects version, but will not look at (no version) member.

CASE WHEN
  [Fix Version].CurrentHierarchyMember.Name <> "(no version)"
THEN
(
  [Measures].[Issues created],
  [Issue Type].[yyy],
  [Affects Version].[Version].GetMemberByKey(
    [Fix Version].CurrentMember.Key
   ),
    [Fix Version].CurrentHierarchy.DefaultMember
)
END

Lastly, you can use these newly created measures to calculate the average:

CASE 
    WHEN NOT IsEmpty([Measures].[Fix version 1]) 
         AND NOT IsEmpty([Measures].[Affects versija 3]) 
    THEN ([Measures].[Fix version 1] + [Measures].[Affects versija 3]) / 2
    ELSE NULL
END

I hope this helps.

Best,
Marita // support@eazybi.com