Hi all,
I have this view which I need to filter:
view: orders {
derived_table: {
explore_source: orders_exp {
column: date {}
column: OrderID {}
column: Product {}
filters: [v_orders.date: "before this month"]
}
}
}
I got another view with only one row with a date field. Currently not joined into the explore ‘orders_exp’.
I need to change my view above from ‘v_orders.date: “before this month”’ to something like this v_orders.date <= ‘new_date_view.date_field’.
What would be the simplest way of doing this?
Br
Cris