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?
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
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
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...
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