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?
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.
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 email@example.com if you have further questions regarding this!
Martins Vanags / firstname.lastname@example.org
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.
eazyBI support / Martins Vanags
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Atlas Camp is our developer event which will take place in Barcelona, Spain from the 6th -7th of September . This is a great opportunity to meet other developers and get n...
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!
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