2 Replies Latest reply on Jan 16, 2019 4:55 AM by BI MG

    Transforming data: Create multiple rows based on date duration

    BI MG

      Hello Tableau community,


      I have a dataset that looks similar to this in a hyper file.


      In Tableau, is there a way to transform the above data into multiple rows based of the duration of their stays (checkin minus checkout) so it will look like this?


      Thank you