Trend viz to tackle day-of-week seasonality

Get Help
1

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.

image
image760×446 12.6 KB

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

2

Hi @danysan
It's currently not possible to have a custom lag:
Smart numbers: configurable lag · Issue #9510 · metabase/metabase · GitHub - 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:

image
image1920×707 36.6 KB

image
image1920×971 36.6 KB