Skip to content

Instantly share code, notes, and snippets.

@NazarenkoDenis

NazarenkoDenis/presentment_schema.json

Last active March 28, 2024 15:18
Show Gist options
  • Save NazarenkoDenis/a999f5558b45531a11362c1cfa48b50e to your computer and use it in GitHub Desktop.
Save NazarenkoDenis/a999f5558b45531a11362c1cfa48b50e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
presentment_schema.json
{
"tables": [
{
"lineageID": "1f371d31-9c9b-35a7-aa8b-a58ee77911a0",
"columns": [
{
"lineageID": "4a6c4bed-37b8-40de-92c0-448e93acc389",
"name": "total_shipping_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "order_adjustments.sum_x(order_adjustments.shipping_amount / orders.shop_to_presentment_rate)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
},
{
"lineageID": "0203f35e-9f8c-34a0-b813-bb5f0a401209",
"columns": [
{
"lineageID": "72c46da6-0802-47a3-ab04-0f102f8bbad6",
"name": "test",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "order_items.total_net_sales + order_items.total_tax_amount + order_items.total_shipping_price",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
},
{
"lineageID": "da2189f5-7013-34c2-a50d-bb9676477265",
"columns": [
{
"lineageID": "42f08a5a-c420-4b34-bd63-32963f250f20",
"name": "shipping_price_presentment",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": true,
"expression": "",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "40d24d6f-d5e8-48cc-b7c1-9c3f6e0ac336",
"name": "total_shipping_price_presentment",
"kind": "measure",
"dataType": "string",
"isUnique": false,
"isHidden": true,
"expression": "orders.sum_x(orders.shipping_price / orders.shop_to_presentment_rate)",
"label": "",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "17439d98-2e0f-415d-a342-76747be0b0d4",
"name": "original_currency",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": true,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "599cfb17-db57-428e-bf91-8bbdade13286",
"name": "shop_to_presentment_rate",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": true,
"expression": "",
"label": "",
"description": "",
"valueFormat": "0.00000",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "7d59a7b8-2d04-48ad-8639-3093ff31c0de",
"name": "total_line_items_price_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.sum_x(orders.gross_amount / orders.shop_to_presentment_rate)",
"label": "Gross Sales / Presentment",
"description": "The sum of all line item prices in the shop currency.",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "4a694ee9-a213-41bf-939a-5ad9beccfeda",
"name": "total_discounts_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.sum_x(orders._total_discounts / orders.shop_to_presentment_rate)",
"label": "Discounts / Presentment",
"description": "The total discounts applied to the price of the order in the shop currency.",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "3cc714c3-5000-404c-acb4-195cd4764e9a",
"name": "total_net_sales_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.total_line_items_price_presentment - orders.total_discounts_presentment - refunds.total_gross_amount_presentment",
"label": "Net Sales / Presentment",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "8654da85-f823-439d-b0df-bee6d242ed23",
"name": "total_shipping_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.total_shipping_price_presentment - order_adjustments.total_shipping_amount_presentment",
"label": "Shipping / Presentment",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "a823e6a5-b619-4854-8cb2-32756101cb0a",
"name": "total_tax_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.sum_x(orders._total_tax / orders.shop_to_presentment_rate) - refund_items.total_tax_amount_presentment",
"label": "Tax / Presentment",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "8d32def8-5087-4827-bf38-24cab6b20ff9",
"name": "total_sales_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "orders.total_net_sales_presentment + orders.total_shipping_amount_presentment + orders.total_tax_amount_presentment",
"label": "Total Sales / Presentment",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "37890c9e-f7fa-4443-b311-b1bc17f03584",
"name": "total_price_set",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": true,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {
"columns": [
{
"lineageID": "28c7acc2-51a4-4fba-ab8d-f95510bbcc05",
"name": "shipping_price_presentment",
"dataType": "float",
"sql": "COALESCE(({{ TABLE }}.total_shipping_price_set-\u003e'presentment_money'-\u003e\u003e'amount')::DECIMAL(38,4), 0)"
},
{
"lineageID": "715a6716-207b-4ce9-bd21-c27b9f7470bc",
"name": "original_currency",
"dataType": "string",
"sql": "{{ TABLE }}.total_price_set-\u003e'presentment_money'-\u003e\u003e'currency_code'"
},
{
"lineageID": "8b0da88e-bee5-482f-a0eb-16076554ba39",
"name": "total_price_set",
"dataType": "string",
"sql": ""
},
{
"lineageID": "84eec753-46b8-48fb-a7ab-be1ae3f82091",
"name": "shop_to_presentment_rate",
"dataType": "float",
"sql": "COALESCE(({{ TABLE }}.total_price_set-\u003e'shop_money'-\u003e\u003e'amount')::DECIMAL(38,4), 0) / NULLIF(COALESCE(({{ TABLE }}.total_price_set-\u003e'presentment_money'-\u003e\u003e'amount')::DECIMAL(38,4), 0), 0)"
}
]
}
},
{
"lineageID": "4892effe-4ade-3cdd-97e9-79085fecc8f7",
"columns": [
{
"lineageID": "de2f1d99-d970-4413-a609-827b27d8dae7",
"name": "total_tax_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "refund_items.sum_x(refund_items._tax_amount / orders.shop_to_presentment_rate)",
"label": "",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
},
{
"lineageID": "2ba341e1-cded-382d-9528-7c35783678dc",
"columns": [
{
"lineageID": "0f0ee627-c6bf-4541-a2af-7f2787aba5c0",
"name": "total_gross_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "(refunds._total_gross_amount_presentment - order_adjustments.sum_x(order_adjustments.amount / orders.shop_to_presentment_rate)",
"label": "Returns / Presentment",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "73158b8e-1688-4341-ad09-b26c47d7134f",
"name": "_total_gross_amount_presentment",
"kind": "measure",
"dataType": "",
"isUnique": false,
"isHidden": true,
"expression": "(refund_items.sum_x(refund_items._subtotal_amount / orders.shop_to_presentment_rate) - IF(RELATED(orders.taxes_included), refund_items.total_tax_amount_presentment, 0))",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment