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.

      01.PNG

      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?

      02.PNG

      Thank you