Columns
| Column | Label | Type |
|---|
| order_date |
Order Date |
temporal |
| region |
Region |
dimension |
| channel |
Sales Channel |
dimension |
| segment |
Customer Segment |
dimension |
| product_line |
Product Line |
dimension |
| category |
Product Category |
dimension |
Metrics
| Metric | Label | Expression | Format |
|---|
| total_sales |
Total Sales |
SUM(amount) |
currency |
| total_discount |
Total Discount |
SUM(discount) |
currency |
| order_count |
Order Count |
COUNT(order_id) |
number |
| avg_order_value |
Avg Order Value |
AVG(amount) |
currency |
| units_sold |
Units Sold |
SUM(quantity) |
number |