Hi
I have been struggling to find a way to display data about the company's staff by hour.
In 2 weeks time the company I work for is going to start on a rather big project, and I must find a way to show progress and a count of employees by date and hour, their production line and department.
The attached file has some dummy data with shift start and end, number of employees the spefic shift, and I made a simple table showing date, hour over a 2 week period of time.
I have tried a number of solutions found on the web, but I haven't found a solution yet, so I hope someone in here can help.
Thank you
Erik
I note that you started creating a data model, though am not sure if that's needed just for this purpose. In the attached file, I added a custom column with Power Query that lists all date/time stamps for each row, based on the start date/time and the number of hours. Get rid of the start and end times and expand the lists to new rows and you get the basis for a regular pivot table as shown in the first sheet. Isn't that what you need?
Hi Riny
This is exactly what I wanted - thanks a lot.
The added custom list (=List.DateTimes([#"Start date & time"],[Hours],#duration(0,1,0,0))) made all the difference.
I will remember that for other projects - so simple but at the same time very powerfull.
This was only a small part of with dummy data in the project, and that's the reason my data model was small.
Thank you
Erik
