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!
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’.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.