PowerBi Report Update
Budget: $30 – $250 USD
I have excel data that tracks the employee time. I need to create a report that shows the percentage of time that an employee's wages are recoverable (time on job) based on a period of time. If an employee charges time to a project called "Overhead", Holiday", "PTO" or "Training", then their costs are NOT recoverable.
For example, if Josh has 30 hours charged to project "The Loren" and 10 hours charged to "PTO" then he is 75% chargeable.
The report needs to have some kind of selectable tool that allows the report viewer to easily select:
1. All or some of the staff and;
2. The report duration (this week; past two weeks, this month, last month, this quarter, past quarter, etc)
The changeability calculation needs to be based on the report duration and a 40 hour per week.
When responding to this post, please provide an example of how the report would look so I know you have read this request. I will not review or respond to anyone that does not provide that sample.
thanks
For example, if Josh has 30 hours charged to project "The Loren" and 10 hours charged to "PTO" then he is 75% chargeable.
The report needs to have some kind of selectable tool that allows the report viewer to easily select:
1. All or some of the staff and;
2. The report duration (this week; past two weeks, this month, last month, this quarter, past quarter, etc)
The changeability calculation needs to be based on the report duration and a 40 hour per week.
When responding to this post, please provide an example of how the report would look so I know you have read this request. I will not review or respond to anyone that does not provide that sample.
thanks