I have a table of employee daily clocking record.
The table is like below. There is a column for employee ID, a column for clocking time and a column for clocking activity.
I plan to visualize these record to show a summary of all employee activities within a day with chart similar to below:
different colours stand for different activities.
How should I approach this in Qlik sense?
applicantid | Clocking | clockingreasoncode |
B0024 | 6/16/2016 8:16 | 1001 |
B0274 | 6/16/2016 8:19 | 1001 |
B0328 | 6/16/2016 8:20 | 1001 |
B0274 | 6/16/2016 9:26 | 3001 |
B0274 | 6/16/2016 9:27 | 1001 |
B0274 | 6/16/2016 9:51 | 3001 |
B0274 | 6/16/2016 10:18 | 1001 |
B0081 | 6/16/2016 10:59 | 3001 |
B0081 | 6/16/2016 11:00 | 1001 |
B0274 | 6/16/2016 11:45 | 8015 |
B0032 | 6/16/2016 11:49 | 1001 |
B0081 | 6/16/2016 12:06 | 3001 |
B0032 | 6/16/2016 12:12 | 3001 |
B0274 | 6/16/2016 12:18 | 3001 |
B0210 | 6/16/2016 13:29 | 1001 |
B0300 | 6/16/2016 13:44 | 1001 |
B0243 | 6/16/2016 13:52 | 1001 |