Reports on all Tasks/Incidents resolved

[simonfurnish]

Hi,

I would like to create a report that shows me all Requests/Tasks and Incidents that have been resolved/completed by my team over the last year, so a trend report.

Is it possible to get this from the same table or will I need to create two reports to achieve this, if anyone has any examples that would be great too.

Thanks

[Adam Robbins1]

We've done this by reporting against the base Task table.  The tricky part is the States do not line up nicely across the different ticket types.  A filter could be added in to either check for Active = false or maybe Closed is not empty.  Of course this could miss some Resolved Incidents depending on how long it takes them to go to Closed.  If just certain ticket types are desired, a filter could be added in for Task type.  As an example, maybe just Incident and Catalog Tasks are desired.

Thank you,

Adam Robbins

[arielgritti]

Hi Simon

You can create a report on "task" table with this filter:

Please If I helped you, mark helpful or correct.
Thanks
Ariel

[abhishekshu]

Thanks!