Issue Monitoring Out of Range Values in Infield

I’m working on a use case for generating a list of infield tags, sorted by which ones have been outside of their range the most times in the past x amount of time. There are 2 key problems with implementing this use case:

1. When a limit is updated in Infield, the metadata for the time series in CDF is updated, but records for any past limits, and the times that those limits were modified is not stored in CDF. So I will get false values for the number of times out of range if I’m looking at any time period where the ranges were different from what they currently are. The only way then is to check all past infield reports which is laborious and seems unnecessary.
2. Text-based inputs lack any criterion indicating whether they are out of range in CDF. For some simple rounds where the in range value is “Normal” it is easy to get something working, but there are others that this doesn’t work for. Essentially despite numerical and text values being communicated to CDF, the in/out of range data represented by the green, yellow, and red tags are not communicated to CDF.