Incident (Trending) Volume Over Time – SQL

This view depicts trends of created and resolved Incidents over time, grouped by month.  The count of incidents opened is determined by the Created Date of the Incident, and the count of Incidents closed is determined by the Resolution Date of the Incident.

The view is filterable by Priority and Urgency as well as a date range.  NOTE:  The values returned are the total sum for a given month, not a cumulative total over time.