Can you please try to see if isnull works for your case, where you change the | eval slaStats=case(((Conformance=1 AND Override!="*") OR (Override="*" AND Conformance=0)), "SLA achieved", (Override!="*" AND Conformance=0), "SLA failed", 1=1, "Other" )
as follows:
| eval slaStats=case(((Conformance=1 AND isnull(Override)) OR (NOT isnull(Override) AND Conformance=0)), "SLA achieved", (isnull(Override) AND Conformance=0), "SLA failed", 1=1, "Other" )
I have updated the brackets in the answer. Apologies for having missed it earlier.
... View more