Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm working on a Dashboard composed of 4 big parts :
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 !
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
take a look at this recipe
Or you can use this extension object
This Thread made use of Funnel Chart:
Thanks Mario , i'll try with it !
Best regards
Marwen