Question

Is there a way to filter a look that shows data as of today and after?

  • 19 July 2018
  • 3 replies
  • 2466 views

Hello,



Is there a way to filter a look that shows data as of today and after? I know I can filter “is on or after” but I want it to be automated where it automatically updates the look that day and after that.



Thank you!


3 replies

Userlevel 3

Hi Mohamed,



You might be able to succeed using the ‘relative’ option and choosing, for example:


is on or after - relative - 3 - complete days ago



If not, could you maybe specify with an example of what you would like to see?



Kind regards,



Daan

Hey Daan,



Thanks for your help!



I think I figured it out.



I created a dimension named today and I create a custom filter:



dimension_group: today {

type: time

hidden: yes

timeframes: [day_of_month, month, month_num, date, raw]

sql: current_date



Custom Filter



     ${d_greenhouse_job.started_date_date} >= ${d_greenhouse_job.today_date}



This worked out perfectly.



Thanks!

Userlevel 3

Ah, in the custom filter, you can also just use ‘today’.



See: https://docs.looker.com/reference/filter-expressions

Reply