Forum Discussion

Sven01's avatar
Sven01
Helper I
8 years ago

Need Help - calculate relevant occupancy datetime

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

1 Reply