PA Indicator source and indicator query

[divyalakshmi]

Hi, 

We have a client requirement to create a PA widget that lists the count of past due issues in Issue management. To count past due Issue logic is active true records + due date is before today.. That is any issue which has due date in the past. 

We created an indicator source that runs in quarterly frequency with condition on sn_grc_issue table active true, due date before today, created at or before this quarter to get count on quarterly basis.. We need  quarter on quarter,  Breakdown type. 

The problem what we face is after we ran the historical job, it pulls data where due date is till September. I ran the historical job today which is oct 6th and there are records with due date as oct 2,3rd but the job pulls only till September.. When I preview the indicator resource count is correct with the above conditions but once job rans it gives count till September only.. Can someone tell me if above conditions are correct? Or guide me for the correct logic. 

Can someone help us on this? We wanted to show breakdown type widget that gives the Quarter wise past due issues.. Same issue detailed with screenshot in below post

https://www.servicenow.com/community/now-platform-forum/mismatch-between-list-view-and-dashboard-rec...

@Adam Stout Any insight?

Thanks

[divyalakshmi]

Can someone help me on this? We wanted to show breakdown type widget that gives the Quarter wise past due issues..

[Adam Stout]

Is your job set to run to 1 period ago or 0 periods ago?  1 would be the last quarter, 0 periods would be the current period.

[divyalakshmi]

@Adam Stout My Historical Job runs to pull relative start 72 months ago to relative end 0 days ago

My daily job runs to pull relative start 1 day ago to relative end 0 days ago.  Am not sure if job running period is the problem. We want to see the count in each quarter from past 5 years