6 Replies Latest reply on Sep 11, 2018 6:18 AM by Joe Schwerdtner

    Days between Dates as calculated field (Data in different rows)

    Joe Schwerdtner

      Hey Community,

       

      i want to make a Project Overview in this style:

      tableau sketch 3.png

      My problem ist, that i need to calculate the number of days between the dates. "Phase 1" of Id 1 was finished 01.01.17, "Phase 2" was finished 04.02.17. This information is located in different rows, so that i can't use simple calculated fields.

       

      The excel with the raw data is attached. Each colour in the picture represents a different Phase. Ids are not sortet by their number, but the date Phase 1 starts.

       

      Thanks for your help!

       

      Updated Data