Help with Dashboard filter

AppSheet AppSheet Q&A
1

Hi

I have a column in my table which represents the yield of a product vs its expected yield as a percentage.

So if there was less yielded than expected eg. 198 instead of 200 then it is reflected as 99 percent in this column.

I am trying to create a filter in a dashboard that has three buttons.

0

0

<0

And then use an ANY expression to validate what needs to be returned, but this doesn’t seem to be possible using an enum or enumlist.

Has anyone got a suggestion on how I can go about this?

2

The following may not be exactly how you envision your solution but one way to implement this is..

table FILTER: [id] , [value] : ENUM with “Less”, “On Target”, “More”

A Slice with the Row Filter Condition..

SWITCH( ANY(FILTER[value]),
 "Less", [Yield] < 1,
 "On Target", [Yield] = 1,
 "More", [Yield] > 1,
 TRUE (<- could be false if you do not want show anything initially)
)
3 Likes