Skip to Content
0
Former Member
May 31, 2013 at 02:46 PM

Help on creating a report on DeskIntl

24 Views

Hello all,

i'm trying to develop a report in DeskI, using a table that was created for this report.

The table in database is similar to the following table (Begin_date and End_date are of type TIMESTAMP (6) and other fields are VARCHAR(200)):

Operation_ID

Session_ID

Begin_date

End_date

Username

Operation_Context

1

10001

19/05/2013 22:05:02

20/05/2013 07:00:00

User1

OC1

2

10001

20/05/2013 11:00:00

20/05/2013 19:00:00

User1

OC1

3

15003

20/05/2013 07:00:00

20/05/2013 13:00:00

User3

OC2

4

13002

20/05/2013 01:00:00

20/05/2013 03:00:00

User3

OC3

5

10001

20/05/2013 13:00:00

20/05/2013 22:00:00

User1

OC3

With the information of the previous table, i'm trying to create a graphic that looks like the following (given example is a daily report for day 20/05/2013):

Some problems arise from this report creation:

- Timestamp handling for calculating session duration;

- Blank gaps in graph should be considered in report, as "NOT CONNECTED"

Can anyone help me on this report or please guide me to some relevant information for this case?

Thanks and best regards!!

Gustavo Nunes

Attachments

Report.jpg (42.9 kB)