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 | ||||||||||||||||
DESCRIPTION
due rain
due rain
due rain
: =sum({<ROLE_CODE={'ID*','FA*'}>}Aggr(sum(WEIGHT_HANDLED),PART_NO))
: =sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(LOAD_QTY),PART_NO))
TIME : ==sum({<ROLE_CODE={'ID*','FA*'}>}aggr(sum(IDEL_TIME),PART_NO))
I would to have it
be ready to unload
due rain
to have a set-analysis to read out all the used tools
to change the place of WEIGHT HANDLED AND LOAD QTY
to be able to read out all the role_codes