Using Slice Multiple Columns with one condition

Roger_Wareham
Participant III

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?

Thanks

Solved Solved
0 2 413
1 ACCEPTED SOLUTION

Steve
Participant V

As the slice row filter:

ISNOTBLANK(
  LIST([column1], column2], ..., [columnN])
  - {"Yellow", "Green"}
)

View solution in original post

2 REPLIES 2

Steve
Participant V

As the slice row filter:

ISNOTBLANK(
  LIST([column1], column2], ..., [columnN])
  - {"Yellow", "Green"}
)

Roger_Wareham
Participant III

Steve,
So simple when you know
Thank you very much
Wonderful.

Top Labels in this Space