Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
marwen_garwachi
Creator II
Creator II

Making Timeline with detailed tasks

Hi guys,

I'm working on a Dashboard composed of 4 big parts :

  1. Employees Arrivals, départures and pauses détails -> Ok
  2. Calls Détails : Number of calls in/out ->Ok
  3. BO tasks
  4. KPI's : AHT (average handling time) of each task

I need to combine all of this informations on one dashboard that is supposed to let me see  what the employees are doind in 8 hours of production (Calls / BO / Pauses/ Nothing).

My problem :

1.   The data is issued of differents databases (Oracle & SQL) having a different NTP servers.

2.   i need to show a Time line with all tasks of each employee. The problem is that i don't know how to do it knowing that the employee can do 2 things in the same time (talking on the phone and doing a BO task).

My data is as follows (see example attached):

Task_IDTask_DescTask_Start_TimeTask_End_TimeTask_DurationEmployee_ID
100T16/02/2014 11:346/02/2014 11:360:02:091011

Any Ideas ?? 

Thanks !

4 Replies
agomes1971
Specialist II
Specialist II

Hi,

i think the best way to represent this is with a pie chart or with a block chart because in that way you can see what is relevant during the day in the other hand you cannot see what is being done on the same time but i don't think that should be essential on the management point of view.

Regards

André Gomes

Not applicable

take a look at this recipe

Recipe for a Gantt chart

Or you can use this extension object

http://community.qlik.com/docs/DOC-3427

jpenuliar
Partner - Specialist III
Partner - Specialist III

This Thread made use of Funnel Chart:

http://community.qlik.com/message/463557#463557

marwen_garwachi
Creator II
Creator II
Author

Thanks Mario , i'll try with it !

Best regards

Marwen