How to show current Vs Previous year open incidents comparison in a performance analytics widget

dmi95
Tera Expert

We need to build a graph which shows the month in the x axis and the count of the incidents opened per month in y axis. We have configured the indicator and jobs to show the data correctly in the widget for the current year. Can anyone suggest how to show the previous year open incidents monthly count? We are looking for a graph similar to the below.

dmi95_0-1698847186881.png

 

Below is what we have build so far

dmi95_1-1698847217656.png

 

1 ACCEPTED SOLUTION

Hi @dmi95 ,

 

Is there populated data in the scoresheet one year back till now?

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

6 REPLIES 6

AndersBGS
Tera Patron
Tera Patron

Hi @dmi95 ,

 

Use the "previous period chart" on the PA Widget:

 

AndersBGS_0-1698847371981.png

 

AndersBGS_1-1698847542169.png

https://docs.servicenow.com/en-US/bundle/vancouver-now-intelligence/page/use/performance-analytics/r...

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS 

Yes I have tried it .I have enabled the checkbox previous period chart in my widget and below is the previous period setting.

 

dmi95_0-1698848468530.png

 

 

 

Can you suggest if the steps performed are correct? The graph still shows one line graph even after this modification.

Hi @dmi95 ,

 

Do you want to se the trend on year or month by month? In general I would set it to:

AndersBGS_0-1698848840779.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS 

Thank you for the response. The graph started showing previous year value but it is not in the line format that we require. Below is how it appears after modifying range of periods as months and number of periods as 12.

 

dmi95_0-1698849780228.png

dmi95_1-1698849813255.png

The expected graph is like above where in the dots show the count per month and the grey line indicates last year and dark green line indicates current year. For example ,We need to know how many tickets where opened in the month of Jan last year Vs the month of Jan in current year.Please let me know if you have any questions.