Need to show aging of tickets in a report in pivot table format

[Anubhav24]

Hi All,

I need to create a report which is in below format on task table :

This report shows aging of tasks assigned to Billing group. 

Need advice on which columns to show as column labels and which to show as row labels also how to show aging(if possible without scripting or using database views). Using database views i can use columns from task_sla table and show it, but is it possible through task table?

Thanks in advance.

[Aaron Munoz]

Maybe you can use a calculated field called Delayed of type true/false with a script like this pseudocode

if ((current.updated - current.created) > 2 days) return true
else return false