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

[Alex Tod1]

Hi @praveen47 ,

 On the "task" table there is a field called "business duration", I think you could use it, I attach a documentation to understand how it works.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780039