9 Replies Latest reply on Mar 22, 2017 4:19 AM by Jim Dehner

    Select previous row result

    Roeland Grutterink

      Hi guys,

       

      Pretty new to Tableau, so not the most difficult question I hope.

       

      I have a table like this, showing a ship's forward draft and aft draft on a given date. Now I want to calculate mean draft's, which is quite easy for the rows without nulls. But for the rows showing nulls I want to take the previous date's meandraft, see the second screenshot.

      Now:

       

      Desired:

      So far I have found the PREVIOUS_VALUE and LOOKUP functions, but they don't seem to work since I'm not using aggregates. Any ideas? Thanks.

       

      Roeland