Creating reports comparing previous years and this year

JLeong · ‎05-28-2020

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.

Thomas_Davis · ‎05-28-2020

@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:

View solution in original post

Jaspal Singh · ‎05-28-2020

Hi,

Did you try something as below?

JLeong · ‎05-28-2020

Hi Jaspal,

I was looking into creating a line graph. 2 lines showing each year. Right now I can only show this year.

Thomas_Davis · ‎05-28-2020

Create an additional Dataset and it will lay on top of the other that you did.

Here is a ServiceNow Doc that talks through it.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

JLeong · ‎05-28-2020

Hi Thomas,

This is an improvement!! Thanks for telling me about the dataset.

But I'm not sure if I could make the line graph on top of each other.

Do you have more suggestions?