how to get a listing of a table filtered by the column of another table that is not referenced to the main table.
I can do this seamlessly from SQL Server by simply creating a view, but if I add the view to appsheet, appsheet creates it as a separate table.
The question would be how can I filter the slice with the expressions in appsheet.
Here is an image with the structure of the tables.
I really know the way to create the Slices, where I am really having problems is in the creation of the formula to be able to filter and reach the objective that I mentioned above.
I donโt know if I could express myself well about the objective that I want to achieve.
Thanks a lot!
Could you explain in plain language what you want the filter to do? Iโm happy to try to help with the expression.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |