Migrate from Tableau

// Relationship: Orders ── Customers  (many-to-one)

[Order Date Only]      = DATETRUNC('day', [Created At])

[Shipped Revenue]      = SUM(IF [Status] = "shipped" THEN [Amount] END)

[Shipped Revenue %]    = SUM(IF [Status] = "shipped" THEN [Amount] END) / SUM([Amount])

// LOD: revenue per customer, independent of view grain
[Revenue per Customer] = { FIXED [Customer ID] : SUM([Amount]) }

// Table calcs (viz-context dependent)
[Running Revenue]      = RUNNING_SUM(SUM([Amount]))
[Pct of Total Revenue] = SUM([Amount]) / TOTAL(SUM([Amount]))

source: orders is conn.table('sales.orders') extend {
  primary_key: order_id
  join_one: customers is conn.table('sales.customers') on customer_id

  dimension:
    #(doc) Order date truncated to day
    order_date is created_at::date

  measure:
    #(doc) Total revenue in USD
    # currency
    total_revenue is sum(amount)

    #(doc) Revenue from shipped orders
    # currency
    shipped_revenue is sum(amount) { where: status = 'shipped' }

    #(doc) Share of revenue that shipped
    # percent
    shipped_revenue_pct is shipped_revenue / total_revenue

  view:
    #(doc) Revenue per customer (LOD FIXED equivalent — aggregate at customer grain)
    revenue_per_customer is {
      group_by: customers.customer_id
      aggregate: total_revenue
    }

    #(doc) Running revenue and percent of total by day (table-calc equivalent)
    revenue_trend is {
      group_by: order_date
      aggregate: total_revenue
      calculate:
        running_revenue is sum_cumulative(total_revenue) {
          partition_by: order_date.year
          order_by: order_date asc
        }
        pct_of_total is total_revenue / all(total_revenue)
    }
}