topic Re: Making Timeline with detailed tasks in QlikView

Making Timeline with detailed tasks

marwen_garwachi — Wed, 07 Jan 2015 14:23:04 GMT

Hi guys,

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

Employees Arrivals, départures and pauses détails -> Ok
Calls Détails : Number of calls in/out ->Ok
BO tasks
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 !

Re: Making Timeline with detailed tasks

agomes1971 — Wed, 07 Jan 2015 14:29:07 GMT

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

Re: Making Timeline with detailed tasks

Wed, 07 Jan 2015 14:45:22 GMT

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

Re: Making Timeline with detailed tasks

jpenuliar — Wed, 07 Jan 2015 14:45:26 GMT

This Thread made use of Funnel Chart:

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

Re: Making Timeline with detailed tasks

marwen_garwachi — Wed, 07 Jan 2015 15:50:50 GMT

Thanks Mario , i'll try with it !

Best regards

Marwen