Add not in last x time period

Sometimes we may want the last 7 weeks, for example, but don’t want to include last week.

Here’s Lightdash implementing such a feature

Thanks!

Hi Olly,

Can you try the following expressions on the “matches” operator?

  • beginning until last 7 weeks
  • beginning until 7 weeks ago
  • last 7 weeks until last week
2 Likes