Question

How to get Filter's Start and End Date From Another View?


Hi guys, hope you are doing great. I would like to know if anyone can help me with my problem, but first, I want to give you some context about it.

I have a view that comes from a table (let’s call it “view A”). This view has a complete_date dimension group and I defined a filter called filter_date for that dimension group.

Now, I want to define a new view (let’s call it “view B”) that comes from a derived table but I want to use the start and end date from filter_date which was defined in “view A”  in the sql query for that derived table.

 

Summarizing, I want to know if it’s possible to create a derived table in “view B” and use the end and start date from a filter defined in “view A”

 

I would really appreciate any help. Thanks in advance.


This topic has been closed for comments