I m workin on a task where I need to allow the program numbers to be entered by users dynamically. i.e, Users should enter BETWEEN 19 AND 21 OR BETWEEN 27 AND 30 OR BETWEEN 32 and 35 and I should take those numbers and display results.
For Ex, In the derived table SQL,
SELECT * FROM TABLE WHERE
age BETWEEN 19 AND 21
OR BETWEEN 27 AND 30
OR BETWEEN 32 and 35 ;
How do I achieve this in Looker? I cant use Templated filters since they are only for logical results (i.e, age =’1’ or age IN (1,2)). Can I use parameters in SQL derived table?
Can someone please help? Thanks in Advance.