1 Reply Latest reply on Apr 9, 2018 6:01 PM by Zhouyi Zhang

    Subtract Date from Previous Row fixed at Customer Level

    Victor Sanabia

      In SQL you can do a window function to get the value of the previous row and do a calculation while partitioning the data by another column.

       

      All I'm trying to do is get the date value of the previous row and find the difference. Then at an aggregate level, take the average.

       

      Can you do this in tableau as well?