Need to create a report on last 7 days closed records Avarage time to close the record

[praveen47]

Hi All, 

I have one new custom table called extends to Task table, Form contain a custom 'state' field. user is asking for a report on this table.

Last 7 days closed records avarage days from state -Open to close.

can any one help me how to achive this report

Thanks, 

Praveen

[AndersBGS]

Hi @praveen47 ,

Do you have a field where you have saved the resolution time (open till close)? If yes, then you should be able to utilize the aggregation for average resolution time (like incident):

If not, then you can create the score report through performance analytics with automated indicators and a formula indicator on top.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[praveen47]

Hi @AndersBGS , 

I don't have field like avarage in my table and also not have performanace analytics Licence. Is there any other way to do this. 

Thanks, 

Praveen

[AndersBGS]

Hi @praveen47 ,

No, when you don't have performance analytics license, then you need a field on the table to store the resolution time. When you have that, then you can utilize the report designer to create an average of the field.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Anurag Tripathi]

Hi ,

Check this out

Solved: Catalog items: Average Time to Close Report - ServiceNow Community