[Jira 6/EazyBI] Calculated member

Hi All,

I'm trying to sum days spent for Projects Vs days spent for bugs, support.

First thing I want to filter projects via project code then by issue type. I'm a MDX newbie so I've done something like that

IIF ([Issue Type].currentMember <> [Issue Type].[Bug] 
AND [Issue Type].currentMember <> [Issue Type].[Customer Support]
,
Sum({
([Project Code].[TD Proj], [Measures].[Days spent]),
([Project Code].[BU All RM], [Measures].[Days spent]),
([Project Code].[BU All ND], [Measures].[Days spent]),
([Project Code].[BU huma RM], [Measures].[Days spent]),
([Project Code].[R&D projects], [Measures].[Days spent]),
([Project Code].[BU Transport RM], [Measures].[Days spent]),
([Project Code].[BU Transport ND], [Measures].[Days spent]),
([Project Code].[BU Waste RM], [Measures].[Days spent]),
([Project Code].[BU Waste ND], [Measures].[Days spent])
})
,0)

But of course it does not work. If I expand issue type the value is set to 0 as expected for "Bugs" and "Customer Support" but the total is including those issue types.

How can I do it? 

Thank you for your help.

4 answers

Ok it seems that EazyBI Team is no longer following this... too bad :(

Hi Jerome,

I am truly sorry about the delay in answering you.
If I correctly understand your requirements, you need to create two Measure Calculated Members:
1. Days spent for Projects
with the formula:

IIF( 
  [Issue Type].CurrentMember.Level IS [Issue Type].[(All)], 
  Sum(
    Descendants([Issue Type].CurrentMember, [Issue Type].[Issue Type]),
    [Measures].[Days spent for Projects]
  ),
  IIF(
    [Issue Type].CurrentMember.Name = 'Bug'
    OR [Issue Type].CurrentMember.Name = 'Customer Support',
    0,
    [Measures].[Days spent]
  )
)

 

2. Days spent for Bugs/Support
with the formula:

[Measures].[Days spent] - [Measures].[Days spent for Projects]

 

To filter necessary projects, place Project Code dimension in Pages and then select multiple project codes in the dropdown.

 

Best regards,

Jānis.

Hi Jānis, no sweat, happy to see someone :)

It's not working though, even fixing the type (line 5 [Measures].[Days spent for Projects] should be [Days spent], right?). If I use your formula for "Days spent for Projects" then "Days spent for Projects" = "total days spent"

any idea?

regards,

Jerome

Hi Jerome,

Could you please save the report, export the report definition (here is described how to do that: https://docs.eazybi.com/display/EAZYBI/Create+reports#Createreports-Exportandimportreportdefinitions) and send it to support@eazybi.com or paste here to find out why the formula doesn't work for you.


Kind regards,

Ilze, a colleague of Jānis

Hi, I'm trying to achieve something very similar to this.  Did you ever get it working?

Nope. Had to to it differently...

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

135 views 5 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you