shift based production

MD2050

Hello Everyone-

We have a dashboard which is displayed on a TV that basically shows units produced by shift and day, entire workflow is based on the variable called “scan_date” which is goes from 00 to 24 hours.

In the filter tool I have the logic built as:

DateTimeFormat([SCAN_DATE],"%Y-%m-%d") = DateTimeToday()  now as soon as the clock hits 24 the applied date will switch to a new date but since the production goes beyond midnight until 2 am next day how can I code the logic so that the dashboard continue to show the aggregate number until 2 am (which is the shift end of employees) from the previous day and then switch to the next day’s numbers after 2 am .

I have attached the data along with the desired output  in column F through K.

Thank you.

test_date.xlsx

patrick_digan

Instead of DateTimeToday(), would something like this work

DateTimeFormat(DateTimeAdd(DateTimeNow(),-2,"hours"),"%Y-%m-%d")

If you subtract 2 hours from the current time, it seems like that should work for your filter.