3 Replies Latest reply on Mar 5, 2018 8:32 AM by Joe Oppelt

    How to rewrite values based on certain criteria

    Qi Chen

      Hi all,

       

      I am not sure if Tableau is able to rewrite (clean up) values by calculated fields instead of change the source data.

       

      Here is my problem. I would like to rewrite the flag for previous period to equal to the flag in the last period (See the red column below). Is it possible?

       

         

      ItemRewriteFlagPeriod
      1YY201601
      1YN01602
      1YY201603
      1YN201604
      1YN201605
      1YY201606
      2NN201605
      2NN201606
      2NY201607
      2NN201608