Filter a derived table based on an explore

cristian2
Participant IV

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

0 0 52
0 REPLIES 0
Top Labels in this Space
Top Solution Authors