Forum Discussion
JakubBanda
Feb 05, 2021Copper Contributor
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...
Riny_van_Eekelen
Feb 05, 2021Platinum Contributor
JakubBanda You can the activity per Agent (First or Last) in pivot tables or with Power Query.
Working examples in the attached workbook.
- JakubBandaFeb 05, 2021Copper ContributorThanks, but I also need to count the productivity in percentage
- Riny_van_EekelenFeb 05, 2021Platinum Contributor
JakubBanda Which percentages would you want to see? Can you calculate them manually?
- JakubBandaFeb 05, 2021Copper ContributorI can, but thay can do more type of cases at one.
If i try to say correctly 🙂