30/60/90 Days Aged Ticket Report?

[ryanrussell]

Hey all,

I have searched the KB and really can't find something specific or conclusive to my needs.   I work for a small non-profit org, and I am not good with scripting.   

My Director is requesting to have an aged ticket report created for him.   I really want to do this inside ServiceNow.  If not, I will have to just do it manually in Excel.  That would be not desirable, nor efficient.

These are the requirements:

• Have 4 columns on the x-axis for all open tickets:  0-30 days open, 31-60 days open, 61-90 days open, 91+ days open.
• Have them for only one assignment group.

Is there any way to do this with what is built in to ServiceNow?   I have spent hours on forums but I hit a brick wall.   Or do I need to hire a programmer to help me out?

Thank you in advance,

Ryan

[Jaspal Singh]

Hi Ryan,

Refer link that has detailed steps as well.

[Miguel Donayre]

Hello @ryanrussell 

When you say "Have them for only one assignment group." Do you mean one report for each Assignment group or have each group represented on the chart?

I created a report that has each group represented on the graph

[ryanrussell]

That looks good.    

How do you get the range to show on the x axis?    Which chart type?

Also - I don't use tasks.   I need to run this on Incident tickets.

Don't worry about a specific assignment group.   If I can get this to work for all Open ticket (state not Resolved or Closed) I'll be fine.....

Thanks in advance.....

[ryanrussell]

I can't get Aging Level to show on 'Group by' field.....

Yeah, soon as I change the Data source to the Incident table, I lose the 'Aging Level' group by.....