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 firstname.lastname@example.org if you have further questions regarding this!
Martins Vanags / email@example.com
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
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...
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