mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-07 07:55:13 +02:00
36 lines
763 B
YAML
36 lines
763 B
YAML
name: orders
|
|
table: public.orders
|
|
grain: [o_orderkey]
|
|
columns:
|
|
- name: o_orderkey
|
|
type: number
|
|
- name: o_custkey
|
|
type: number
|
|
- name: o_orderstatus
|
|
type: string
|
|
- name: o_totalprice
|
|
type: number
|
|
- name: o_orderdate
|
|
type: time
|
|
role: time
|
|
- name: o_orderpriority
|
|
type: string
|
|
- name: o_clerk
|
|
type: string
|
|
- name: o_shippriority
|
|
type: number
|
|
- name: o_comment
|
|
type: string
|
|
joins:
|
|
- to: customer
|
|
"on": o_custkey = customer.c_custkey
|
|
relationship: many_to_one
|
|
measures:
|
|
- name: order_count
|
|
expr: count(o_orderkey)
|
|
- name: total_price
|
|
expr: sum(o_totalprice)
|
|
description: "Total order value"
|
|
- name: avg_order_value
|
|
expr: avg(o_totalprice)
|
|
description: "Average order value"
|