I have a slice that is showing rows that should be filtered out.
If I click Test next to the expression for the row filter condition, these rows display N, which should mean that they should not appear in the slice. But they still appear in the slice.
To test further, I created a virtual column with the same expression as the sliceโs filter condition. I can see right in the table view of the slice that these rows are returning false, but they show in the slice anyway. How can I troubleshoot this?
This appears to be an issue/bug with filtering a File column type. I have successfully worked around this bug by creating a new virtual column that converts the File column to a text column. Filtering against the new virtual Text column works as expected.
What if you just wrapped [File]
in TEXT()
in your row filter condition expression?
Thatโs a great idea and I hadnโt thought of it. Just tried it and it doesnโt work, though.
Iโm guessing thereโs some kind of encoding of the File column type happening on the backend before it gets evaluated against these conditions.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |