Compare previous to current year.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2017 02:31 AM
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.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2017 07:11 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2017 03:59 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2018 03:47 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2018 08:01 AM
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.