view search

Hello everybody!! in my application I have a checklist with multiple columns with enum value which makes me select 3 buttons (ok not ok n / a). in another table type view all the checks I have done on each car are displayed.
I would like to visualize in another view the cars that have at least one NOT OK control.
do you have any suggestions?
thanks as always

0 5 151
5 REPLIES 5

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Cannone_Cannone 

 

Slice ==> Row filter condition : 

IN("NOT OK",
  LIST([Check1],[Check2],[Check3], ..., [CheckN])
)

View ==> on this slice

 

๐Ÿ™‚

Hi thank you! in the formula field I already have a formula like this, [Checked on (date)]> (TODAY ()) - 15
how can I tie it to the one you suggested?

You said: "I have a checklist with multiple columns with enum value which makes me select 3 buttons (ok not ok n / a)"

Did you make a slice ? 

For reference:

Slices: The Essentials 

yes, I have already made a slice

Can you share the expression you used for your slice, and a screenshot your table structure ?

Top Labels in this Space