Custom expression on Icon column based on two other columns

[c p]

I have created a graphical table in spotfire

I havecolumns 'Group', 'Score', 'Pass/Fail'

I want to setup Alert Icon(Pass/Fail column) red or green circle base on Score. But pass-fail criteria is different for different groups. let say for group1 is 35%and group2 is 40%

How can I write a customer expression for this

I cannot see the Group or Score as column to select in the "Customer Expression" window. I see only Axis.Icon in the 'Column' section

I was thinking of using something like this below in the icon setting custom expression

case

WHEN [Group] = 'Group1' and [score]

[Fabian Duerr]

I think you should do the following:

Create a calculated column [PorF] that describes the current state of your groups (Pass/Fail)

Then setup two rules for your icons using 'starts with'

The result is shown here and the dxp file is attached.

(My rule in this example: If last value of a group >= 9 then Pass else Fail)

[c p]

Thanks a ton. That worked