Filter data

Hi community…

I tried to create view in my app to extract records values for all users according to date, so I created slice to include this data and write this expression
2X_c_c43a2d8df743829b7cb392fe27bb4f2f7a57bb7a.png
in slice as shown:

Thank you in advance.

Solved Solved
0 10 263
1 ACCEPTED SOLUTION

You’re getting an error because like I said, the FILTER part of the expression is built into the Slice functionality. The expression for a slice must return a TRUE or FALSE result. The FILTER expression returns a LIST from a table based off the provided condition.

Therefore, you cannot use FILTER in a Slice in this manner. And your Slice expression should just be [visiting date] >= (TODAY()-31), because this is what will produce a TRUE or FALSE result for if the row is to be included in the Slice.

View solution in original post

10 REPLIES 10
Top Labels in this Space