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
Jan 15, 2019 6:17 AM
Good morning
there may be more than one way to solve this problem - I would use a date scaffold - at the recent conference in New Orleans there was a presentation on scaffolding - Archana Ganeshalingam and Sasha Singh can take you through the steps - not difficult be there are a number of steps - see the link Solving tough time-based problems with skeleton tables and Tableau Prep - YouTube
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim,
Thank you for this! Scaffolding definitely solves this issue.
-Felix