Making Timeline with detailed tasks

[marwen_garwachi]

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_ID	Task_Desc	Task_Start_Time	Task_End_Time	Task_Duration	Employee_ID
100	T1	6/02/2014 11:34	6/02/2014 11:36	0:02:09	1011

Any Ideas ?? 

Thanks !

[agomes1971]

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

[#3]

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]

This Thread made use of Funnel Chart:

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

[marwen_garwachi]

Thanks Mario , i'll try with it !

Best regards

Marwen