Platform Analytics Historical Data Collection from a Specific Date Range
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
50m ago
Hello ServiceNow Community,
I am currently working with Platform Analytics and have created several indicators. At present, historical data is being collected daily, and I understand that out of the box the historical data collection limit is controlled by a system property, which is set to 732 days by default.
However, I noticed that this value is dynamic. For example, if the collection job runs today, it retrieves data from the last 732 days from today's date. If the job runs again 10 days later, the starting point also shifts by 10 days.
My requirement is slightly different. Instead of a rolling date range, I would like to collect and maintain historical data starting from a fixed date, such as January 1, 2024, up to the current date and continue collecting data going forward.
I would appreciate guidance on the following:
- Is there a recommended approach to collect historical data from a specific static start date instead of a rolling date range?
- Are there any best practices for configuring historical data collection in Platform Analytics?
- What is the recommended or maximum value that can be configured for the historical data collection system property, considering performance and storage impacts?
Any insights, recommendations, or experiences would be greatly appreciated.
Thank you in advance!
Regards,
Nitin Gupta
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3m ago
What exactly are you collecting? Historical data is just that: historical data. It doesn't change. What's the use case that you need to collect it daily? Why not just add the uncollected data from the previous day to add it to the already collected data? Historical data collection is usually only done to have a start set of data to report on. After that the daily collection runs to collect new data.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
