Hi - I want the user to be able to input a value in a filter in a dashboard and then apply that value within the SQL for the derived table. The problem is I need to use a LIKE statement not an exact match.
I found this example: which is a where statement with an exact match on a user’s input, I just want to convert this so the field contains the user’s input.
Essentially I am trying wanting to do something like this:
, cASE WHEN test_name LIKE ‘%concat({user_input}, ‘-control’)%’ THEN 'Control'
WHEN test_name LIKE ‘%concat({user_input}, ‘-expa’)%’ THEN 'ExpA'
ELSE 'None' end as test_variation