Let's answer this in parts:
Regarding the second option of having the threshold stored at feature level, I didn't do this because in the case of this feature class, some of the thresholds are actually when the pi_value is lower than the threshold number, so your script wouldn't work in this instance.
I think the whole idea of testing a value against a threshold is to determine if the value is low or higher and should yield in either "ok" or "warning". So this should work (in theory).
Your first option of using a dictionary has taken what I originally asked for to the next level and is perfect for what I am after. For some reason though when I enter the script like you've written it I get Execution Error:Field not Found...
Is there something missing or do I need to have a threshold entered for every object ID for this to work?
This error is likely to occur when you are trying to retrieve the threshold value for a certain ObjectID which is not included in the dictionary. Not sure if this should yield the "Execution Error:Field not Found" error.
To avoid this you could use the following code:
function TestThreshold(thresholds, oid, pi_value) {
var result = "oid not found"
for (var key in thresholds) {
if (key == oid) {
var threshold = thresholds[key];
if (pi_value > threshold) {
result = "warning";
} else {
result = "ok";
}
}
}
return result;
}
var thresholds = {"9": 1951, "10": 1749, "11": 2103};
var oid = Text($feature.OBJECTID);
var pi_value = $feature["PI_Value"];
return TestThreshold(thresholds, oid, pi_value);
