I want to create a slice which looks at multiple conditions across the row.
I have 30 columns of data, of which 18 columns with a condition of Red or Yellow or Green.
I want the slice to only show if any of the columns in show the text Red at least once.
So if column 5 in red and all other columns are Green this would show
if column 10 & 11 is showing red this would also show
but if all columns are green or Yellow this would not show.
I have been looking through the slice categories and not seeing any example of doing this slice.
Can someone help me with this?