Data Need:
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)