How to summarize the Sub-task's 'Effort' fields value under an Epic

[Zoltan_Durucsko]

Hello,

I need to create a measure which summarizes the underlying Sub-task’s “Issue effort” measures to Epic level.

This is the structure of the ticket hierarchy:

This is the expected result of the measure:

Could anyone support me in creating this measure?

Thanks

Zoltán

[Elita.Kalane]

Hello @Zoltan_Durucsko

Thanks for posting your question!

Please verify your import options settings and make sure the Epic Link is selected for import

Add the Issue dimension to Rows and select the Epic hierarchy.

1. 

   Add your “Effort” measure to Columns. Please note! Do not add the property (Issue Effort). Instead, add the measure “Effort created” as only the measure will aggregate the values. If you do not see such a measure available, make sure your Effort field is selected to be imported as a measure.

   

   Best wishes,

   Elita fro support@eazybi.com

[Zoltan_Durucsko]

@Elita.Kalane

Add your “Effort” measure to Columns. Please note! Do not add the property (Issue Effort). Instead, add the measure “Effort created” as only the measure will aggregate the values. If you do not see such a measure available, make sure your Effort field is selected to be imported as a measure.

Hello Elita

thank you for the detailed explanation!

Best regards

Zoltán