Creating a Automated Indicator Script to Find if Completion Date is Past Due Date

agestrad
Tera Contributor

Hi all,

I am currently trying to create a Performance Analytics Dashboard with a data visualization that tells me the percentage of records that have been completed by a certain due date. I currently have this script with "print_completed_date" being the completion date, and "print_date" being the due date. 

agestrad_0-1721864243271.png

My automatic indicator currently has a daily collection job, aggregate is set to average, and the indicator source grabs all the records from this table. When I click the related link "Show Analytics Hub" or "Scores for this indicator" all my data is empty. Thoughts on how to rectify this?

Attached is the data collection job in case that's what I'm messing up, I have tried changing the date from relative to fixed and chose date ranges that should have captured some data: 

agestrad_1-1721864564558.png

 

1 REPLY 1

agestrad
Tera Contributor

Realized I'm going about this the wrong way, going to use a formula indicator.