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.