Grow makes it easy to call a custom date table in any metric. We've set up a table called _datesTable that goes back to 2013. A simple SQL query is all you need. For example:

select date from _datesTable where date(date) >= date('now', '-30 days’);

The above query will return the last 30 days and can be used in any SQL query in Edit Metric.

Did this answer your question?