Performance analytics- historical data collection

[Community Alums]

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

[Mohith Devatte · Accepted solution]

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

[Community Alums]

@Mohith Devatte  thanks for the help mohith