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

    Previous Row Value for blank or null values

    Jalal Hassan



      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.





      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.