Forum Discussion
Data aggregation issues for different hierarchical levels
Hi,
That is exacy what my question is. What logic do we have to use the rebalance the weights from 0.20 to 0.21 etc. Explain that very clearly.
Hi Ashish_Mathur,
The logic we need to use is the proportionality of the weights within the level we want to calculate the weighted score.
Example: To rebalance the weights for calculting the score for variable AB, the formula is (Weight AB)/(Sum of all Weights for AB):
1. (0,2)/(0,2+0,35+0,40) = 0,21 for the first weight
2. (0,35)/(0,2+0,35+0,40) = 0,37 for the second weight
3. (0,4)/(0,2+0,35+0,40) = 0,42 for the third weight
Hi,
Thank you for clarifying. Can you please also share the exact result you want. Don't share visual for now. Just share the expected result in a Table format and let me know what selections in the slicer/filter will you be making.
Hi Ashish_Mathur, thanks for your reply!
Please find bellow a table with the expected results. I changed the table so that the levels are now a column. As for the slicers and filters, the only one would be the country column. As for the variables and the levels, my intention is to use the drill down capability to show, initially, only variables from the level 1 and once the user clicks on a varible, it would show the corresponding variables on level 2.
Country Level Variable Weighted Score XX 1 A 3,1 XX 1 B 2,1 XX 2 AB 3,0 XX 2 AA 5,0 XX 2 BA 0,2 XX 2 BB 3,9 XX 3 ABA 2,3 XX 3 ABC 4,0 XX 3 AAA 5,0 XX 3 BAA 0,0 XX 3 BAB 1,0 XX 3 BBA 4,3 XX 3 BBC 3,0 Hi,
Someone else will help you with this.