
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2023 04:22 AM
I was facing issue in collecting historical data. Lets us consider a hr case table consist of 60 cases over a month so when i run the historical data job for all the days over the month it is updating 60 in scoresheet even the created case in on different days. Can anyone suggest me how to overcome from this problem
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2023 04:28 AM
Hello @Community Alums ,
I Understand the issue .So in your score sheet all values are displayed as 60 for all days in the month right ?
You need to put a filter called "created on today" in your automated indicator or indicator source.This will actually help your historical job in traversing the records over a month on particular days .
Every time your jobs runs "created on today " filter will be applied for all 30 days in a month and every time it goes back to collect the past data , "created on today " filter will be applied to that day in which the job is collecting the data and show the count of records or hr case created on that day and update the score sheet with the same number for that day.
Hope this helps
Mark my answer correct if this helps you
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2023 04:28 AM
Hello @Community Alums ,
I Understand the issue .So in your score sheet all values are displayed as 60 for all days in the month right ?
You need to put a filter called "created on today" in your automated indicator or indicator source.This will actually help your historical job in traversing the records over a month on particular days .
Every time your jobs runs "created on today " filter will be applied for all 30 days in a month and every time it goes back to collect the past data , "created on today " filter will be applied to that day in which the job is collecting the data and show the count of records or hr case created on that day and update the score sheet with the same number for that day.
Hope this helps
Mark my answer correct if this helps you
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-23-2023 04:50 AM
@Mohith Devatte thanks for the help mohith