Report to check backlog in a specific date.

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.