Report to show records month by month.

[NARENDRA KAMMIL]

Can we do some report to show records which are closed previous year and this year side by side ? 

[JP - Kyndryl]

Hi Narendra,

Sure, this can be done with a 1st report called "Closed on this year" and you add a new Dataset to this report called "Closed on last year".   

Use this icon on the 1st report to create the Dataset.

Both reports will be of type "Column" with a Trend on the Closed field and be "per month":

The 1st report will have criteria "Closed on This year" and the attached Dataset will have criteria "Closed on Last year".

Regards.

JP

[NARENDRA KAMMIL]

This is how it is showing , can we do side by side ? similar to the question ?

[NARENDRA KAMMIL]

Can we do this in servicenow ?

[JP - Kyndryl · Accepted solution]

Hi Narendra,

I now agree that my solution was not good enough for what you need.

I have no idea how you will be able to set months of 2 different years on the same chart.

May be in creating a new custom field that will contain only the Month (filled by a BR), but it may be a lot of work for such report.

Sorry about that.

Regards.

JP