How to pull data together from Incident and SC Task

[Jay2k]

We recently went live on Incident and Service Catalog in Service Now, and so far the systems is great.  The next piece I need to solve is pulling metrics out of the sytem.  The first report I need to build should show all Incidents and Tasks assigned to the team and their age.  I've been unable to figure out how to combine both Incidents and Tasks in the same report to show a hollistic view of all "work" coming into the team.  Does anyone have any recommendations on how to pull this data together?

[djohnson1]

Jay2K, 

The Incident Table is an extension of the Task Table. By extension, all Incidents are Tasks. As far as the report: Navigate to Reports > View/Run > Create a Report > Provide - Name; Source Type: Table; Table: Task [task] > Select a Time Series Chart template > Group by: Assignment Group; Trend by: Created; per: *year; Aggregation: *method. 

*denotes your metric criteria

Thanks, 

Derrick Johnson

[Adam Stout]

If you are only looking at certain tasks, be sure to filter your report on Task Type which may greatly reduce the number of rows you need to report on.