Dashboard Filter

hardik.pandya · August 21, 2018, 8:52am

I want “Is Contains” Filter in Dashboard How can i get that.

AndrewMBaines · August 21, 2018, 7:30pm

Here?

hardik.pandya · August 22, 2018, 3:54am

Is in Dashboard?? if Yes please suggest how can i get that.

AndrewMBaines · August 22, 2018, 6:27am

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:

jornh · August 22, 2018, 6:34am

Sneaky workaround! I see knowing SQL pays off

AndrewMBaines · August 22, 2018, 6:36am

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.