The filter condition '=IF( AND( [Survey].Completed = TRUE, ISBLANK(LOOKUP([_THISROW], "Survey", "Row ID", "Satisfaction Level")) OR LOOKUP([_THISROW], "Survey", "Row ID", "Satisfaction Level") <> "", ISBLANK(LOOKUP([_THISROW], "Survey", "Row ID", "Feedback")) OR LOOKUP([_THISROW], "Survey", "Row ID", "Feedback") <> "" ), "", [Ticket ID] )' of table slice 'Visible Ticket ID' must return true or false.
This is an error message that shows, but what i want is to create a slice that will hide the Ticket ID if the Survey Form was completed with the specific Ticket ID.
I see several syntax errors in your expression e.g.
[Survey].Completed which should be i guess [Survey].[Completed].
OR without () and other instances
Please correct all of them. Also the result of the expression should be a TRUE or FALSE value. In your case its either returning blank or [Ticket ID]
User | Count |
---|---|
41 | |
28 | |
25 | |
17 | |
13 |