Stuck on filtering step

Hey Kristin!

I made a quick little gif in hopes that it makes the process a bit clearer.

I selected 1 month from now, but in the gif you can see where the “days from now” option is, and you could choose 60 days for that option. (My query returns no results because I don’t have any future data).

Does that gif make it a bit more clear?

Aha, then yes, this does get a bit more complicated.

There’s 2 ways to do this: One is easier, but a bit clunky, and the other is more streamlined, but a bit harder.

1. Use 2 dates to filter on. Since the default date filter addition defaults to “OR” logic instead of “AND”, we can’t just do this:
   
   which would be ideal.
   
   We can replicate that logic, though, by doing something like this:
   
   
   
   
   
   Since we also have a time timeframe, we can filter on that field as well, and select the on or after logic in one filter & the before logic in the other. This gives us the “AND” logic we’re looking for and should work.

If you don’t have another time frame available and don’t want to create one (you could just create another field in the LookML with exactly the same definition and call it date_filter or something) then you can use a feature called Custom Filters.

2. There’s a checkbox in the filters section called “Custom Filters” and when you pop it open, it brings up a text entry area. You can use Looker Expressions (https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators) in that section, which means you can create some more powerful filters. For this case, something like:

${view_name.date_field_name} > now() AND ${view_name.date_field_name} < add_days(60,now())

would work excellently, replacing view_name.date_field_name with the actual names.

I realize this is a bit complicated! You should definitely add a vote to this feature request: Relative Range filter

which would make this process super easy.

Happy to walk through this one more if you need!

Yay! Nice work 😄