Forum Discussion
Productivity
Hi, I need to calculate productivity of my team. In the attachment you can find data set. I am struggling with formula, because every agant can start the case but other can finish it and th...
JakubBanda You can the activity per Agent (First or Last) in pivot tables or with Power Query.
Working examples in the attached workbook.
Thanks, but I also need to count the productivity in percentage
JakubBanda Which percentages would you want to see? Can you calculate them manually?
- I can, but thay can do more type of cases at one.
If i try to say correctly 🙂JakubBanda What I meant to ask is, can you calculate some of the percentages and include them in your example? What is the percentage you would like to show where. Once that is clear it can probably be calculated very easily with a formula.