I am pretty new to looker. Please check if you can help me on the below
I got one main table (say Main.lkml) which holds all my data.
To accommodate a requirement which is involving complex logic, I have created a derived sql view (Derived.lkml) using the existing Main.lkml file. - The Derived sql view is working fine with out any filters. (Note: The output of the derived sql is a single number value (only 1 Column)).
Now I am trying to add filters to my dashboard which is holding looks from both the Main.lkml file and Derived.lkml File. The looks from my derived.lkml file are not getting changed with the filters that I am selecting ( I am referencing dimensions from main.lkml for my filters)
I could understand from the available lookers documents that we can use templated_filters or Parameters to achieve this. But I am not sure on how to do that.
I am able to create a parameters view and join it with the main.lkml view inside a new explore.
It would be a great help if you can help me with some query on dummy data or some examples for my better understanding.
Also please correct me if my approach is wrong