Collection job parameter usage - relative for monthly reporting in Performance Analytics

[Rushabh]

I am fairly new to the PA environment and still learning. I am wondering how the data collection job works in the backend if I use below conditions in the collection parameters? 

Relative start date - 1 month ago and Relative end date: 1 day ago. 

Say I run this job 1st of January 2023. Does this condition mean the job will go collect scores from Dec 1st 2022 to December 31st 2022 (1 day ago) and  give me a sum of scores obtained each day over last 30 days? (this one seems unlikely) Or it will only collect the score for "1 day ago" i.e. Dec 31 2022 and treat it like a score for December? Ideally I want to report monthly scores.  

Any help will be appreciated. Thanks 🙂

[AndersBGS · Accepted solution]

Hi @Rushabh ,

the PA data collection will give you the score/sum of records that match your specific criteria.

so in general if you would like to report on monthly basis, I would make a filter e.g incident closed on last month and run it on first on a monthly basis.

If my answer has provided a resolution, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Rushabh]

Hi Anders, 

Thank you for your response. With your closed incident example. Should I setup my data collection job as follows: 

Relative Start Date - 1 days ago      Relative End - 1 days ago 

If the job is running on 1st of every month, it will give me the scores gathered on the last day of the previous month? 

[AndersBGS]

Hi @Rushabh ,

Yes you are absolutely correct. So it very much depends on, which data you would like to collect and how often you would like to collect it. 

You can find the documentation for data collection job here: https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/performance-analytics/task/...

If my answer has helped towards a resolution, please mark my answer as accepted solution and give a thumb up.

Best Regards

Anders 

[Rushabh]

Thank you Anders for your response. Much appreciated. 🙂