11 Replies Latest reply on Aug 15, 2018 1:01 PM by Scott Hinchman

    Calculate to display data from Yesterday or Fri-Sun if its Monday

    Scott Hinchman

      Hello All,


      I have a daily report that currently returns yesterday's data.  Over the weekend the data views don't get updated.  Monday morning at 930am it refreshes.


      I want to setup this view to show Yesterday's data on any day other than Monday.

      On Monday I want it to show Friday through Sunday.


      I am working from a data view and not a custom SQL so I need to use calculations based on the fields I have. I cannot share a workbook.


      Document Date is a date Dimension field I would be using to drive the calc.


      Any help would be appreciated in accomplishing this task.