HI, I’m new with EazyBI that’s why i’m struggling with some, probably simple, calculation.
No i’m trying to create report with time allocation between different kind of issues: Defect (Defects, Automation tickets), Particular Business Epics and Others
i need to get something similar to
Before business epic expand everything looks good.
But everything breaks when i’m expad list of business epics:
[total hours spent] = (Measures.[Hours Spent with sub-tasks], [Issue Type].DefaultMember)
[Story Time Allocation] = CASE
WHEN [Measures].[Total Hours Spent]>0
THEN [Measures].[Story Hours Spent]/[Measures].[Total Hours Spent]
END
How can i get calculated time allocation for each row, in our case i want to have [Total Hours Spent]= 151 for each row in W36?
thanks in advance!