EazyBI - calculate sum of custom field values for issues in Epic?

Hello!

I have issues linked to Epics with a custom field for Amount (numeric value). I want report the Total Sum of all Amounts by Epic. 

I've got a report configured to show all Epics and drill down to individual issues, and display the Amount field for each issue, but I'm struggling with how to calculate the aggregated sum at the Epic level. What's the formula I would use for that? 

 

 

3 answers

Hi Natalia,

It would require importing custom field as a measure (if not available by default, you could perhaps define it via eazyBI advanced settings) and then you could use it in calculated measures calculation.

If you have more questions about this please contact eazyBI support and share more details and screenshots on this question.

 

Kind regards,

eazyBI support / Martins Vanags

Hi Briana,

 

From your described report It seems you imported this custom field as an Issue property.

Either you import this field value as a measure (that would be the quickest way) via eazyBI import settings and then select this new measure instead of your current selected amount field.

OR

You create a new calculated measure using your imported issue property measure in the code (see below) where you could use the precise name of your imported measure in the code (last part of the code).

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    AND
    [Measures].[Issues created]>0
)
,[Measures].[Issue Amount)
)

 

Please contact support@eazybi.com if you have further questions regarding this!

 

Kind regards,

Martins Vanags / support@eazybi.com

Hello there! I have a problem with sum calculation. I want to define calculated member formula, but in order to do that I need a field to be seen as a measure, and not only as a dimension and property in source data. How can I do that?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Marketplace Apps

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,144 views 0 8
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