Forum Discussion
Automatic recalculation on average weighted curve
From a drop-down list of several projects, I would like to be able to choose the items in any order and that the average weighted curve is automatically recalculated, depending on the weights of each selected project, since today only the sum of each project is what is shown in the curve so at the end of the curve the sum is greater than 100% I thank you for your help.
4 Replies
v-qiuyu-msftCommunity Support
Hi CRUANO,
Do you mean you would like average weighted curve be filtered by the selected values in the slicer?
It would be better if you could share some sample data and show the expected data with selected projects in the slicer visual.
Best Regards,
Qiuyun YuThat´s it!
I enclose an example of the data with its development in the year and three example categories on which the data can be grouped without distinction.
The intention is that the cumulative annual progress curve would be recalculated according to the categories that are chosen in the slicer.Thanks in advance.
Budget Project category 1 Project category 2 Project category 3 1/01/2018 1/02/2018 1/03/2018 1/04/2018 1/05/2018 1/06/2018 1/07/2018 1/08/2018 1/09/2018 1/10/2018 1/11/2018 1/12/2018 Project 1 2.808.783 A D I 0,0% 0,0% 0,0% 5,0% 20,0% 40,0% 50,0% 60,0% 70,0% 80,0% 90,0% 100,0% Project 2 4.170.517 C G I 2,2% 5,9% 8,0% 10,0% 17,0% 24,0% 39,0% 49,0% 59,0% 75,0% 85,0% 100,0% Project 3 3.475.206 C G I 20,0% 40,0% 74,0% 90,0% 92,0% 94,0% 96,0% 98,0% 100,0% 100,0% 100,0% 100,0% Project 4 6.109.402 C D I 0,0% 0,0% 0,0% 0,0% 5,0% 15,0% 40,0% 50,0% 60,0% 70,0% 80,0% 90,0% Project 5 1.586.970 A G I 2,2% 8,0% 15,1% 27,3% 42,9% 57,0% 71,8% 79,9% 86,7% 91,9% 100,0% 100,0% Project 6 392.758 C D H 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 10,0% 35,0% 60,0% 100,0% 100,0% Project 7 2.842.171 B G H 0,0% 0,0% 0,0% 0,0% 1,0% 5,0% 15,0% 30,0% 40,0% 70,0% 90,0% 100,0% Project 8 1.022.865 C F H 0,0% 0,0% 0,0% 0,0% 0,0% 15,0% 45,0% 75,0% 100,0% 100,0% 100,0% 100,0% Project 9 1.020.647 C D J 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 40,0% 80,0% 80,0% 100,0% 100,0% 100,0% Project 10 2.341.199 B D K 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 15,0% 45,0% 80,0% 100,0% Project 11 830.000 B D K 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 5,0% 15,0% 30,0% 40,0% 100,0% Project 12 2.018.484 A D J 9,1% 31,8% 54,5% 77,3% 95,0% 100,0% 100,0% 100,0% 100,0% 100,0% 100,0% 100,0% Project 13 1.948.571 B F K 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 3,7% 23,0% 51,9% 80,7% 100,0% Project 14 1.837.501 A E J 0,0% 0,0% 0,2% 0,6% 1,2% 1,5% 18,1% 38,1% 54,0% 100,0% 100,0% 100,0% Project 15 255.728 A E K 8,1% 15,4% 24,0% 32,4% 41,0% 49,4% 58,0% 66,6% 74,9% 83,6% 91,9% 100,0% Project 16 1.560.098 A E J 0,0% 0,0% 0,0% 0,0% 10,0% 30,0% 40,0% 60,0% 70,0% 80,0% 90,0% 100,0% Project 17 1.508.000 B E K 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 15,0% 25,0% 40,0% 55,0% 75,0% Could you see the data that I recently uploaded? would really be of enormous help some contribution from your part, thanks in advance...
- v-qiuyu-msft
Hi CRUANO,
It seems provided data isn't raw data. Would you please share the sample data you in Data tabs?
Best Regards,
Qiuyun Yu
