10 Replies Latest reply on Apr 4, 2017 9:49 AM by Shinichiro Murakami

    Difference based on previous row value for unique

    Shailesh Lakkad

      I want to calculate Oil change interval for each vehicle identified by veh_no. In Excel I use formula 

       

      =IF(A2=A1,C2-C1,C2)

       

      Column D is the one with Oil change interval calculation done by above formula in excel. I want to create this calculation like Column D in Tableau ? I have attached the data.

       

      Thank you

      Shailesh