eazybi - sum child cells values

Hi, I am making some calculations based on days in specific status for issues inside projects. What I am trying to do, is to sum up all the values of the child issues in the corresponding project cell as it's happening with System fields like "Transitions to status" for my calculated field "Days in transition status until now".

Is this possible?

Thank you!

Pablo.

2016-09-03_11-46-32.png

3 answers

Hi Pablo,

Standard measure "Days in transition status" sums up values from a lower level to a higher (measure "Days in transition status" is calculated only for issues that have been transited from the status).

The behavior of each calculated measure depends on how the particular calculation is written - for example, if some issue property is used for a calculation, then the value would be shown only at the issue level unless the Sum function to Descendant set would be applied for summing up Issue values to Project or All issues level.

Please share to support@eazybi.com the calculation formula of "Days in transition status until now" to understand why this particular measure does not give results you are looking for. Also, which dimension is used in rows? 

 

Ilze, 

eazyBI Customer Support Consultant

Question, when you say Child Issue, how are you creating child issue(Bug) to another project? Could you please give me some insight?

I was referring to hierarchical level, Project > Issue.

I receive a perfect solution for my question from EazyBI Support, if it is useful for someone, this is the calculation:

CASE WHEN
  [Issue].CurrentHierarchyMember.Level.Name = "Issue"
THEN 
  IIF(  
   [Measures].[Transitions to status] = [Measures].[Transitions from status],
   [Measures].[Days in transition status], 
   [Measures].[Days in transition status] + DateDiffDays([Measures].[Transition to status last date], Now())
  ) 
ELSE 
  Sum(
   Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Transitions to status]>0),
   IIF(  
    [Measures].[Transitions to status] = [Measures].[Transitions from status],
    [Measures].[Days in transition status], 
    [Measures].[Days in transition status] + DateDiffDays([Measures].[Transition to status last date], Now())
   )       
  )
END

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

941 views 5 18
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
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