Calculate percentage of Epics

[R_J]

Hello,

I am looking to get an epic percentage progress based on all of its children’s percentage progress. These do not use story points only a manually entered percentage.
Below is what I expect to see in my table:

This is my current Epic Progress code:

 CASE
WHEN [Measures].[Issue type] = "Epic" 
THEN [Measures].[Issue Percentage Complete (%)]
END

If anyone can help with the code part it will be highly appreciated as I am only starting to learn how to use EazyBI in any kind of depth.

Thanks

[martins.vanags]

@R_J

Select the “Epic” level from the “Issue.Epic” hierarchy and then try this formula:

CASE
WHEN [Measures].[Issue type] = "Epic"
THEN
Avg(ChildrenSet([Issue.Epic].CurrentMember),[Measures].[Issue Percentage Complete (%)])
END

Martins / eazyBI support

[R_J]

Unfortunately I am getting the following error (top of image)

Just to make sure we are on the same page, I have supplied screenshots.

The “Row” option is set to “Nonempty” and the “All Hierarchy level members” is set to Epic - Project.

Columns on display are as follows the bottom image.

[martins.vanags]

@R_J

Please reach out to support@eazybi.com and provide your report definition.

https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions

Martins/eazyBI