dbt-labs / dbt-labs/jaffle-sl-template

dim_customer lifetime spend is off

Open
#43 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
33
Forks
102
PR merge metrics
No merged PRs in 30d

Description

I'm not sure exactly what the issue is here but lifetime_spend in dim_customers looks off, see below:
image

I think we should not be referencing line_items here and only aggregating orders. Also I think we should bring the subtotal up from the seed all the way through the project so we can have full clarity on pre-tax, tax, total.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.