Monthly Reports showing previous months' data labelled as this months data in PA

NicolaH
Tera Contributor

Hi, 

 

I have some PA reports running on a monthly basis for an Incident Management dashboard, the report being Last months incidents created. The data is all correct but it is proving confusing to users of the report as the labelling on the widgets is showing the wrong month for the data being presented. Eg. Incidents created in November are being labelled as December's data. I have read some other posts in Servicenow discussing the same issue but I haven't found a solution to this problem from reading those posts. 

NicolaH_0-1734324889854.png

NicolaH_1-1734324960989.png

NicolaH_2-1734325012953.png

 

 

3 REPLIES 3

Tibbs
Tera Contributor

Hi, NicolaH! 

Performance Analytics is really confunsing in this part. I haved the same problem last year, and the solution is very easy.

 

In the conditions, you need to change "last month" for "this month".

I know, strange, right? You wanna show the score from last month, so this doenst make sense, but is how the PA works in ServiceNow.

 

The thing that will grap the right score for you is the PA JOB. The job is like a time machine, when you run like "start in 1 month ago" and "end 1 month ago" for exemple, the job will run your conditions like a time machine. 

So, when you run, the job will search for Incidents that was created "this month" in December. Showing the right score for open incidents in December.

 

This condition + job work for any month, so if you put "this month" and run a job that starts like in January 2024 to December 2024, the job will collect the right data/score for every month, like this:

 

Job starts 1 month ago and end 1 month ago + this month = Open incidents in December

Job starts 2 month ago and end 2 month ago + this month = Open incidents in November

 

or 

 

Job starts 3 months ago and end 1 month ago + this month = Open incidents in (December), (November), (Octuber), every score/data will be placed in the right month :).

 

I hope this help you, feel free to ask more questions, here in my company i introduce and use a lot this amazing tool that is PA!

 

Please mark my question as right, if i helped you.

 

Hugs from Brazil!

NicolaH
Tera Contributor

Thanks Tibbs, this has fixed the issue however, given the report is "last months Incidents by Severity, Domain, Service and assignment group" the front view of the report is now showing the current month to day incident count and I would like it to show the previous months count as the front view. 

The data collection job is completed daily as I need the figures to update accurately as they occur, because they often change after the month has passed. 

Any idea how to fix this? 

NicolaH_0-1736828208913.png

 

 

Thanks, 

Nicola H

Tibbs
Tera Contributor

Hi, Nicola.

 

Yes, i can help you.

 

1) In the widget configuration, go to the "Column Settings":

Tibbs_0-1737048144803.png

 

2) Then, mark the box called "Multiple scores":

Tibbs_1-1737048211041.png

 

3) Two new fields will show up for you, "Number of periods" and "Period step".

Explanation

  • Number of periods: how many days, months, years (accordlly with your indicator frequency) you wanna show? In my exemple, i wanna show only two months, so i select 2.
  • Period step: how much distance between the data you wanna show? in my exemple, i wanna show data from 2 months, and the distance is from 12 months ago. 

Tibbs_4-1737048653045.png

 

Configurating like this, my widget show data from two months (my indicator frequency is monthly), with 12 months ago of distance, so December 2023 x December 2024.

Tibbs_2-1737048613029.png

 

 

You can do this with your indicator putting like number of periods 3/6 (to show the last 3 or 6 months), and the periods step to 1, showing December 2024, November 2024 and etc.

 

One tip: with you wanna show only the previous months, but not the current, i suggest to you clean the data from the current month in the scoresheet, or create another indicator with the same conditions, but with a job that collect data until the last moth. 

 

This way, you can work with the previous and current data withou any problem in your indicators.

 

If my awnser helped you, please mark as helpfuls! 😊

 

Thanks! 

 

Tibbs, Brazil.