Creating reports comparing previous years and this year

[JLeong]

Hi Guys,

We don't have Performance Analytics, could I still create a report to show the number of each task types created and closed, comparing last year and this year per month.

Thank you in advance.

[stephenrodgers]

You can do period compares pretty easily in PA, but it's trickier in Reporting.

A big part of the problem is that you're using a Time Series report, so they're never going to lay on top of each other, because they share a common chronological axis and they don't overlap.

Think of it this way: you draw a timeline for 2018 and 2019. One line will go from the beginning of 2018 to the end of 2018 and stop. The other line will go from the beginning of 2019 to the end of 2019. But since your axis is from 2018 to 2019...they don't lay on top of each other.

You can use non-time series reports with multiple datasets, but that will change the look of what you're reporting on. You can still characterize the period though. Like this:

[Jeffrey Goudsmi]

Hi Jaspal, right now I am creating reports for Asset mgm purpose. Looking at the possibilities in Reporting ServiceNow It is limited to last 2 years. I like to look a bit further, longer than 5 years. Do you know how to embed this in the report, longer than 5 years (and not fixing the date 5 years ago)?

[Thomas_Davis · Accepted solution]

@stephenrodgers is correct, they are not the same month, which makes displaying it the way you want it tough.  Although you could change the type of Trending to make it look better, maybe something like:

[JLeong]

Thank you so much, guys!!!

These are good enough for now until we get PA.

I appreciate your time.

Take care.

[Eric Levinson]

But this is not a true Year over Year chart.  Each year should be superimposed on top of each other with the same month period on the X axis and count on the Y axis.

Is there a way to get that without PA?