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

[Briana]

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? 

[eazyBI Support]

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

[Natalia Lezhai]

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?

[Sir Mārtiņš 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