Hello! I have a question about the decomposition tree visual. Based on the nature of this visual, I am wondering if it actually would even have the capability to do this, and if anyone knows. I am going to use an example, because I think that will be the easiest way to explain it.
For the ‘analyze by’ field I am using the column called “contact hours” and it is a sum of these values. Then for the decomposition tree the first “explain by” level is called Phase. There are 5 phases… then the next level is Step – there are 3 steps per Phase. The last level is Milestone. One person may have contact hours for 3 milestones that are under one Step. When it is at the milestone level I want it to sum the hours overall for each milestone. But when I get to the step phase, I only want the hours summed one time for that person, rather than summing it 3 times because the contact hours show up 3 times – one for each milestone (note – each person’s contact hours will be the same value for each milestone, step, and value)… so trying to avoid duplication of each person’s contact hours depending on the level…
So if a person had 5 contact hours for 2 milestones under step 1 (phase 1) and 1 milestone under step 2 (phase 1), then the contact hours for milestones would be 15 hours, the step would be 10 contact hours (included only once for each step) and then 5 hours for phase (counted one time for that phase). So for Step I want it to sum the hours for each person only one time, regardless how many milestones they have contact hours for under that step. I want to do the same thing for phase – I only want it to sum contact hours one time for each person in that phase, regaardless of how many milestones and steps they are under… so if one person has many milestones under many different steps in that phase, I want it to only appear once in the sum.
Is there any way to achieve this, knowing that there is only one field for the Analyze by? Like I said… based on the nature of the decomposition tree it seems that maybe this would not be possible?…..Any advice is helpful, thanks in advance! (apoogies if this was already asked… I looked through and could not find this)