[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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,323 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot