Discussion Board for collaboration related to QlikView App Development.
I am faced with a challenge and need some help.
I have the attached data sample below which contains a record of when a particular system screen what accessed by users.
I need to create a dashboard that basically show some pattern in terms of:
- who accessed the most (frequency)
- Who spent the most time
- Hourly analysis (how often was a particular screen accessed)
- most importantly I would like to know when they access screen A what was the next screen the time gap
- Who decided to suddenly start accessing a particular screen for a period of time then stopped
- Buttons for WEEKEND/ AM/ PM/ MORNING AFTERNOON
I know this is a lot but if you can help with any line it will be much appreciated. This is for a log analysis work.