Breakdown of closed SCTASKs by time open report

[billy_duncan]

Hi All,

I'm attempting to report on all SCTASKS closed by my team over 12 months by month, broken down by how long the task was open. I've created the below report for this. 

The totals for the month are correct, however, the coloured breakdown of days/weeks/months seems to be calculating the time from the time the task was closed. How do I show how long the task was open?

[SAI VENKATESH]

Hi @billy_duncan 

probably you can try creating a custom field and store the value (closed date - opened date ) and use that value in the report.

in general we can use metrics to check that out . I am not sure whether you are having metrics on that particular table or not 

Thanks and Regards

sai venkatesh 

[billy_duncan · Accepted solution]

I eventually managed to do this by creating a report source.

See this KB for details: Opened vs. Closed Task Records combined in one Rep... - ServiceNow Community

Thanks.