5 Replies Latest reply on Apr 26, 2018 5:52 AM by Anupam Mehta

    Replicate data

    Ana Luque

      Hello!

       

      I'm trying to replicate the calculated A(copy) in Tableau, and I don't know how to do it

       

       

      I need to have the same data per day as I have in the field A for A(copy). When I have 0 I need to have the same number I have the day before as day before I get 0 and the same for the day before I have 0.

       

      It is difficult to explain, so with the table will be easier to understand.

       

      If somebody could help me ...

       

      I'm trying something like this

       

      if [A]>0 then

      [A]

      else

      WINDOW_MAX([A], -1,-1)

      END

       

       

      But it is not working

       

       

      Thanks!!!