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.
Solved! Go to Solution.
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.
Thank you Patrick-
Logic worked perfectly.