1 Reply Latest reply on Apr 14, 2018 8:04 PM by Shinichiro Murakami

    Previous Row Value for blank or null values

    Jalal Hassan

      Hi,

       

      I have a quick question.

       

      In our database we have a table that stores modifications, on the day the modification happened.

       

      I need to build a historical dataset for something.

       

      Is it possible to display the previous row value in tableau

       

       

      Row Values.PNG

       

      This is how the data is in my query editor

       

      Query data view.PNG

       

      This is what the data looks like currently in tableau.

       

      Each row is tied to a specific product, 180,000 rows total.

       

      0=Offline

      1=Online

       

      So basically between 1 -> 0 & 1-> 1, I want to display 1 or Online.

       

      Between 0 -> 1 & 0 - > 0, I want to display 0 or Offline.