Relative dates in custom expression

Get Help
1

Hi,

I’m trying to show a comparison of time series data like in this example:

But I don’t want to “hard code” the dates, I’m looking for something 1 week ago, 2 weeks ago etc.
Any idea how I can replace the hard coded dates with relative values here:

SumIf([Build Minutes], between([Ts], “2021-02-01”, “2021-02-28”))

Thanks

2

Hi @arbel
That’s not supported, but there’s a request open for more time manipulation in Custom Expression:
https://github.com/metabase/metabase/issues/11330 - upvote by clicking :+1: on the first post