MetricFlow uses a timespine table to construct cumulative metrics. By default, MetricFlow expects the timespine table to be named
metricflow_time_spine and doesn't support using a different name.
To create this table, you need to create a model in your dbt project called
metricflow_time_spine and add the following code:
You only need to include the
date_day column in the table. MetricFlow can handle broader levels of detail, but it doesn't currently support finer grains.