Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table like this one
Ref | Work Order | Work Center | Date | Total Time | Variation |
---|---|---|---|---|---|
A | 1 | WO1 | 2015/45 | 10 | 25 |
B | 2 | WO1 | 2015/45 | 5 | 14 |
A | 3 | WO2 | 2015/46 | 15 | 5 |
D | 4 | WO3 | 2015/47 | 2 | -4 |
C | 5 | WO1 | 2015/45 | 4 | 5 |
B | 6 | WO2 | 2015/49 | 5 | -15 |
A | 7 | WO1 | 2015/45 | 10 | 25 |
This table gives for each Work Center for each date the total time produced on this work center and the variation compared to the last 4 weeks.
I would like to display on a graph only the evolution of the production time of the work center where variation is >10 (if we are 2015/46, i want to see the evolution during the year of production of the work center where variation is >10).
How should i perform this?
Seems to work, thx, but was is the role of DateNum? It doesn't seem to count weeks in chronological order
Ok, then you need to fix this, as I mentioned above, create a sequential DateNum in chronological order, just to make the previous week calculation much more easy.
You can also work upon a date field that shows am underlyin numeric representation, but then formatting issues need to be considered: