[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
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

26,761 views 2 7
Join discussion

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