Filtering a report for yesterday's sales works great... except on Mondays or after holidays. What you want to do is filter for Last Work Date.



Report creators:

After the Last Work Date attribute has been added to the data source, use it as a True/False filter to compare it to the Invoice Date.




DataSelf Back-end Technicians:

  1. Control the workday and holidays schedules by manually editing the contents of the SYSTEM_WeekDays and SYSTEM_Holidays SQL views. (The holidays can be copy/pasted in from an Excel list. They can also be maintained in the DsTimeSeries.xls file and refreshed through the ETL.)
  2. The LastWorkDate field is available in the _C_DataRefreshedAsOf view.