Count tickets per shift

[WijnantsRMJ]

Hi all,

We're working with 3 shifts:

• Shift 1 starts at 7:15 until 15:15
• Shift 2 starts at 15:15 until 23:15
• Shift 3 starts at 23:15 until 7:15

Count the tickets for shift 1 and 2 is easy, but for shift 3 I need to find a solution. For shift 3 I want to count all tickets handled to the next day, else it will count tickets from the previous shift 3 with the new shift 3. 

For instance on day 1 shift 3 handle between 23:15 and 00:00 15 tickets. During the rest of there shift in day 2, so between 00:00 and 7:15 they handle 100 tickets. The total handled tickets should be 115 for that shift, but when using a data table the 15 tickets are counted to the other shift 3 from the day 1 instead of day 2.

Is there away to count the tickets from shift 3 in total, so adding the tickets from 23:15 to 00:00 to the next day. So a real total per shift is correct.

[WijnantsRMJ · Accepted solution]

Hi, Ifound a different solution. I'm using this one which works for me: 

ShiftOpenDate =

    IF(TIMEVALUE(INCIDENTS[OpenedDateTime]) >23 /24, INCIDENTS[OpenedDate] + 1, INCIDENTS[OpenedDate])

Also the Night shift started on 23:00 instead of 23:15, which makes this easier.

[v-yanjiang-msft]

Hi @WijnantsRMJ ,

Glad you solve the problem by yourself! You can mark your answer as the solution. Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @WijnantsRMJ ,

Has your problem solved by @lbendlin 's suggestion, if not, according to your description "when using a data table the 15 tickets are counted to the other shift 3 from the day 1 instead of day 2", could you give a simple example to reproduce this step. I think it's not hard to resolve, but failed to create a sample to clarify.

Best Regards,
Community Support Team _ kalyj

[lbendlin]

two options:

- shift (pardon the pun) all times forward by 45 minutes

- add a composite key "DayPlusShiftNumber" to your data model to help identify which day shift 3 is for