Report to show records month by month.

NARENDRA KAMMIL
Tera Contributor

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

find_real_file.png

1 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

View solution in original post

4 REPLIES 4

JP - Kyndryl
Kilo Sage

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 find_real_file.pngon 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":

find_real_file.png

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

 

Regards.

JP

 

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

find_real_file.png

Can we do this in servicenow ?

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