presentment_report.json

{
  "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": [],
  "fieldLabels": {},
  "displayMode": "table",
  "visualizationType": "pie",
  "toolbar": {
    "dimensions": [],
    "filters": [
      "orders.processed_at"
    ]
  },
  "visualization": {
    "graphFields": [],
    "pieFields": [
      "orders.source_name",
      "orders.total_sales_amount"
    ],
    "scalarFields": [],
    "cumulative": false,
    "frozenFields": [],
    "columnWidths": {}
  },
  "query": {
    "model": "shopify",
    "explore": "orders",
    "fields": [
      "orders.name",
      "orders.processed_at",
      "orders.currency",
      "orders.total_line_items_price",
      "orders.total_discounts",
      "refunds.total_gross_amount",
      "orders.total_net_sales",
      "orders.total_shipping_amount",
      "orders.total_tax_amount",
      "orders.total_sales_amount",
      "orders.original_currency",
      "orders.shop_to_presentment_rate",
      "orders.total_line_items_price_presentment",
      "orders.total_discounts_presentment",
      "refunds.total_gross_amount_presentment",
      "orders.total_net_sales_presentment",
      "orders.total_shipping_amount_presentment",
      "orders.total_tax_amount_presentment",
      "orders.total_sales_amount_presentment"
    ],
    "pivotFields": [],
    "sorts": [
      {
        "field": "orders.processed_at",
        "direction": "asc"
      }
    ],
    "filter": {
      "condition": "and",
      "groups": [],
      "filters": [
        {
          "field": "orders.processed_at",
          "condition": "named",
          "value": "last30Days",
          "group": "",
          "disabled": false
        }
      ]
    },
    "parameters": [],
    "limit": 50,
    "offset": 0,
    "crossFilters": []
  },
  "meta": {
    "userDefined": true
  },
  "isShared": false
}