8 Replies Latest reply on Jul 5, 2017 3:06 PM by Shesil Parmar

    Find number of days between status change

    Shesil Parmar

      Tableau community,

       

      I’m struggling to work out some calculation; hope you guys can assist.

       

      So I want to calculate, how many Days IDs stays Active and then how many days it stays from Active to Stopped and from there how many from Stopped to Closed and again Closed to Active .

       

      The time period starts from 01/01/2017, so for example, if the ID’s first entry is on 6/1/17 as Stopped then count as it was Active for 5 days, if its closed then count as 5 Stopped days

       

      If the status is Active only throughout the period then it should not be in the view.

       

      There are 100s of record but I have trimmed it for this example.

       

      Thank you