Forum Discussion
Need help
Hi All, I want to calculate time spent in mm: ss on a specific task (code col) by a specific individual (user id col) and get the sum of the quantity per hour per individual per task. ...
Create a couple of dimensions from your data to build a suitable data model
Then the report writes itself.
see attached
i get that thanks, how can i calculate the weekly, daily,monthly averages for individuals and for all the users combined? Also, in percentage considering the target is 130 per hour.
You need to provide better sample data for that.