Hello,
I have the following problem. I have three custom issue types A, B and C which all have the hierarchy level of a Story. I want to create a chart where I calculate the progress of B based on the number of closed deliverables from C. However, for C I can only display 0% or 100% currently based on the status. Therefore, I would like to calculate the progress of C based on its sub-tasks to make it more accurate. Is this somehow possible? I have attached a picture of how the table should look like. I am using a calculated measure to expand and collapse the third column which is why I added the formula at the top.
Thanks in advance!
Hi @eazyBIquestion,
Having multiple issue link dimensions in report rows might seriously undermine the report’s performance.
If you have different issue types A, B, and C, you might consider building a custom hierarchy based on issue links.
Please read more about that here - Additional Issue hierarchies.
You might get some inspiration for calculations from the report in eazyBI demo account here - Story linked bugs by bug status - Issues - eazyBI Demo Training - eazyBI.
If you have defined a custom issue hierarchy and have sub-tasks below C, then you might try the following approach.
CASE WHEN
-- we are displaying C level
[Issue].CurrentHierarchyMember.Level.Name = "Story"
THEN
CASE WHEN
-- sub-tasks exist
[Measures].[Issues created]>1
THEN
([Measures].[Issues created],
-- status
[Status].[Done],
-- issue type
[Issue Type].[Sub-task])
/
-- all sub-tasks
([Measures].[Issues created],
-- issue type
[Issue Type].[Sub-task])
END
END
Regards,
Oskars / support@eazyBI.com
