Question

filter

  • 23 February 2021
  • 3 replies
  • 34 views

Hello i have 2 views and each view has a date field but i want to use a single date field to filter the measures of the 2 views together. I have made the join of the 2 views in my model and here is my code but the filter does not act on the foreign measure.how to filter the measures of one view from the date field of another view.

Thanks

measure: sum_total_ht {
type: sum
value_format_name: decimal_0
sql: CASE
WHEN {% condition date_filter %} CAST(${date_sales_date} AS TIMESTAMP) {% endcondition %}
THEN ${derived_table_sales.total_ht}
END ;;
}

 


3 replies

Userlevel 6
Badge

@tatuspark  is this the same as this topic: 

 ? 

 

@Dawid_Nawrot  yes, I explained again. I'm stuck on my project, if you can unblock me

@Dawid_Nawrot 

is it possible to do it on looker a filter on a date field to filter the measures of a foreign view ??????

thanks to your answer

Reply