Forum Discussion

JSmart913's avatar
JSmart913
Frequent Visitor
1 year ago

Filtering data through yeterday

I have a report where I want to filter the dat up through yesterday automatically without having to have a slicer and changing the day on the slicer every morning.  Is this possible?  Basically I would want to see number of sales and number of expected sales for the month up through yesterday

2 Replies

Replies have been turned off for this discussion
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    1 year ago

    JSmart913 Several ways to do this. One would be to add this column to your data and then set a page or report level filter to filter for 1:

     

    Column = IF( [Date] < TODAY(), 1, 0 )

    This assumes that the data is refreshed every morning for example.

     

     

    • JSmart913's avatar
      JSmart913
      Frequent Visitor
      1 year ago

      Thank you!  Is there a way to do it on the visual level instead of adding to the dataset?