Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @Sven01
Untill now, I can only calculate the all occupancy time for each position in the relavant timeframe which is from 9pm to 3am on each day of the year.
Best Regards
Maggie
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |