secondary_calculation_rolling.sql

{%- macro default__secondary_calculation_rolling(metric_name, grain, dimensions, calc_config) %}
    {%- set calc_sql -%}
    {{ adapter.dispatch('gen_primary_metric_aggregate', 'metrics')(calc_config.aggregate, metric_name) }} over (
            {% if dimensions -%}
            partition by {{ dimensions | join(", ") }} 
            {%- endif %}
            order by date_{{grain}}
            {%- if calc_config.interval %}
            rows between {{ calc_config.interval - 1 }} preceding and current row
            {%- else %}
            rows between unbounded preceding and current row
            {%- endif %}
        )
    {%- endset %}
    {% do return (calc_sql) %}
{%- endmacro %}