I have a table similar to below I would like to create a visualization to show (Would a bar chart be the best option?)
1. Average Hourly Pick Rate in the last 2 weeks by Employee.
2. Top 5 Employees with the average highest hourly pick rate in the last two weeks
3. Bottom 5 Employees with lower average hourly pick rate in the last two weeks
Employee | ActionDateTime (Picks) | Week | Region |
John Doe | 20/04/2020 18:12:10 | 17 | North |
Peter Smith | 20/04/2020 20:14:10 | 17 | North |
James Jones | 21/04/2020 08:10:10 | 17 | South |
John Doe | 01/05/2020 08:15:03 | 18 | North |
John Doe | 01/05/2020 09:02:27 | 18 | North |
Jane Doe | 01/05/2020 07:21:13 | 18 | North |
Jane Doe | 01/05/2020 10:21:13 | 18 | North |
I would also like to show by region.
Also there maybe odd people who only scan(pick) a couple of time a day so i would like to exclude anyone who has less than 20 scans from the analysis....any ideas @ArnadoSandoval ?