I have below sample dataset. This dataset is for an asset being compliant or not compliant. What I need is:
If an asset is tagged as compliant for some values and non compliant for some, I need non compliant to take precedence and show it as non compliant. Right now, I am seeing all values for example for asset1.
If an asset is compliant only, it stays as Compliant.