Not sure if this is a potential bug or simply not doable but trying to colour format a field whilst comparing it to the expected value of another field.
ie if field 1!= field 2 then colour field 1 as red
Below was the sample in the source used:
<format type="color" field="netbox_tenant">
<colorPalette type="expression"> if (netbox_tenant!=tenant,"#53A051","#DC4E41")</colorPalette>
Result looked like below:
Those top three should be green based on logic although it appears to colour everything with the first choice colour - have tried multiple different statements (case etc) but doesn't seem to want to work.
Any ideas?
... View more