Performance Analytics - Collect data for dates in future

Blair5
Tera Guru

I want to collect change records that are scheduled for the future. This is the date I want to aggregate by (Planned start date). How would I set up the indicator source? 

7 REPLIES 7

Dennis R
Tera Guru

To my knowledge, you can't collect records for the future. You could probably manually create the records in the pa_scores and pa_snapshots tables in a scheduled job, but wow, I wouldn't envy you creating that script. With more details, I could probably help if you need.

 

Dumb question, though: Could you do this by using a normal trend report instead of PA? It would give you a snapshot, but that kinda sounds more like what you're looking for, not records meeting various criteria over time.

 

Just a thought,

--Dennis R

Hi Dennis,

Yes - I think a regular report would work. However, I'm trying to see up an in-form analytic based on the current incident's CI. Would a report follow the element selected? If so, then I'll do that! 🙂 

Adam Stout
ServiceNow Employee
ServiceNow Employee

MAke sure the report is set to follow and that the dashboard breakdown is set to act as the appropriate interactive filter and it should work.

If you can get by with a report instead of PA, use a report.

I stand corrected, thanks for the info, Adam!