Forum Discussion

drogers1209's avatar
drogers1209
Regular Visitor
2 years ago

Time Filter for previous 2 shifts.

I am trying to create a filter/slicer that will show me data from the past 2 shifts at work. I cannot use the relative time feature because it is a rolling time and I need the entire previous two shi...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
They want to see the most recent "B" Shift and most recent completed "A" Shift.

for example. the date is 2/26

yes, but at what time are they looking at the report?  What if they look at it at 6:40 am?  What if they look at it at 6:00 pm?

drogers1209's avatar
drogers1209
Regular Visitor
2 years ago

My goal would be that it wouldn't matter. That it would automatically now the latest completed "A" and "B" Shifts

If that is not possible, this data is usually reviewed between 6:11am and 11:00am

if I viewed at 6:11am I would want to see the data from the most recent "B" Shift 7:30pm - 06:10am and the most recent "A" Shift the day before

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    I assume you have only people from a single timezone looking at these reports?

    • drogers1209's avatar
      drogers1209
      Regular Visitor
      2 years ago

      correct

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        I think a graphical solution may suffice

         

         

        unless you have gazillions of entries. They should be adept enough to filter this themselves.