Forum Discussion

WijnantsRMJ's avatar
WijnantsRMJ
Regular Visitor
4 years ago
Solved

Count tickets per shift

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, b...
Need Help
  • WijnantsRMJ's avatar
    WijnantsRMJ
    4 years ago

    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's avatar
v-yanjiang-msft
Community Support
4 years ago

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