Why does the Metrics Instances have some empty ID Fields for a definition I created?

[Tom Zink]

I have a metrics definition which calculates the field value duration on demand states. Each week I get a few records in which the ID is not captured. Below is the definition:

Is there anything I can do to ensure the either the ID is captured or have the definition not capture the record if it cannot bring in the ID?

Thanks!

[Michael Fry1 · Accepted solution]

Any chance someone is deleting the record? If you delete the record the ID will show blank in the Metric.

[Tom Zink]

Yes, that is what is happening.

On a follow up note could you have a script run which takes out any records once the ID fields goes to empty?  I ask because I am unable to filter out the records based on an (empty) ID. I do not get the typical 'is empty' logical operator. 

Thanks!

[Michael Fry1]

I'm sure you could build a script but why are records being deleted? Don't delete the records, instead move to Cancelled state or some 'non-reporting' state so Metric stay intact.