2 Replies Latest reply on Oct 11, 2018 7:17 AM by Shinichiro Murakami

    Travel with Exchanges and Various Dates

    Luis Rios

      Hello all!

       

      Please see the screenshot below:

       

       

      I am working on an analysis that calculates the number of daysa person is out on travel.  The data set includes every leg of the trip, and any exchanges made against the trip.  Using the example included in the screenshot, I'd like to illustrate in a Tableau table the departure date of 10/18/18 which was not adjusted as part of the exchange, and the arrival date of 10/23/18 which is the correct date.

       

      I've used various LOD and if statement expression (individually/combined), but I cannot get the data to only give me the 10/18-10/23 date range.

       

      Any and all ideas are welcomed!