...
...
...
...
...
...
...
Full shifts, ad-hoc.
use [Dim Shift Instances].[Shift Instance]
type year-month-day to filter to just shifts started in that range.
alternatively, use [Dim Shift Instances].[Shift Start Date]
...
Daily or Weekly Report of completed shifts, auto emailed
[Dim Shift Recency].[Recency]
see Data dictionary
EXAMPLE test cases: https://docs.google.com/spreadsheets/d/1P1jvSh841yo9WBRfXrR7CWSxdOIMHDbI/edit#gid=1902529121
Arbitrary Date range (2pm day1 to 2pm day2)
...
1. Select a shift start or end time as the bounds of a period.
...
If the dashboard is scheduled to be emailed at e.g. 7am, filtering by Last 24 hours will filter by the shifts in the last 24 hours relative to 7am.
3. Similar to item 1, select a specific time that is outside of midnight to midnight or their shift calendar timings.
→ “If you wanted to just see a few days of data starting at 10am and ending at 6pm and those weren't shift start or end times”
Can we do this?