Greetings. I have a sql query that is returning performance values that I have linked to a Perspective Table. I’m trying to apply conditional formatting on a column that is hidden on the table but in the dataset called “Perf Int”. On the Table.props.cells.style.backgroundColor property I’ve set the following Expression:
This is changing the background color to green which is the first value, but when it falls below 95 it remains green. I’m sure that I need to loop it through the table, and I believe I’m just calling the column heading but I’m not sure how to bridge the gap between what I’ve got and where I need it to be at. Can anyone assist?
Thank you all in advance!