On time for shipping in the last 30 days
This gauge shows the percentage of work orders which have been finished before or on the end date. This indicator includes only closed work orders by default, and the data range is the last 30 days. This can be changed in the query described in the Positions area.
Data items used
|
Description
|
View/Table field
|
Work orders on time
|
Count of the closed work orders that have been finished before or on the end date.
|
Calculated field in dashboard editor:
CountDistinct(Iif([Latest receipt date] <= [End Date], [Work Order], null))
|
Work Order
|
Distinct count of all the closed work.
|
View: BEASV_WORKORDER_POS. [DocEntry]
|
End date
|
Scheduled end date of the work orders
|
View: BEASV_WORKORDER_POS.[EndDate]
|
Last receipt date
|
Compares the Last material receipt date and the Last work receipt date and chooses the most recent one.
|
CASE
WHEN COALESCE("LastMaterialReceiptDate", "LastWorkReceiptDate") > COALESCE("LastWorkReceiptDate", "LastMaterialReceiptDate")
THEN COALESCE("LastMaterialReceiptDate","LastWorkReceiptDate")
ELSE COALESCE("LastWorkReceiptDate","LastMaterialReceiptDate")
END AS "Latest receipt date"
FROM "BEASV_WORKORDER_POS"
|
Last material receipt date
|
Last date when a material was received.
|
View: BEASV_WORKORDER_POS.LastMaterialReceiptDate
|
Last work receipt date
|
Last date when work was received.
|
View: BEASV_WORKORDER_POS.LastWorkReceiptDate
|
Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.
|
Productivity in the last 30 days
This gauge shows the percentage of the actual total work time compared to the total planned work time. This indicator includes only closed work orders and a data range of the last 30 days by default. This can be changed in the query described in the Positions area.
Data items used
|
Description
|
View/Table field
|
Planned Time
|
Total of the planned time for work in minutes.
|
View: BEASV_WORKORDER_ ROUTING.PlannedTime
|
Actual Time
|
Total of the reported time in minutes.
|
View: BEASV_WORKORDER_ ROUTING.WORKTIME
|
Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.
|
Scrap overall in the last 30 days
This gauge shows the percentage of the scrap quantity, produced during the operations, compared to the total produced quantity (scrap quantity + yield quantity). This indicator includes only closed work orders and a data range of the last 30 days by default. This can be changed in the query described in Positions area.
Data items used
|
Description
|
View/Table field
|
Total Quantity Produced
|
Sum of the yield and scrap quantities.
|
Calculated field in dashboard editor:
[YieldQuantity] + [ScrapQuantity]
|
Yield Quantity
|
Sum of the received goods quantity (in BOM unit).
|
View: BEASV_WORKORDER_ROUTING.QUANTITYGOOD
|
Scrap Quantity
|
Sum of the scrap quantity (in BOM unit).
|
View: BEASV_WORKORDER_ROUTING.QUANTITYSCRAP
|
Note: The percentage is calculated setting the value type to percent of target in the gauge. The default conditions for the data range are set in the query.
|
Help URL: https://help.beascloud.com/beas202106/index.html?production_gauges.htm
|