I want “Is Contains” Filter in Dashboard How can i get that.
Here?
Is in Dashboard?? if Yes please suggest how can i get that.
I missed the bit about it being in a dashboard.
You'd need to do it using a Custom query.
For example, my query:
select * from Product p where 1=1 [[and p.ProductName like {{product}}]]
Then use % in the prompt.
This queries for all products that contain out:
1 Like
Sneaky workaround! I see knowing SQL pays off
1 Like
The problem I have is that I resort to SQL too soon without exploring the functionality of whichever product I’m using that day. Not such an issue with Metabase, but soon get sent to the naughty step when working in QlikView.
1 Like