Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report showing this years incidents vs last years

VikB
Giga Contributor

hey everyone,

 

I am very new to service now.

I am trying to create a time series bar chart that displays the months of the year.

Then it shows me the P1, P2 and P3 incidents that occurred per month.  This I can do.  But then I want to also show the previous year as well on the same chart.  How can I do that?  Is that possible? 

Googling tells me that there is an option called "previous period chart".  I cannot find this.

Any help would be appreciated.

 

Thanks

8 REPLIES 8

VikB
Giga Contributor

The issue is it only shows this years data, I want to show this years data next to previous years data, so that it is easy for someone to see for each month, what the delta is.  Here is a sample graph I found on the web.  I want to know is this is possible

VikB
Giga Contributor

The issue is I can only show the current years.  I want to show previous years incidents as well on the same graph.  See below,

 

SBIM_1-1671117192993.png

Is this possible?

VikB
Giga Contributor

I created a report using the following,

Source type = Table

Table = Incident

Type = Time series bar graph

I added the following filter to the created using 01/07/2024 to 01/07/2025

Shubham074
Tera Contributor

Hi VikB

 

As you have selected condition for one year time the time series will show the associated months instead for time period try condition

 

Created >> on >> last two years

 

Also under configure make sure to select (per >> month).

 

If this solves your issue, please mark my response as helpful.