1 Reply Latest reply on Feb 28, 2018 9:30 AM by Norbert Maijoor

    Show only the 4 most recent weeks of a table calculation

    Justin Pulley

      I have a table calculation that relies on a running_sum.  I am trying to get a little spark line type of view for more senior leadership that just shows the 4 most recent weeks automatically.  When I add a rolling 4 week filter it doesn't work because the data from earlier in the year "isn't there" as far as tableau is concerned.  data as follows; how can I get it to show just the last 4 weeks with out dropping the YTD % to 0?

       

          

      Things that dayThings that brokeWeek #% Broken YTD
      66010
      116020
      131130.32
      141140.44
      16050.43
      122060.34
      147070.27
      153080.22
      51090.21