Inflow : Total tickets raised in the week
Outflow: Total tickets closed in the week
Backlog: Incremental open ticket count required as per week
Beast mode created :
inflow: count(CASE
WHEN `status` <> 'Cancelled'
THEN `incidentid`
END)
Outflow: count(CASE
WHEN `status` = 'Closed'
THEN `incidentid`
END)
Backlog: COUNT(CASE
WHEN `status` <> 'Closed'
THEN `incidentid`
END)