Display multiple months/years comparatively side by side in single graph

[Moedeb]

I want to display multiple months/years data side by side so it is easy to see how things are tracking this year compared to previous years.

For this example I want to show how many P1 and P2 tickets have been logged for 2019 and also 2020 month by month.

I can certainly do this as a single years data month to month and can do it manually playing around, but would like a live report that can be displayed on a dashboard and/or the Service Portal.

What I'm wanting is something like this:

I'm sure this must be pretty simple when you know how? 

[Ardish · Accepted solution]

Yes, Performance Analytics should be enabled to see that kind of trend reports

[Lylys]

Hello @Moedeb ,

I have a question about this post.

I have the same needs. 

Were you able to make this report?
And how did you do it?

Thanks a lot.

Best regards,

[Moedeb]

@Lylys unfortunately I wasn't able to do it at all with ServiceNow, we aren't going to buy an extra module for something that I'd think was pretty basic reporting really.

So back to exporting the data into Excel and using pivot tables 🙂