I will give it my best shot. lol...
I am trying to track Daily output on a production cell based on tracking Downtime. Example: If we enter 10 minutes of downtime, we can calculate the estimated number of loss production....
I would like a graph to show what our estimated output is for the day. so if we are expected to make 240 parts per day (10 parts per hour) and we have 1 hour of downtime, i would like a bar graph to show estimated output to be 230 parts for the day.
The problem i am running into is that when i select "Summed" for my data value, it is calculating 240 parts for every entry of downtime and when i select average, i am not getting a realistic number for that day.
What i think i need to do is lock the daily production number within the formula or divide by the number of entries.
I hope this makes sense....