[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

This widget could not be displayed.

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

This widget could not be displayed.

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

This widget could not be displayed.

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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

131 views 2 0
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