Weekly Hours Allocation by Employee Name

[akshay1]

I have a dataset with following details:

1. Employee Name

2. Project Name

3. Week #

4. Hours Allocated

The dataset has data for a full year, with multiple employees and multiple projects. One employee could be allocated to multiple projects at the same time (meaning they could have two rows for a week showing their allocation on project 1 and project 2)

I am looking to create a visualization which shows hours by week by project for each / all employees. Is there a standard visualization I could utilize.

Thanks in advance.

[v-piga-msft]

Hi @akshay1,

For your requirement, you may could use ALLEXCEPT function to calculate the hours.

If you still need help, please share some data sample and your desired output so that we could help further on it?

Best Regards,

Cherry

[akshay1]

I have a dataset with following fields:

1. Employee Name

2. Project Name

3. Week

4. Hours Allocated 

I need a visualization showing hours allocated by week and by project for each Employee. Is there a ready visualization I can use.