This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
VAR l_from_variant_name = convert(regexp_match(order_items.variant_name, '\d{2,4}'), INT) | |
VAR l_from_props = convert(case( | |
not(is_empty(json_path(order_items.properties, "#(name=""Custom Length"").value"))), json_path(order_items.properties, "#(name=""Custom Length"").value"), | |
not(is_empty(json_path(order_items.properties, "#(name=""Wunschlänge"").value"))), json_path(order_items.properties, "#(name=""Wunschlänge"").value"), | |
not(is_empty(json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"))), json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"), | |
not(is_empty(json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"))), json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"), | |
not(is_empty(json_path(order_items.properties, "#(name=""Expédié après"").value"))), json_path(order_items.properties, "#(name=""Expédié après"").value"), | |
not(is_empty(json_path(order_items.properties, "#(name=""Anpassad längd"").value"))), json_path(orde |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"tables": [ | |
{ | |
"lineageID": "07ac8872-abfa-4638-b419-2e20b6e366d6", | |
"name": "order_events", | |
"expression": "", | |
"label": "", | |
"isHidden": false, | |
"columns": [ | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"tables": [ | |
{ | |
"lineageID": "a68424b6-219b-3c06-b476-18f3e53c7128", | |
"columns": [ | |
{ | |
"lineageID": "d0f9a019-5cc9-496b-b439-4646641e5e4b", | |
"name": "proper_first_name", | |
"kind": "dimension", | |
"dataType": "", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"users":[{"id":101603246364,"first_name":"Denis","email":"den@omegacommerce.com","url":null,"im":null,"screen_name":null,"phone":null,"last_name":"Nazarenko","account_owner":true,"receive_announcements":1,"bio":null,"permissions":["applications","beacons","billing_application_charges","channels","content","content_entries_delete","content_entries_edit","content_entries_view","content_models_delete","content_models_edit","content_models_view","create_store_credit_account_transactions","custom_pixels_management","custom_pixels_view","customers","dashboard","delete_products","domains","draft_orders","create_and_edit_draft_orders","apply_discounts_to_draft_orders","mark_draft_orders_as_paid","set_payment_terms_for_draft_orders","delete_draft_orders","edit_orders","edit_private_apps","edit_product_cost","edit_product_price","edit_theme_code","gift_cards","links","locations","manage_delivery_settings","manage_inventory","manage_policies","manage_product_tags","manage_products","manage_store_credit_settings","manag |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"id": "57c5047e-0e3b-40ba-96b6-629a9fc58774", | |
"title": "Orders Detail (Customized)", | |
"group": "My Reports", | |
"description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.", | |
"tags": [ | |
"Orders", | |
"Detailed" | |
], | |
"hiddenFields": [], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"explores": [ | |
{ | |
"lineageID": "1fe426dd-c1f3-3d7c-af6b-22b233fa9aa4", | |
"relationships": [ | |
{ | |
"lineageID": "627512d3-b1fe-4024-a548-ebedcecd6258", | |
"from": "fulfillment_items.order_id", | |
"to": "orders.id" | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"id": "da269037-f62f-4836-b17d-597aedd7b655", | |
"title": "Orders Detail (Original Currency)", | |
"group": "Orders", | |
"description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.", | |
"tags": [ | |
"Orders", | |
"Detailed" | |
], | |
"hiddenFields": [], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"tables": [ | |
{ | |
"lineageID": "1f371d31-9c9b-35a7-aa8b-a58ee77911a0", | |
"columns": [ | |
{ | |
"lineageID": "4a6c4bed-37b8-40de-92c0-448e93acc389", | |
"name": "total_shipping_amount_presentment", | |
"kind": "measure", | |
"dataType": "", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"id": "009400b7-e20e-41ad-a0ba-c0f3eee75cb8", | |
"title": "pxq v4", | |
"group": "My Reports", | |
"description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.", | |
"tags": [ | |
"Orders", | |
"Detailed" | |
], | |
"hiddenFields": [ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"id": "009400b7-e20e-41ad-a0ba-c0f3eee75cb8", | |
"title": "pxq v4", | |
"group": "My Reports", | |
"description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.", | |
"tags": [ | |
"Orders", | |
"Detailed" | |
], | |
"hiddenFields": [ |
NewerOlder