Top 5 from yesterday...

[joshrussin]

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...