Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
andymayo
Contributor III
Contributor III

A Persons Average Hourly Pick Rate in the Last 2 Weeks

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

EmployeeActionDateTime (Picks)WeekRegion
John Doe20/04/2020 18:12:1017North
Peter Smith20/04/2020 20:14:1017North
James Jones21/04/2020 08:10:1017South
John Doe01/05/2020 08:15:0318North
John Doe01/05/2020 09:02:2718North
Jane Doe01/05/2020 07:21:1318North
Jane Doe01/05/2020 10:21:1318North

 

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 ?

Labels (1)
0 Replies