Maybe I am just overthinking this, but this used to work, now it suddenly quit working and I'm not sure why. This would show the top 5 clients that we distributed the previous day. (Just a heads up, the previous day data is actually attached to today's date in Date_RD)
Dimension:
Program
Measurment:
Sum({$<Date_RD={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Area={'Distribution Orders'}>} Processed)
attached is the app...