Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
GANG | GANG DESCRIPTION | CUSTOMER_NAME | SHIFT | DATE SHIFT | START SHIFT | END SHIFT | LABOUR_HOURS | PART_NO | Tool | ROLE_CODE | DESCRIPTION | TO_DATE_FROM_TIME | TO_DATE_TO_TIME | WEIGHT HANDLED | LOAD QTY | IDLE TIME |
200 | HUBO 1 | Hamburger | S1 | 11/01/2013 | 6:00:00 | 13:45:00 | 7:15:00 | COLA | - | ID_RAIN | cannot start unload due rain | 6:30:00 | 6:45:00 | 174162 | 81 | 0:15:00 |
FANTA | - | ID_RAIN | cannot start unload due rain | 6:30:00 | 6:45:00 | 33245 | 4 | 0:15:00 | ||||||||
SPRITE | ID_RAIN | cannot start unload due rain | 6:30:00 | 6:45:00 | 10512 | 5 | 0:15:00 | |||||||||
DUVEL | 694702 | 185 | ||||||||||||||
PALM | 83772 | 40 | ||||||||||||||
Total | 996393 | 315 | 0:45:00 | |||||||||||||
WEIGHT_HANDLED : =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO)) | ||||||||||||||||
LOAD_QTY : =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO)) | ||||||||||||||||
IDLE TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO)) | ||||||||||||||||
How I would to have it | ||||||||||||||||
GANG | GANG DESCRIPTION | CUSTOMER_NAME | SHIFT | DATE SHIFT | START SHIFT | END SHIFT | LABOUR_HOURS | PART_NO | WEIGHT HANDLED | LOAD QTY | Tool | ROLE_CODE | DESCRIPTION | TO_DATE_FROM_TIME | TO_DATE_TO_TIME | IDLE TIME |
200 | HUBO 1 | Hamburger | S1 | 11/01/2013 | 6:00:00 | 13:45:00 | 7:15:00 | COLA | 174162 | 81 | VF02 | FA_TRUC | waiting for truck | 6:00:00 | 6:15:00 | 0:15:00 |
FANTA | 33245 | 4 | KR01 | FA_OPEN | waiting for truck to be ready to unload | 6:15:00 | 6:30:00 | 0:15:00 | ||||||||
SPRITE | 10512 | 5 | ID_RAIN | cannot start unload due rain | 6:30:00 | 6:45:00 | 0:15:00 | |||||||||
DUVEL | 694702 | 185 | ||||||||||||||
PALM | 83772 | 40 | ||||||||||||||
Total | 996393 | 315 | 0:45:00 | |||||||||||||
need to have a set-analysis to read out all the used tools | ||||||||||||||||
need to change the place of WEIGHT HANDLED AND LOAD QTY | ||||||||||||||||
need to be able to read out all the role_codes |