Forum Discussion
Advocate IIHierarchies- need some help
Advocate III have a table which contains a value for all my locations.
each location has a value
the locations are placed in a hierarchy and i have build a graph that drills down through the different levels
it works, but it sums or i my case averages the values
as it is averaging all the values under the hierarchy structure, it does not give the value for that location
example
l1 3.5
l2a 3
l2b 3
l2c 4
the l1 value seem to be the average of all the values rather than 3.5
hope this clarifies
Note the size o fthe location differ so an average is not really any use
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
residentxHelper IV
I know you've figured this out by now but you need to turn-off aggregation or set for "no aggregation" or average