Forum Discussion
Creating impact calculator
Hi Xiaoxin Sheng,
This does provide an idea where is the biggest impact, but what i need is to calculate exactly how many seconds that impact is.
This would help me to understand a level of potential improvement.
Thank you for your help
Filarap
HI Anonymous,
>>what i need is to calculate exactly how many seconds that impact is
I'm not so sure for this, can you please explain more about this?(e.g expected result)
Regards,
Xiaoxin Sheng
Certainly , ill be happy to.
Please have a look at example already provided and formula that goes into impact column for each row.
=($D$9-$D2)/($B$9-$B2))-$C$9
A B C D E 1 Name Freq Result ttls Impact 2 name 1 10 300 3000 -3.06131 3 name 2 15 257 3855 0.679559 4 name 3 7 652 4564 -21.6475 5 name 4 50 217 10850 27.31679 6 name 5 4 364 1456 -3.15207 7 name 6 24 150 3600 24.7367 8 name 7 23 329 7567 -13.9368 9 133 262 34892 The principle is that we are taking a specific user, process (Row 2 example) and calculating the difference between total weighted average results and the same, but without observed process or user.
In the example above, we can see weighted average of 262 seconds (C9) and in E2 we can see how much seconds would this result change, if we remove Name 1 from the total calculation. This is giving us the impact of this user/process.
I hope this makes it clear.
Regards
Hi - Any luck in solving this? Trying to make the same sort of measure.
Thanks.
Hi Anonymous
Please see below.
Result and freq are measures I made.
Name is column in table.
Impact =
CALCULATE
([Result],ALLSELECTED(Table1[Name))
-
divide((CALCULATE([Result]*[Freq],ALLSELECTED(Table1[Name]))
-
CALCULATE([Result]*[Freq])),
CALCULATE([Freq],ALLSELECTED(Table1[Name]))-[Freq])Hope this helps
Filarap