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.

       

      Thanks!

      Scott