Forum Discussion
Hierarchies- need some help
If I understand your issue - I think that I'm having the same one - and if so, perhaps I can give more details which may help others understand the problem.
I am building a dashboard to monitor/analyze our current sprints and there are only two levels for the drilldown. At the highest level, I have a sum of the actual work and the estimated work broken down by iteration and then a multirow card to show the total numbers. If I then create a third value - the average - when I drilldown to the actual task level, then the average would in fact be correct and this instance, the average actual work would be 87/12. However, if no matter how I try to calculate the average at the parent (Iteration) level, it's always using the count of items at the task level. What I want to do is to divide the 87 actual hours (at the iteration level) by the number of iterations (in this case, 3). 87/3 being the number that would represent the average actual work for tasks for the entire iteration. I hope that this helps clarify the issue. Screenshots of both levels as per below:
Child Task LevelParent Iteration Level
I know you've figured this out by now but you need to turn-off aggregation or set for "no aggregation" or average