Performance Analytics - I see same score across all the weeks

[Shalini S1]

Hii...

In my PDI, I have created an indicator "Incidents Closed Reassigned" with indicator source cond as below. When I check the score on Indicator, its shows 2 for all the weeks. I am expecting the result to be 2 only for the March month weeks when the incidents were closed, I had run the OOTB job '[PA Incident] Historic Data Collection'.
Can someone figure out on what am I missing in the configuration.?

[Bert_c1]

How is the Indicator source defined? You don't show that. It should have a Frequency of Weekly and Conditions with "Closed" on "Last Week".

The Data collection job should run "Weekly". Create one for your indicator, and use appropriate 'Relative start interval' of "weeks ago" (1), 'Relative end interval' of "Days ago" (1). Set the 'Run' to "Weekly".

[AndersBGS]

Hi @Shalini S1 ,

If you haven't put a timespan into your conditions either on the indicator or the indicator source, the PA will act as an cumulative report, hence it will query the whole table every time the PA job run. If you instead put on "Created on last week" or similar, then you will get the scores that you which.

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

Best regards

Anders 

[Community Alums]

@AndersBGS  I am performing all this in my PDI to explore on dashboards using PA, please confirm if i have to run the job everytime when ever i add in new indicator under it? also, should we have only 1 job per indicator?

Please mention the table name where the PA Data collector 'jobs' will store the retrieved data in servicenow?

[Bert_c1]

Hi shalini7,

pa_scores is the legacy table, pa_scores_l1 (indicators) and pa_scores_l2 (breakdowns) are the current tables where score data is stored on the instance.