new_schema.json

{
  "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": [
    "customers.name",
    "orders.source_name",
    "orders.fulfillment_status",
    "orders.total_line_items_price",
    "refunds.total_gross_amount",
    "orders.total_net_sales",
    "orders.total_shipping_amount",
    "orders.total_tax_amount",
    "orders.total_sales_amount",
    "payout_transactions.source_type",
    "orders.tipo",
    "orders.is_out_sell_order",
    "orders.tags",
    "orders.url_boleta_28844",
    "orders.billing_address_zip",
    "orders.shipping_address_zip",
    "orders.financial_status",
    "orders.note_attributes",
    "orders.shopify_payout",
    "payouts.status",
    "transactions.x_account_id",
    "orders.source_identifier",
    "orders.processing_method",
    "payout_transactions.type",
    "transactions.x_message",
    "payout_transactions.payout_status",
    "transactions.x_gateway_reference",
    "transactions.x_auth_code",
    "transactions.x_signature",
    "fulfillments.tracking_numbers",
    "transactions.payment_details",
    "orders.billing_address_company",
    "locations.province",
    "transactions.id",
    "payout_transactions.id",
    "transactions.payment_id",
    "orders.shipping_address_company",
    "orders.quantity"
  ],
  "fieldLabels": {
    "locations.province": "Departamento de Facturacion",
    "order_items.price": "Precio por unidad",
    "order_items.product_name": "Nombre",
    "order_items.sku": "Sku",
    "order_items.total_price": "Fila Total",
    "orders.billing_address_address2": "Provincia Facturacion",
    "orders.billing_address_city": "Distrito de Facturacion",
    "orders.billing_address_company": "DNI de Facturacion",
    "orders.billing_address_first_name": "Nombre de Facturacion",
    "orders.billing_address_last_name": "Apellido de Facturacion",
    "orders.billing_address_phone": "Telephone de Envío",
    "orders.billing_address_province": "Departamento de Facturación",
    "orders.billing_address_zip": "Departamento de Facturacion",
    "orders.discount_code": "Código de cupón",
    "orders.email": "Correo electrónico",
    "orders.financial_status_customized": "Estado",
    "orders.gateway": "Metodo Pago",
    "orders.name": "Número de pedido",
    "orders.note": "Consideraciones Adicionales",
    "orders.processed_at": "Fecha",
    "orders.quantity": "Cant.",
    "orders.razon_social": "Razón Social",
    "orders.ruc": "Ruc Empresa",
    "orders.shipping_address_address": "Dirección de Envío",
    "orders.shipping_address_address2": "Provincia Envio",
    "orders.shipping_address_city": "Distrito de Envío",
    "orders.shipping_address_company": "DNI de Envío",
    "orders.shipping_address_first_name": "Nombre de Envío",
    "orders.shipping_address_last_name": "Apellido de Envío",
    "orders.shipping_address_phone": "Telephone de Facturacion",
    "orders.shipping_address_province": "Departamento de Envío",
    "orders.shipping_address_zip": "Departamento de Envío",
    "orders.shipping_method_title": "Método de Envio",
    "orders.total_discounts": "Descuento",
    "orders.total_quantity": "Cant.",
    "orders.total_shipping_price": "Importe del Envío",
    "orders.total_weight": "Peso",
    "sales.location": "Ver Tienda",
    "transactions.x_message": "Consideraciones adicionales"
  },
  "displayMode": "table",
  "visualizationType": "line",
  "toolbar": {
    "dimensions": [],
    "filters": [
      "orders.processed_at"
    ]
  },
  "visualization": {
    "graphFields": [
      "orders.total_quantity"
    ],
    "pieFields": [
      "orders.source_name",
      "orders.total_sales_amount",
      "sales.location",
      "orders.total_weight",
      "orders.total_quantity"
    ],
    "scalarFields": [],
    "cumulative": false,
    "frozenFields": [],
    "columnWidths": {}
  },
  "query": {
    "model": "shopify",
    "explore": "order_items",
    "fields": [
      "orders.name",
      "order_items.sku",
      "order_items.total_net_quantity",
      "refund_items.total_quantity",
      "orders.id",
      "locations.name",
      "orders.processed_at",
      "orders.dni_de_faturacion",
      "orders.billing_address_first_name",
      "orders.billing_address_last_name",
      "orders.billing_address_address",
      "orders.billing_address_city",
      "orders.shipping_method_title",
      "orders.billing_address_address2",
      "orders.billing_address_province",
      "orders.shipping_address_phone",
      "orders.email",
      "orders.dni_de_envio",
      "orders.shipping_address_first_name",
      "orders.shipping_address_last_name",
      "orders.ruc",
      "orders.razon_social",
      "orders.shipping_address_address",
      "orders.shipping_address_city",
      "orders.shipping_address_address2",
      "orders.shipping_address_province",
      "orders.billing_address_phone",
      "orders.total_kgs",
      "order_items.product_name",
      "orders.gateway",
      "orders.financial_status_customized",
      "orders.discount_code",
      "orders.codigo_Bebe",
      "order_items.price",
      "order_items.total_price",
      "orders.note"
    ],
    "pivotFields": [],
    "sorts": [
      {
        "field": "orders.processed_at",
        "direction": "desc"
      }
    ],
    "filter": {
      "condition": "and",
      "groups": [
        {
          "condition": "and",
          "groups": [],
          "filters": [
            {
              "field": "orders.name",
              "condition": "eq",
              "value": "#5166",
              "disabled": false,
              "group": ""
            }
          ]
        }
      ],
      "filters": [
        {
          "field": "orders.total_net_sales",
          "condition": "gt",
          "value": "0",
          "group": "",
          "disabled": false
        },
        {
          "field": "orders.financial_status_customized",
          "condition": "eq",
          "value": "Complete",
          "group": "",
          "disabled": false
        },
        {
          "field": "transactions.status",
          "condition": "eq",
          "value": "success",
          "group": "",
          "disabled": false
        },
        {
          "field": "orders.processed_at",
          "condition": "named",
          "value": "today",
          "group": "A",
          "disabled": true
        }
      ]
    },
    "parameters": [],
    "limit": 50,
    "offset": 0,
    "crossFilters": []
  },
  "meta": {
    "userDefined": true
  },
  "isShared": false
}