Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to see the workload on a manufacturing group per day or maybe per week. I know when the manufacturing order starts, how many hours the order lasts and how many hours per day we work in that manufacturing group. Eg one order starts 2010-11-22 lasts for 20 hours and we work 8 hours per day in that manufacturing group, how do I do for the se the work load per day?
I would make a script solution breaking one order registry into several registries per day.
Something like a "While" statement that, in each step, loads the order, date+1 as date, duration-Time_per_day as duration where duration-Time_per_Day>=0
You should concatenate the results in the same table and use peek() to accumulate the result
It runs while a registry is read.
the result will be a table with how much hours were spent in each day. You can simply sum it in your charts.
Best regards
Fernando
I'm not sure that I understand what you mean.
Do you have any example that shows how to do.
Has anyone some new ideas?