Hello AppSheet Community
I would like to exclude all rows from a data slice where the value for the column โR Numberโ is blank.
So I tried using a FILTER() expression to create my data slice, but AppSheet did not like that the FILTER() expression returns a list.
Then I tried using the expression ISBLANK([R Number]), but it did not remove the columns it was supposed to.
Then I tried ISBLANK([_THISROW].[R Number]) but then the slice returned absolutely nothing.
Iโm out of ideas. How do I remove the rows with a blank value for the R Number column?
Thank you AppSheet!
Please post a screenshot of the ISBLANK([R Number])
expression that didnโt work.
Please also post a screenshot of the slice configuration.
Finally, please post a screenshot of the column list (from Data >> Columns) for the table the slice is built on, including at least the R Number column.
Quote:
Row filters are a way to filter the rows in a slice. Below, you can see the expression in blue next to the โRow filter conditionโ label. This expression defines the Yes/No filter condition used by the slice. Rows that satisfy the condition are part of the slice; those that fail the condition are excluded.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |