I have some KPIs and for some, beyond the target value is good while for others it's bad.
Can I do something like
comparator = '<'
value = 100
target = 200
and then go on to say
value comparator target
So that python sees this as 100 < 200
and returns True?
For context, I have a table of KPIs which follow the format:
KPI1: < 100 On Target, > 110 Action Required
KPI2: > 50 On Target, <
and I plan to loop through them and through their associated data to apply RAG ratings.