Hi All,
I have a table like below
![Capture.PNG](/legacyfs/online/159164_Capture.PNG)
I want to use a background color expression as below :If(Count({$<SEVERITY = {'1'}>} Alert_count)>0,LIGHTRED(),YELLOW())
I am getting an extra row which should not come in my understanding
![Capture.PNG](/legacyfs/online/159165_Capture.PNG)
I am not able to understand why this extra row is coming. Though the active alert count is zero its still showing red.
Also my original requirement is like
If severity =1 then red color else( if severity <>1 and Alert Count>0 ) then Yellow else white
can anyone plz help me with the background color expression.