Report to show up the bars side by side for opened vs Closed incidents per month for last 12 months

[RahulRAJAS]

hi 
can I create a report to show up the bars side by side for opened vs Closed incidents per month for last 12 months?

[Gaurav Rathaur]

@RahulRAJAS ,

Yes — go to Reports → Create New → Table: Incident → Type: Column, set Group by = Month (Opened/Closed Date), add Stacked = False, and use Conditions: State is Open/Closed + Last 12 months to display side-by-side bars.

If this is useful. please mark it as helpful and accept my solution....

[RahulRAJAS]

Hi Gaurav,
if I group it by state then the reports shows the current state but not the total count of tickets created on that month and total tickets closed on that month.

[Matthew_13]

Yes — ServiceNow can absolutely show side-by-side bars for Opened vs Closed incidents by month for the last year, using out-of-the-box reporting.

You can create one report that shows Opened vs Closed incidents per month for the last 12 months, displayed side by side.

Steps (high level):

1. Go to Reports → Create New

2. Table: Incident

3. Report type: Bar chart

4. Configure the report:

   • Trend by: Opened at

   • Per: Month

   • Date range: Last 12 months

5. In the Series section:

   • Add State

   • Include only:

     • Open (or Open + In Progress, depending on your definition)

     • Closed / Resolved

6. Chart settings:

   • Set bars to Grouped (side by side) instead of stacked

   • Label series clearly as Opened and Closed

This will give you:

• X-axis: Months (last 12)

• Y-axis: Incident count

• Two bars per month: Opened vs Closed

Important clarification: “Opened” vs “Closed”

You’ll need to decide what “Opened” means for your audience:

Common patterns:

• Opened = incidents created in that month

• Closed = incidents closed in that month

That usually means:

• Opened series → based on Opened at

• Closed series → based on Closed at

If you want to be very precise, you can:

• Use two reports (one trended by Opened at, one by Closed at)

• Or use a single report with careful series configuration (most teams are fine with this)

@RahulRAJAS - Please mark Solution Accepted and Thumbs Up if you found Helpful!!

[RahulRAJAS]

Hi Matthew
if I group it by state then the reports shows the current state but not the total count of tickets created on that month and total tickets closed on that month.