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.

[Slawek_Radziewi]

I suggest using task_sla table if you need to see aging or breached. 

From task table you won't see breached flag unless you add a new field and script it somehow. 

[Anubhav24]

Hi Slawek,

Thanks for your reply , i drilled down to the exact requirement and got to know that I just need to calculate aging based on the difference of dates between created and updated columns in task table.

Hence if the difference is greater than 2 than it is delayed else it is overdue.

Therefore , do I need to use metrics here ?

Please advise on how to achieve this.

Thanks in advance.

[Slawek_Radziewi]

You can use task or sc_task table depending what fields you want to see there. 

I can suggest using Buckets.

Start with adding bucket group like below.

Then add Breakdown Group based on Bucket.

After that add Breakdown using Breakdown Source.

Inside that breakdown please define mapping for task table using script which will calculate difference between dates like below.

When you have everything just add this breakdown to your indicator based on task table and run collector job. 

[Anubhav24]

Thanks a lot Slawek for your reply. Really Appreciate your time for answering my queries.