1 Reply Latest reply on Dec 17, 2015 7:54 AM by Steve Martin

    Calculate TurnAround Time

    Jagjit Singh

      Hi All,

       

      I'am trying to calculate the tenancy turnaround time using Tableau instead of doing it manually in excel as in the attached excel workbook. I'm not sure how to get Tableau to calculate the difference between the new tenancy start date and old tenancy exit date when a property is vacanted. If you refer to the formula in the excel sheet you will know what i mean.

       

      The calculation should skip the rows in yellows as marked in the worksheet as we need to do the calculation if the propcode in the row below is the same.

       

      Thanks

      Jag