Is there a way to add a filter to query data between two dates?

Ask the Community
4

I see. That’s an interesting one. Basically adding this where condition to the report:

    WHERE valid_from >= ${date_d}
        AND valid_to <= ${$date_d}

I need to check internally, but I think our upcoming Dynamic Models might be the solution here.

We can build a dynamic model like this, and use it to create the final report.

Model attributes_with_filter (date_d: Date) {
  type: 'query'
  
  query: @sql
    SELECT * from {{attributes}}
    WHERE valid_from >= ${date_d}
        AND valid_to <= ${$date_d}
  ;;

  dimension...
}