question Report to show records month by month. in Developer forum

Report to show records month by month.

NARENDRA KAMMIL — Fri, 16 Sep 2022 20:08:32 GMT

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

JP - Kyndryl — Fri, 16 Sep 2022 20:37:51 GMT

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.

NARENDRA KAMMIL — Fri, 16 Sep 2022 21:22:39 GMT

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

NARENDRA KAMMIL — Mon, 19 Sep 2022 18:12:14 GMT

Can we do this in servicenow ?

JP - Kyndryl — Thu, 22 Sep 2022 21:27:04 GMT

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.