Dear Experts, dear Forum,
my table contains three colums. Position, Arrival and Departure. Sample DATA What iam trying to calculate is the occupany time of eatch Position in a relavant timeframe which is for example from 9pm to 3am on eatch day of the year. The goal is to get a visual whitch i able to drilldown starting from total occupancy hours of the total year, than in month, day and at least the occupancy hours of that day but splittet into the Position of the day.
My approach would be to generate a new tabe with colums: Start date of relevant timewindow, Position, hours of occupany in relevant timewindow.
I already posted the issue some days ago but couldn´t find a 100% sufficiend solution: Previous Post
Thank you in advanced for your time and help
