Report to check backlog in a specific date. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report to check backlog in a specific date.

Question
35
Views
0
Comments

Content

Hello everybody,

I'm trying to create a custom report to show the backlog of incidents in a specific date.

For example, I choose a range of dates, 2016/04/01 until 2016/04/26, so I found 2 incidents created and 4 solved. I'm doing this by the transactions table, like follow:

date:
date_group(transactions.created, $group_date)

 

created:
count(distinct if(transactions.trans_type = 2, incidents.i_id))

solved:
count(distinct if(transactions.trans_type = 6 & inc_statuses.type = 2, incidents.i_id))

Until here, no problems, but here is the thing, now I want to know in this range of date, these 2 incidents created, until day 26 how was him's SLAs in this range.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!