Trend viz to tackle day-of-week seasonality

Hey guys,

I love the way Trend viz is designed, but our business is very sensitive to the day of the week. Tracking the previous day doesn't make much sense as we tackle with day-of-week seasonality.

Ideally, I'd love to compare the performance with the same day of the previous week. What would be the best way to do that?

image

Hi @danysan
It's currently not possible to have a custom lag:
https://github.com/metabase/metabase/issues/9510 - upvote by clicking :+1: on the first post

Though if you filter by the two dates and change granularity to Week, then you can get something like this: