Skip to main content
Version: Next

LMES Shift Cross-Day Production Statistics Solution

I. Background and Problem Description​

In manufacturing enterprises, common scheduling methods are "two shifts" or "three shifts", and some shifts (such as night shifts/evening shifts) work across two natural days. Since shifts do not completely coincide with natural days, problems such as confusion in data attribution and inaccurate statistics often occur during production statistics, affecting production management and performance assessment.

II. Main Difficulties​

  1. Unclear Production Attribution Which date should the production of a cross-day shift belong to? The start day of the shift, the end day, or the natural day?
  2. Inconsistent Statistical Caliber Different departments (such as production, finance, management) have different needs for production statistics. Some are based on natural days, and others are based on shifts.
  3. Complex System Implementation Links such as statistics and reports need to support flexible shift time periods and statistical calibers.

III. Solution Ideas​

1. Clarify Production Attribution Rules​

Adopt the "Shift Date" attribution method, that is, the production of a cross-day shift belongs entirely to the start date of the shift. For example, for the night shift on 2025/10/17 (20:00 ~ 08:00 the next day), the production belongs to the night shift of 2025/10/17.

At the same time, the "Natural Day" statistical method is retained, that is, production is counted by natural day (00:00 ~ 24:00) to meet the needs of finance, daily reports, etc.

2. Example​

Suppose you want to query the production on 2025/10/17:

  • Select "Natural Day" mode, the system counts the production from 2025/10/17 00:00 to 2025/10/17 23:59:59.
  • Select "Shift Date" mode, the system counts the production of the morning shift on 2025/10/17 (08:00 ~ 20:00) and the night shift on 2025/10/17 (20:00 ~ 08:00 the next day).

3. Query and Report​

Add a "Statistical Caliber" option to the query interface to switch between "Shift Date" and "Natural Day" modes. When displaying reports, clearly mark the start and end time of the shift and the attribution date to avoid ambiguity. Under the natural day statistical caliber, the bar chart of shift grouping and shift total is still retained in the chart, which is convenient for managers to analyze the production distribution of each shift within the same day.

  1. Production Statistics Query Interface

    • Query Condition: Add statistical caliber dropdown option (Shift Date / Natural Day).

    • Under the natural day statistical mode, the bar chart of shift grouping in the chart only reflects the partial production of each shift within that natural day, especially for cross-day shifts (such as night shifts), whose production is incomplete and only contains partial data within that natural day. To view complete shift production, switch to the "Shift Date" statistical mode.

      1. Shift Setting Schematic

        Shift NameStart TimeEnd Time
        Morning Shift08:0020:00
        Night Shift20:0008:00 Next Day

      2. Production Statistics Query

        • 2025/10/17

          • Morning Shift Production: 52
          • Night Shift Production: 48 (Partial production only under natural day statistics)

IV. Detailed Explanation​

1. Relationship between Shift Cross-Day and Natural Day​

  • Take the shift you set as an example:

    • Morning Shift: 08:00 ~ 20:00
    • Night Shift: 20:00 ~ 08:00 Next Day

  • When you count the natural day of 2025/10/17 (00:00 ~ 24:00):

    • The production of the Morning Shift (08:00 ~ 20:00) will be fully counted into 2025/10/17.

    • The production of the Night Shift will be split into two parts:

      • 2025/10/17 00:00 ~ 08:00 (Belongs to the tail end of the previous day's night shift)
      • 2025/10/17 20:00 ~ 24:00 (Belongs to the first half of the current day's night shift)
      • 2025/10/18 00:00 ~ 08:00 (Belongs to the second half of the current day's night shift, but will be counted into the next day)

2. Result​

  • Under natural day statistics, the production of the night shift is incomplete within a day, only counting the first half of the night shift (20:00 ~ 24:00).
  • The complete production of the night shift needs to span two natural days to be pieced together.

3. Solution​

  • If you need to see complete shift production, you must switch to the "Shift Date" statistical caliber.
  • Under natural day statistics, the bar chart of shift grouping can only reflect the "partial production" of each shift within that natural day, not the production of the complete shift.

V. Summary​

The core of the shift cross-day production statistics problem lies in clarifying the production attribution rules and achieving automatic attribution and flexible query through system functions. Adopt "Shift Date" attribution as the main method, supplemented by "Natural Day" statistics, to meet different management needs. Ensure the accuracy and availability of production data through systematic and standardized processes and interface design. In the natural day statistical mode, it is necessary to clearly prompt that the production of cross-day shifts is partial production, and complete production needs to be viewed by switching to the shift statistical mode.

Last updated on