mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-10 08:05:14 +02:00
19 lines
313 B
YAML
19 lines
313 B
YAML
|
name: orders
|
||
|
|
table: public.orders
|
||
|
|
description: Orders placed through the storefront.
|
||
|
|
grain:
|
||
|
|
- id
|
||
|
|
columns:
|
||
|
|
- name: id
|
||
|
|
type: number
|
||
|
|
- name: status
|
||
|
|
type: string
|
||
|
|
- name: amount
|
||
|
|
type: number
|
||
|
|
measures:
|
||
|
|
- name: order_count
|
||
|
|
expr: count(*)
|
||
|
|
- name: total_revenue
|
||
|
|
expr: sum(amount)
|
||
|
|
joins: []
|