Compare previous to current year.

mateusz3
Mega Contributor

Hi Guys,

What is the best way to compare tickets opened in current year to the previous year? (Don't have performance analytics)

This is the report we currently run for new tickets. It is everything opened in a current month stacked by status. My manager would like to see a report that would show current year compared to the last in a similar way.

find_real_file.png

8 REPLIES 8

Josh Cooper
ServiceNow Employee
ServiceNow Employee

I wish there were a better answer, but your best bet is probably to export to Excel, in this case, until you're able to take advantage of the Jakarta features.


Not really. There are some new functionalities added like using multiple datasets in Jakarta. I have not looked into them but may be they are helpful in your case.



See: Using multiple datasets in a report


Vasanth Pandia1
Tera Contributor

Hi All,

 

Can the above requirement be achieved through Performance Analytics? If yes, can you please let me know how this can be done?

 

Regards,

Vasanth

Depending on what you're reporting on, in Performance Analytics you'd just need to pick (for Scorecards) or set (for Dashboard widgets) the time series you want to apply - for example if you pick By Year Sum+, then it'll give you the summed scores for that indicator for the previous years, as well as this partial year.  

There are a couple of challenges with the Time Series aggregations though, so you'll want to think about it logically.  I.e. you can't pick an Avg + if it's already a calculated average, or it won't be weighted properly, since it's averaging the scores.  Likewise, because it's performing arithmetic against the scores tables, you wouldn't be able to do a time series on an "Open" indicator, because if a ticket is open for multiple days, it will be counted on each day, and then those days added together.