Cool book - and pretty complex -
Just a thought - if I understand your issue you want to essentially invert the scale so that shorter cycles are better than longer cycles
have you considered inverting your parameter(s) as shown below - keep the display value as it is but invert the Value to start at the max and decrease as the display value increases?
you can load it from a clipboard
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
First of all thank you for responding, and i apologize for such a late response. You have solved one of the problems, but the one that is still giving me a bring problem is how to implement it in my calculated field. I have tried "RUNNING_MIN(AVG(cycle.......))" And another multitude but nothing is giving me what i need
sorry didn't get that from your post - please explain what it is you are trying to accomplish -
what is the expected result?
Again sorry if i'm not explaining what i'm looking for properly, i will try my best on this time to put everything clearly. when you look inside the picklist calculation you see that every parameter is multiplied to its actual measure. Now in this work book we are using to separate data sources( cycle data and Match data) when you go into cycle data you will see the measure good cycle time which is also another calculated field that is only accepting valid cycles. In the overall picklist calculation i'm am trying to multiple that Good Cycle Time to its parameter so i can give it a weight on the picklist. Now while i can do that no problem the issue that i am encountering is making sure that it is weighted by how short the cycle time is, with the shorter the cycle being better. for an example if i put all parameters to zero and cycle to 1 then the team with the shortest average cycle time should be at the top of my list. i hope that was a better explanation, and again thank you for continuing to try and help me.