{
  "version": 21,
  "sheets": [
    {
      "id": "c960176a-048b-4f9a-a326-3cc55c5fd1f2",
      "name": "Dashboard",
      "colNumber": 11,
      "rowNumber": 95,
      "rows": {
        "11": { "size": 36 },
        "29": { "size": 41 },
        "48": { "size": 39 },
        "49": { "size": 36 },
        "50": { "size": 26 },
        "51": { "size": 26 },
        "52": { "size": 26 },
        "53": { "size": 26 },
        "54": { "size": 26 },
        "55": { "size": 26 },
        "56": { "size": 26 },
        "57": { "size": 26 },
        "58": { "size": 26 },
        "59": { "size": 26 },
        "60": { "size": 26 },
        "61": { "size": 26 },
        "62": { "size": 26 },
        "63": { "size": 26 },
        "64": { "size": 26 },
        "66": { "size": 39 },
        "67": { "size": 34 },
        "68": { "size": 26 },
        "69": { "size": 26 },
        "70": { "size": 26 },
        "71": { "size": 26 },
        "72": { "size": 26 },
        "73": { "size": 26 },
        "74": { "size": 26 },
        "75": { "size": 26 },
        "76": { "size": 26 },
        "77": { "size": 26 },
        "78": { "size": 26 },
        "79": { "size": 26 },
        "80": { "size": 26 },
        "81": { "size": 26 },
        "82": { "size": 26 }
      },
      "cols": {
        "0": { "isHidden": true, "size": 40 },
        "1": { "size": 288 },
        "2": { "size": 99 },
        "3": { "size": 76 },
        "4": { "size": 65 },
        "5": { "size": 27 },
        "6": { "isHidden": true, "size": 41 },
        "7": { "size": 217 },
        "8": { "size": 92 },
        "9": { "size": 80 },
        "10": { "size": 84 }
      },
      "merges": [
        "H68:I68",
        "H69:I69",
        "H70:I70",
        "H71:I71",
        "H72:I72",
        "H73:I73",
        "H74:I74",
        "H75:I75",
        "H76:I76",
        "H77:I77",
        "H78:I78"
      ],
      "cells": {
        "A50": { "content": "#" },
        "A51": { "content": "1" },
        "A52": { "content": "2" },
        "A53": { "content": "3" },
        "A54": { "content": "4" },
        "A55": { "content": "5" },
        "A56": { "content": "6" },
        "A57": { "content": "7" },
        "A58": { "content": "8" },
        "A59": { "content": "9" },
        "A60": { "content": "10" },
        "A61": { "content": "11" },
        "A62": { "content": "12" },
        "A63": { "content": "13" },
        "A64": { "content": "14" },
        "A65": { "content": "15" },
        "A68": { "content": "#" },
        "A69": { "content": "1" },
        "A70": { "content": "2" },
        "A71": { "content": "3" },
        "A72": { "content": "4" },
        "A73": { "content": "5" },
        "A74": { "content": "6" },
        "A75": { "content": "7" },
        "A76": { "content": "8" },
        "A77": { "content": "9" },
        "A78": { "content": "10" },
        "A79": { "content": "11" },
        "A80": { "content": "12" },
        "A81": { "content": "13" },
        "A82": { "content": "14" },
        "A83": { "content": "15" },
        "B12": { "content": "=_t(\"Hourly Total Revenue\")" },
        "B30": { "content": "=_t(\"Daily Total Revenue\")" },
        "B49": { "content": "=_t(\"Top 15 Products per Margin\") " },
        "B50": { "content": "=_t(\"Product \")" },
        "B51": { "content": "=PIVOT.HEADER(6,\"#product_id\",A51)" },
        "B52": { "content": "=PIVOT.HEADER(6,\"#product_id\",A52)" },
        "B53": { "content": "=PIVOT.HEADER(6,\"#product_id\",A53)" },
        "B54": { "content": "=PIVOT.HEADER(6,\"#product_id\",A54)" },
        "B55": { "content": "=PIVOT.HEADER(6,\"#product_id\",A55)" },
        "B56": { "content": "=PIVOT.HEADER(6,\"#product_id\",A56)" },
        "B57": { "content": "=PIVOT.HEADER(6,\"#product_id\",A57)" },
        "B58": { "content": "=PIVOT.HEADER(6,\"#product_id\",A58)" },
        "B59": { "content": "=PIVOT.HEADER(6,\"#product_id\",A59)" },
        "B60": { "content": "=PIVOT.HEADER(6,\"#product_id\",A60)" },
        "B61": { "content": "=PIVOT.HEADER(6,\"#product_id\",A61)" },
        "B62": { "content": "=PIVOT.HEADER(6,\"#product_id\",A62)" },
        "B63": { "content": "=PIVOT.HEADER(6,\"#product_id\",A63)" },
        "B64": { "content": "=PIVOT.HEADER(6,\"#product_id\",A64)" },
        "B65": { "content": "=PIVOT.HEADER(6,\"#product_id\",A65)" },
        "B67": { "content": "=_t(\"Top 15 Tables per Revenue\")" },
        "B68": { "content": "=_t(\"Table\")" },
        "B69": { "content": "=PIVOT.HEADER(7,\"#table_id\",A69)" },
        "B70": { "content": "=PIVOT.HEADER(7,\"#table_id\",A70)" },
        "B71": { "content": "=PIVOT.HEADER(7,\"#table_id\",A71)" },
        "B72": { "content": "=PIVOT.HEADER(7,\"#table_id\",A72)" },
        "B73": { "content": "=PIVOT.HEADER(7,\"#table_id\",A73)" },
        "B74": { "content": "=PIVOT.HEADER(7,\"#table_id\",A74)" },
        "B75": { "content": "=PIVOT.HEADER(7,\"#table_id\",A75)" },
        "B76": { "content": "=PIVOT.HEADER(7,\"#table_id\",A76)" },
        "B77": { "content": "=PIVOT.HEADER(7,\"#table_id\",A77)" },
        "B78": { "content": "=PIVOT.HEADER(7,\"#table_id\",A78)" },
        "B79": { "content": "=PIVOT.HEADER(7,\"#table_id\",A79)" },
        "B80": { "content": "=PIVOT.HEADER(7,\"#table_id\",A80)" },
        "B81": { "content": "=PIVOT.HEADER(7,\"#table_id\",A81)" },
        "B82": { "content": "=PIVOT.HEADER(7,\"#table_id\",A82)" },
        "B83": { "content": "=PIVOT.HEADER(7,\"#table_id\",A83)" },
        "C50": { "content": "=_t(\"Quantity Sold\")" },
        "C51": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A51)"
        },
        "C52": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A52)"
        },
        "C53": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A53)"
        },
        "C54": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A54)"
        },
        "C55": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A55)"
        },
        "C56": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A56)"
        },
        "C57": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A57)"
        },
        "C58": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A58)"
        },
        "C59": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A59)"
        },
        "C60": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A60)"
        },
        "C61": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A61)"
        },
        "C62": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A62)"
        },
        "C63": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A63)"
        },
        "C64": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A64)"
        },
        "C65": {
          "content": "=PIVOT.VALUE(6,\"product_qty:sum\",\"#product_id\",A65)"
        },
        "C68": { "content": "=_t(\"Orders\")" },
        "C69": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A69)" },
        "C70": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A70)" },
        "C71": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A71)" },
        "C72": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A72)" },
        "C73": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A73)" },
        "C74": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A74)" },
        "C75": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A75)" },
        "C76": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A76)" },
        "C77": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A77)" },
        "C78": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A78)" },
        "C79": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A79)" },
        "C80": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A80)" },
        "C81": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A81)" },
        "C82": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A82)" },
        "C83": { "content": "=PIVOT.VALUE(7,\"__count\",\"#table_id\",A83)" },
        "D50": { "content": "=_t(\"Revenue\")" },
        "D51": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A51)"
        },
        "D52": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A52)"
        },
        "D53": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A53)"
        },
        "D54": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A54)"
        },
        "D55": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A55)"
        },
        "D56": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A56)"
        },
        "D57": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A57)"
        },
        "D58": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A58)"
        },
        "D59": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A59)"
        },
        "D60": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A60)"
        },
        "D61": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A61)"
        },
        "D62": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A62)"
        },
        "D63": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A63)"
        },
        "D64": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A64)"
        },
        "D65": {
          "content": "=PIVOT.VALUE(6,\"price_total:sum\",\"#product_id\",A65)"
        },
        "D68": { "content": "=_t(\"Revenue\")" },
        "D69": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A69)"
        },
        "D70": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A70)"
        },
        "D71": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A71)"
        },
        "D72": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A72)"
        },
        "D73": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A73)"
        },
        "D74": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A74)"
        },
        "D75": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A75)"
        },
        "D76": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A76)"
        },
        "D77": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A77)"
        },
        "D78": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A78)"
        },
        "D79": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A79)"
        },
        "D80": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A80)"
        },
        "D81": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A81)"
        },
        "D82": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A82)"
        },
        "D83": {
          "content": "=PIVOT.VALUE(7,\"amount_total:sum\",\"#table_id\",A83)"
        },
        "E50": { "content": "=_t(\"Margin\")" },
        "E51": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A51)"
        },
        "E52": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A52)"
        },
        "E53": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A53)"
        },
        "E54": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A54)"
        },
        "E55": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A55)"
        },
        "E56": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A56)"
        },
        "E57": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A57)"
        },
        "E58": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A58)"
        },
        "E59": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A59)"
        },
        "E60": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A60)"
        },
        "E61": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A61)"
        },
        "E62": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A62)"
        },
        "E63": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A63)"
        },
        "E64": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A64)"
        },
        "E65": {
          "content": "=PIVOT.VALUE(6,\"margin:sum\",\"#product_id\",A65)"
        },
        "E68": { "content": "=_t(\"Tip\")" },
        "E69": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A69)"
        },
        "E70": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A70)"
        },
        "E71": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A71)"
        },
        "E72": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A72)"
        },
        "E73": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A73)"
        },
        "E74": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A74)"
        },
        "E75": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A75)"
        },
        "E76": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A76)"
        },
        "E77": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A77)"
        },
        "E78": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A78)"
        },
        "E79": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A79)"
        },
        "E80": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A80)"
        },
        "E81": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A81)"
        },
        "E82": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A82)"
        },
        "E83": {
          "content": "=PIVOT.VALUE(7,\"tip_amount:sum\",\"#table_id\",A83)"
        },
        "G50": { "content": "#" },
        "G51": { "content": "1" },
        "G52": { "content": "2" },
        "G53": { "content": "3" },
        "G54": { "content": "4" },
        "G55": { "content": "5" },
        "G56": { "content": "6" },
        "G57": { "content": "7" },
        "G58": { "content": "8" },
        "G59": { "content": "9" },
        "G60": { "content": "10" },
        "G61": { "content": "11" },
        "G62": { "content": "12" },
        "G63": { "content": "13" },
        "G64": { "content": "14" },
        "G65": { "content": "15" },
        "H49": { "content": "=_t(\"Top 15 Products per Category\")" },
        "H50": { "content": "=_t(\"Category \")" },
        "H51": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G51)" },
        "H52": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G52)" },
        "H53": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G53)" },
        "H54": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G54)" },
        "H55": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G55)" },
        "H56": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G56)" },
        "H57": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G57)" },
        "H58": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G58)" },
        "H59": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G59)" },
        "H60": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G60)" },
        "H61": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G61)" },
        "H62": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G62)" },
        "H63": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G63)" },
        "H64": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G64)" },
        "H65": { "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G65)" },
        "H67": { "content": "=_t(\"Top Responsibles\")" },
        "H68": { "content": "=_t(\"Responsible\")" },
        "H69": { "content": "=PIVOT.HEADER(10,\"#user_id\",1)" },
        "H70": { "content": "=PIVOT.HEADER(10,\"#user_id\",2)" },
        "H71": { "content": "=PIVOT.HEADER(10,\"#user_id\",3)" },
        "H72": { "content": "=PIVOT.HEADER(10,\"#user_id\",4)" },
        "H73": { "content": "=PIVOT.HEADER(10,\"#user_id\",5)" },
        "H74": { "content": "=PIVOT.HEADER(10,\"#user_id\",6)" },
        "H75": { "content": "=PIVOT.HEADER(10,\"#user_id\",7)" },
        "H76": { "content": "=PIVOT.HEADER(10,\"#user_id\",8)" },
        "H77": { "content": "=PIVOT.HEADER(10,\"#user_id\",9)" },
        "H78": { "content": "=PIVOT.HEADER(10,\"#user_id\",10)" },
        "I50": { "content": "=_t(\"Product \")" },
        "I51": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G51,\"#product_id\",1)"
        },
        "I52": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G52,\"#product_id\",1)"
        },
        "I53": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G53,\"#product_id\",1)"
        },
        "I54": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G54,\"#product_id\",1)"
        },
        "I55": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G55,\"#product_id\",1)"
        },
        "I56": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G56,\"#product_id\",1)"
        },
        "I57": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G57,\"#product_id\",1)"
        },
        "I58": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G58,\"#product_id\",1)"
        },
        "I59": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G59,\"#product_id\",1)"
        },
        "I60": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G60,\"#product_id\",1)"
        },
        "I61": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G61,\"#product_id\",1)"
        },
        "I62": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G62,\"#product_id\",1)"
        },
        "I63": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G63,\"#product_id\",1)"
        },
        "I64": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G64,\"#product_id\",1)"
        },
        "I65": {
          "content": "=PIVOT.HEADER(9,\"#pos_categ_id\",G65,\"#product_id\",1)"
        },
        "J50": { "content": "=_t(\"Quantity\")" },
        "J51": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G51,\"#product_id\",1)"
        },
        "J52": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G52,\"#product_id\",1)"
        },
        "J53": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G53,\"#product_id\",1)"
        },
        "J54": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G54,\"#product_id\",1)"
        },
        "J55": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G55,\"#product_id\",1)"
        },
        "J56": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G56,\"#product_id\",1)"
        },
        "J57": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G57,\"#product_id\",1)"
        },
        "J58": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G58,\"#product_id\",1)"
        },
        "J59": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G59,\"#product_id\",1)"
        },
        "J60": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G60,\"#product_id\",1)"
        },
        "J61": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G61,\"#product_id\",1)"
        },
        "J62": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G62,\"#product_id\",1)"
        },
        "J63": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G63,\"#product_id\",1)"
        },
        "J64": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G64,\"#product_id\",1)"
        },
        "J65": {
          "content": "=PIVOT.VALUE(9,\"product_qty:sum\",\"#pos_categ_id\",G65,\"#product_id\",1)"
        },
        "J68": { "content": "=_t(\"Orders\")" },
        "J69": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",1)"
        },
        "J70": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",2)"
        },
        "J71": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",3)"
        },
        "J72": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",4)"
        },
        "J73": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",5)"
        },
        "J74": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",6)"
        },
        "J75": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",7)"
        },
        "J76": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",8)"
        },
        "J77": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",9)"
        },
        "J78": {
          "content": "=PIVOT.VALUE(10,\"order_id:count_distinct\",\"#user_id\",10)"
        },
        "K50": { "content": "=_t(\"Revenue \")" },
        "K51": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G51,\"#product_id\",1)"
        },
        "K52": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G52,\"#product_id\",1)"
        },
        "K53": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G53,\"#product_id\",1)"
        },
        "K54": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G54,\"#product_id\",1)"
        },
        "K55": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G55,\"#product_id\",1)"
        },
        "K56": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G56,\"#product_id\",1)"
        },
        "K57": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G57,\"#product_id\",1)"
        },
        "K58": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G58,\"#product_id\",1)"
        },
        "K59": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G59,\"#product_id\",1)"
        },
        "K60": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G60,\"#product_id\",1)"
        },
        "K61": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G61,\"#product_id\",1)"
        },
        "K62": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G62,\"#product_id\",1)"
        },
        "K63": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G63,\"#product_id\",1)"
        },
        "K64": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G64,\"#product_id\",1)"
        },
        "K65": {
          "content": "=PIVOT.VALUE(9,\"price_total:sum\",\"#pos_categ_id\",G65,\"#product_id\",1)"
        },
        "K68": { "content": "=_t(\"Revenue\")" },
        "K69": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",1)"
        },
        "K70": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",2)"
        },
        "K71": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",3)"
        },
        "K72": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",4)"
        },
        "K73": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",5)"
        },
        "K74": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",6)"
        },
        "K75": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",7)"
        },
        "K76": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",8)"
        },
        "K77": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",9)"
        },
        "K78": {
          "content": "=PIVOT.VALUE(10,\"price_total:sum\",\"#user_id\",10)"
        }
      },
      "styles": {
        "A50": 1,
        "A68": 1,
        "G50": 1,
        "H69:H78": 1,
        "J69:K78": 1,
        "A51:E65": 2,
        "A69:E83": 2,
        "G51:K65": 2,
        "B12": 3,
        "B30": 3,
        "B49": 3,
        "B67": 3,
        "H49": 3,
        "B50": 4,
        "B68": 4,
        "H50": 4,
        "H68": 4,
        "C50:E50": 5,
        "C68:E68": 5,
        "I50:K50": 5,
        "J68:K68": 5,
        "H67": 6
      },
      "formats": {},
      "borders": {
        "B49:E49": 1,
        "B67:E67": 1,
        "B12:K12": 1,
        "B30:K30": 1,
        "H49:K49": 1,
        "H67:K67": 1,
        "B50:E50": 2,
        "B68:E68": 2,
        "B13:K13": 2,
        "B31:K31": 2,
        "H50:K50": 2,
        "H68:K68": 2,
        "B51": 3,
        "B69": 3,
        "H51": 3,
        "I69": 3,
        "B52:B64": 4,
        "B70:B82": 4,
        "H52:H64": 4,
        "I70:I78": 4,
        "B65": 5,
        "B83": 5,
        "H65": 5,
        "C69": 6,
        "C51:D51": 6,
        "I51:J51": 6,
        "J69:K69": 6,
        "C70:C82": 7,
        "C52:D64": 7,
        "I52:J64": 7,
        "J70:J78": 7,
        "K70:K77": 7,
        "C83": 8,
        "C65:D65": 8,
        "I65:J65": 8,
        "D69": 9,
        "E51": 9,
        "K51": 9,
        "D70:D82": 10,
        "E52:E64": 10,
        "K52:K64": 10,
        "K78": 10,
        "D83": 11,
        "E65": 11,
        "K65": 11,
        "H69": 12,
        "H70:H78": 13,
        "H79:K79": 14
      },
      "conditionalFormats": [
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15726335,
            "rangeValues": "E51:E65"
          },
          "id": "69908097-d804-420a-bb1a-e7ec1024cee2",
          "ranges": ["B51:B65"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16775149,
            "rangeValues": "K51:K65"
          },
          "id": "1ba4063f-c1d3-4588-a731-6d92d66ca393",
          "ranges": ["H51:H65"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15531509,
            "rangeValues": "D69:D83"
          },
          "id": "cd2ee1d1-f7fa-4fa6-8e20-23519d360998",
          "ranges": ["B69:B83"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16708338,
            "rangeValues": "K69:K78"
          },
          "id": "acf8e638-6670-4ab2-a451-aa5455e1e9ea",
          "ranges": ["H69:H78"]
        }
      ],
      "figures": [
        {
          "id": "fdceb3b9-643f-4d30-a572-2d9b0b684f17",
          "x": 0,
          "y": 289,
          "width": 1027,
          "height": 391,
          "tag": "chart",
          "data": {
            "type": "combo",
            "dataSetsHaveTitle": true,
            "dataSets": [
              {
                "dataRange": "Data!B13:B37",
                "yAxisId": "y",
                "label": "Revenue"
              },
              {
                "dataRange": "Data!D13:D37",
                "label": "Average per order",
                "yAxisId": "y1",
                "trend": { "type": "polynomial", "order": 2, "display": false }
              }
            ],
            "legendPosition": "top",
            "labelRange": "Data!A13:A37",
            "title": { "text": "" },
            "aggregated": false,
            "axesDesign": {
              "y": { "title": { "text": "Total revenue" } },
              "y1": { "title": { "text": "Average revenue per order" } }
            },
            "showValues": false
          }
        },
        {
          "id": "1ebdd3d0-8af0-4922-9223-2da0d6ec024c",
          "x": 0,
          "y": 721,
          "width": 1029,
          "height": 416,
          "tag": "chart",
          "data": {
            "type": "combo",
            "dataSetsHaveTitle": true,
            "dataSets": [
              { "dataRange": "Data!H13:H20", "yAxisId": "y" },
              {
                "dataRange": "Data!J13:J20",
                "yAxisId": "y1",
                "label": "Average per order"
              }
            ],
            "legendPosition": "top",
            "labelRange": "Data!G13:G20",
            "title": { "text": "" },
            "aggregated": false,
            "axesDesign": {
              "y": { "title": { "text": "Total revenue" } },
              "y1": { "title": { "text": "Average revenue per order" } }
            }
          }
        },
        {
          "id": "49b3e330-3a31-4d43-9930-c42f2805c0c3",
          "x": 620,
          "y": 10,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": { "text": "#Orders", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#EFF6FF",
            "keyValue": "Data!B2",
            "humanize": false
          }
        },
        {
          "id": "d96a0fa5-e91b-455c-8004-9f39eeb09ee2",
          "x": 0,
          "y": 127,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Total revenue",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B3",
            "humanize": false
          }
        },
        {
          "id": "6b97f89c-8416-43db-a32e-d0ab5cf9051e",
          "x": 0,
          "y": 10,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Untaxed revenue",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B4",
            "humanize": false
          }
        },
        {
          "id": "cd102569-7656-4986-bf87-6e87b3ea493a",
          "x": 207,
          "y": 10,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Untaxed revenue per order",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B5",
            "humanize": false
          }
        },
        {
          "id": "7b541ea8-8f93-44f4-9626-67073e540f16",
          "x": 414,
          "y": 10,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Untaxed revenue per guest",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B7",
            "humanize": false
          }
        },
        {
          "id": "150978db-0307-4a65-a70a-e3a634dcfd48",
          "x": 620,
          "y": 127,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Discount Rate",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "keyValue": "Data!B9",
            "humanize": false
          }
        },
        {
          "id": "77f395fa-f25d-4ba8-a99d-405a99ebeef7",
          "x": 207,
          "y": 127,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Avg revenue per order",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B6",
            "humanize": false
          }
        },
        {
          "id": "87cda1aa-ba42-4865-8f56-912dd9e323a7",
          "x": 414,
          "y": 127,
          "width": 200,
          "height": 108,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#EA6175",
            "baselineColorUp": "#43C5B1",
            "baselineMode": "difference",
            "title": {
              "text": "Avg revenue per guest",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "keyValue": "Data!B8",
            "humanize": false
          }
        }
      ],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    },
    {
      "id": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
      "name": "Data",
      "colNumber": 29,
      "rowNumber": 113,
      "rows": {},
      "cols": {
        "0": { "size": 213 },
        "3": { "size": 108 },
        "6": { "size": 236 },
        "8": { "size": 121 },
        "9": { "size": 139 },
        "12": { "size": 160 }
      },
      "merges": [],
      "cells": {
        "A1": { "content": "Measure" },
        "A2": { "content": "# Orders" },
        "A3": { "content": "Total revenue" },
        "A4": { "content": "Net revenue" },
        "A5": { "content": "Average untaxed revenue per order" },
        "A6": { "content": "Average total revenue per order" },
        "A7": { "content": "Average net revenue / sitting " },
        "A8": { "content": "Average total revenue / sitting" },
        "A9": { "content": "Average discount" },
        "A12": { "content": "=_t(\"Revenue per hour\")" },
        "A13": { "content": "=_t(\"Time\")" },
        "A14": { "content": "0" },
        "A15": { "content": "1" },
        "A16": { "content": "2" },
        "A17": { "content": "3" },
        "A18": { "content": "4" },
        "A19": { "content": "5" },
        "A20": { "content": "6" },
        "A21": { "content": "7" },
        "A22": { "content": "8" },
        "A23": { "content": "9" },
        "A24": { "content": "10" },
        "A25": { "content": "11" },
        "A26": { "content": "12" },
        "A27": { "content": "13" },
        "A28": { "content": "14" },
        "A29": { "content": "15" },
        "A30": { "content": "16" },
        "A31": { "content": "17" },
        "A32": { "content": "18" },
        "A33": { "content": "19" },
        "A34": { "content": "20" },
        "A35": { "content": "21" },
        "A36": { "content": "22" },
        "A37": { "content": "23" },
        "B1": { "content": "Always" },
        "B2": { "content": "=PIVOT.VALUE(4,\"order_id:count_distinct\")" },
        "B3": { "content": "=PIVOT.VALUE(4,\"price_total:sum\")" },
        "B4": { "content": "=PIVOT.VALUE(4,\"price_subtotal_excl:sum\")" },
        "B5": { "content": "=PIVOT.VALUE(4,\"Average order w/o Tax:sum\")" },
        "B6": {
          "content": "=PIVOT.VALUE(4,\"Average total revenue per order:sum\")"
        },
        "B7": {
          "content": "=PIVOT.VALUE(5,\"Untaxed revenue per sitting:sum\")"
        },
        "B8": {
          "content": "=PIVOT.VALUE(5,\"Total revenue per sitting:sum\")"
        },
        "B9": {
          "content": "=iferror(PIVOT.VALUE(4,\"Discount / Order:sum\"))"
        },
        "B13": { "content": "=_t(\"Revenue\")" },
        "B14": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",0)"
        },
        "B15": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",1)"
        },
        "B16": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",2)"
        },
        "B17": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",3)"
        },
        "B18": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",4)"
        },
        "B19": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",5)"
        },
        "B20": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",6)"
        },
        "B21": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",7)"
        },
        "B22": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",8)"
        },
        "B23": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",9)"
        },
        "B24": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",10)"
        },
        "B25": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",11)"
        },
        "B26": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",12)"
        },
        "B27": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",13)"
        },
        "B28": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",14)"
        },
        "B29": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",15)"
        },
        "B30": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",16)"
        },
        "B31": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",17)"
        },
        "B32": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",18)"
        },
        "B33": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",19)"
        },
        "B34": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",20)"
        },
        "B35": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",21)"
        },
        "B36": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",22)"
        },
        "B37": {
          "content": "=PIVOT.VALUE(1,\"amount_total:sum\",\"date_order:hour_number\",23)"
        },
        "C13": { "content": "=_t(\"# Tables\")" },
        "C14": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A14)"
        },
        "C15": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A15)"
        },
        "C16": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A16)"
        },
        "C17": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A17)"
        },
        "C18": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A18)"
        },
        "C19": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A19)"
        },
        "C20": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A20)"
        },
        "C21": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A21)"
        },
        "C22": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A22)"
        },
        "C23": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A23)"
        },
        "C24": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A24)"
        },
        "C25": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A25)"
        },
        "C26": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A26)"
        },
        "C27": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A27)"
        },
        "C28": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A28)"
        },
        "C29": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A29)"
        },
        "C30": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A30)"
        },
        "C31": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A31)"
        },
        "C32": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A32)"
        },
        "C33": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A33)"
        },
        "C34": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A34)"
        },
        "C35": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A35)"
        },
        "C36": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A36)"
        },
        "C37": {
          "content": "=PIVOT.VALUE(1,\"__count:sum\",\"date_order:hour_number\",A37)"
        },
        "D13": { "content": "=_t(\"Average per table\")" },
        "D14": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A14)"
        },
        "D15": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A15)"
        },
        "D16": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A16)"
        },
        "D17": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A17)"
        },
        "D18": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A18)"
        },
        "D19": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A19)"
        },
        "D20": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A20)"
        },
        "D21": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A21)"
        },
        "D22": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A22)"
        },
        "D23": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A23)"
        },
        "D24": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A24)"
        },
        "D25": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A25)"
        },
        "D26": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A26)"
        },
        "D27": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A27)"
        },
        "D28": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A28)"
        },
        "D29": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A29)"
        },
        "D30": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A30)"
        },
        "D31": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A31)"
        },
        "D32": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A32)"
        },
        "D33": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A33)"
        },
        "D34": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A34)"
        },
        "D35": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A35)"
        },
        "D36": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A36)"
        },
        "D37": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A37)"
        },
        "D38": {
          "content": "=PIVOT.VALUE(1,\"Average amount per table:sum\",\"date_order:hour_number\",A38)"
        },
        "F12": { "content": "=_t(\"Revenue per day\")" },
        "F13": { "content": "=_t(\"Time\")" },
        "F14": { "content": "1" },
        "F15": { "content": "2" },
        "F16": { "content": "3" },
        "F17": { "content": "4" },
        "F18": { "content": "5" },
        "F19": { "content": "6" },
        "F20": { "content": "7" },
        "G13": { "content": "=_t(\"Day of the week\")" },
        "G14": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F14)" },
        "G15": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F15)" },
        "G16": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F16)" },
        "G17": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F17)" },
        "G18": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F18)" },
        "G19": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F19)" },
        "G20": { "content": "=PIVOT.HEADER(3,\"date_order:day_of_week\",F20)" },
        "H13": { "content": "=_t(\"Revenue\")" },
        "H14": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F14)"
        },
        "H15": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F15)"
        },
        "H16": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F16)"
        },
        "H17": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F17)"
        },
        "H18": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F18)"
        },
        "H19": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F19)"
        },
        "H20": {
          "content": "=PIVOT.VALUE(3,\"amount_total:sum\",\"date_order:day_of_week\",F20)"
        },
        "I13": { "content": "=_t(\"# Tables\")" },
        "I14": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F14)"
        },
        "I15": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F15)"
        },
        "I16": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F16)"
        },
        "I17": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F17)"
        },
        "I18": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F18)"
        },
        "I19": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F19)"
        },
        "I20": {
          "content": "=PIVOT.VALUE(3,\"__count:sum\",\"date_order:day_of_week\",F20)"
        },
        "J13": { "content": "=_t(\"Average per table\")" },
        "J14": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F14)"
        },
        "J15": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F15)"
        },
        "J16": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F16)"
        },
        "J17": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F17)"
        },
        "J18": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F18)"
        },
        "J19": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F19)"
        },
        "J20": {
          "content": "=PIVOT.VALUE(3,\"Average amount per table:sum\",\"date_order:day_of_week\",F20)"
        }
      },
      "styles": { "A1:B1": 7, "A12": 8, "F12": 8 },
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "figures": [],
      "tables": [
        {
          "range": "A13:D38",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": false,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "TableStyleMedium5"
          }
        },
        {
          "range": "F13:J20",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": false,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "TableStyleMedium5"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    }
  ],
  "styles": {
    "1": { "textColor": "#434343" },
    "2": { "textColor": "#434343", "verticalAlign": "middle" },
    "3": { "fontSize": 16, "textColor": "#01666B", "bold": true },
    "4": { "textColor": "#434343", "bold": true, "fontSize": 11 },
    "5": {
      "textColor": "#434343",
      "bold": true,
      "fontSize": 11,
      "align": "center"
    },
    "6": { "textColor": "#01666b", "fontSize": 16, "bold": true },
    "7": { "fillColor": "#01666B", "textColor": "#FFFFFF", "bold": true },
    "8": { "bold": true, "textColor": "#01666B" }
  },
  "formats": {},
  "borders": {
    "1": { "bottom": { "style": "thin", "color": "#CCCCCC" } },
    "2": { "top": { "style": "thin", "color": "#CCCCCC" } },
    "3": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "6": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "7": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "8": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "9": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "10": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "11": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "12": { "bottom": { "style": "thick", "color": "#FFFFFF" } },
    "13": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "14": { "top": { "style": "thick", "color": "#FFFFFF" } }
  },
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "mm/dd/yyyy",
      "timeFormat": "hh:mm:ss",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {
    "0005f6f8-d7c6-4629-88c2-0596dce2bdb3": {
      "type": "ODOO",
      "domain": [["config_id.module_pos_restaurant", "=", true]],
      "context": {},
      "sortedColumn": null,
      "measures": [
        {
          "id": "amount_total:sum",
          "fieldName": "amount_total",
          "aggregator": "sum"
        },
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" },
        {
          "id": "Average amount per table:sum",
          "fieldName": "Average amount per table",
          "aggregator": "sum",
          "userDefinedName": "Average amount per table",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "=IFERROR('amount_total:sum'/'__count:sum',)"
          }
        }
      ],
      "model": "pos.order",
      "columns": [],
      "rows": [
        {
          "fieldName": "date_order",
          "order": "asc",
          "granularity": "hour_number"
        }
      ],
      "name": "PoS Orders by Date (Day)",
      "actionXmlId": "point_of_sale.action_pos_pos_form",
      "formulaId": "1",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date_order",
          "type": "datetime",
          "offset": 0
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "lines.product_id.pos_categ_ids",
          "type": "many2many"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "lines.product_id.product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "e95e7842-672b-414d-9df8-d63fc9893cba": {
      "type": "ODOO",
      "domain": [["config_id.module_pos_restaurant", "=", true]],
      "context": {},
      "sortedColumn": null,
      "measures": [
        {
          "id": "amount_total:sum",
          "fieldName": "amount_total",
          "aggregator": "sum"
        },
        { "id": "__count:sum", "fieldName": "__count", "aggregator": "sum" },
        {
          "id": "Average amount per table:sum",
          "fieldName": "Average amount per table",
          "aggregator": "sum",
          "userDefinedName": "Average amount per table",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "=IFERROR('amount_total:sum'/'__count:sum',)"
          }
        }
      ],
      "model": "pos.order",
      "columns": [],
      "rows": [
        {
          "fieldName": "date_order",
          "order": "asc",
          "granularity": "day_of_week"
        }
      ],
      "name": "PoS Orders by Date (Day) (copy)",
      "actionXmlId": "point_of_sale.action_pos_pos_form",
      "formulaId": "3",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date_order",
          "type": "datetime",
          "offset": 0
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "lines.product_id.pos_categ_ids",
          "type": "many2many"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "lines.product_id.product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "f9256105-4dad-47e4-bdbd-9dc1cdf54b96": {
      "type": "ODOO",
      "domain": [
        "&",
        ["config_id.module_pos_restaurant", "=", true],
        ["state", "not in", ["cancel"]]
      ],
      "context": { "group_by": [] },
      "sortedColumn": null,
      "measures": [
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum",
          "format": ""
        },
        {
          "id": "order_id:count_distinct",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        {
          "id": "price_subtotal_excl:sum",
          "fieldName": "price_subtotal_excl",
          "aggregator": "sum",
          "format": ""
        },
        {
          "id": "total_discount:sum",
          "fieldName": "total_discount",
          "aggregator": "sum"
        },
        {
          "id": "Average order w/o Tax:sum",
          "fieldName": "Average order w/o Tax",
          "aggregator": "sum",
          "userDefinedName": "Average order w/o Tax",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "=IFERROR('price_subtotal_excl:sum'/'order_id:count_distinct',)"
          },
          "format": ""
        },
        {
          "id": "Discount / Order:sum",
          "fieldName": "Discount / Order",
          "aggregator": "sum",
          "userDefinedName": "Discount / Order",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "='total_discount:sum'/'price_total:sum'"
          },
          "format": "0.00%"
        },
        {
          "id": "Average total revenue per order:sum",
          "fieldName": "Average total revenue per order",
          "aggregator": "sum",
          "userDefinedName": "Average total revenue per order",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "=IFERROR('price_total:sum'/'order_id:count_distinct',)"
          },
          "format": ""
        }
      ],
      "model": "report.pos.order",
      "columns": [],
      "rows": [],
      "name": "Point of Sale Analysis",
      "actionXmlId": "point_of_sale.action_report_pos_order_all",
      "formulaId": "4",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date",
          "type": "datetime",
          "offset": 0
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "pos_categ_id",
          "type": "many2one"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "d360c54a-4c26-43af-9fb6-3814df165c9e": {
      "type": "ODOO",
      "domain": [
        "&",
        ["customer_count", "!=", 0],
        ["config_id.module_pos_restaurant", "=", true]
      ],
      "context": {},
      "sortedColumn": null,
      "measures": [
        {
          "id": "amount_total:sum",
          "fieldName": "amount_total",
          "aggregator": "sum"
        },
        {
          "id": "customer_count:sum",
          "fieldName": "customer_count",
          "aggregator": "sum"
        },
        {
          "id": "amount_tax:sum",
          "fieldName": "amount_tax",
          "aggregator": "sum"
        },
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "Untaxed Total:sum",
          "fieldName": "Untaxed Total",
          "aggregator": "sum",
          "userDefinedName": "Untaxed Total",
          "computedBy": {
            "sheetId": "2f23e6dd-5f3f-4ec7-9d7b-dc1b17c82f10",
            "formula": "='amount_total:sum'-'amount_tax:sum'"
          }
        },
        {
          "id": "Untaxed revenue per sitting:sum",
          "fieldName": "Untaxed revenue per sitting",
          "aggregator": "sum",
          "userDefinedName": "Untaxed revenue per sitting",
          "computedBy": {
            "sheetId": "2f23e6dd-5f3f-4ec7-9d7b-dc1b17c82f10",
            "formula": "=IFERROR('Untaxed Total:sum'/'customer_count:sum',)"
          },
          "format": ""
        },
        {
          "id": "Total revenue per sitting:sum",
          "fieldName": "Total revenue per sitting",
          "aggregator": "sum",
          "userDefinedName": "Total revenue per sitting",
          "computedBy": {
            "sheetId": "5d9c050d-2ba4-49ea-992f-142a93cad05a",
            "formula": "=IFERROR('amount_total:sum'/'customer_count:sum',)"
          },
          "format": ""
        }
      ],
      "model": "pos.order",
      "columns": [],
      "rows": [],
      "name": "PoS Orders",
      "actionXmlId": "point_of_sale.action_pos_pos_form",
      "formulaId": "5",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date_order",
          "type": "datetime",
          "offset": 0
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "lines.product_id.pos_categ_ids",
          "type": "many2many"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "lines.product_id.product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "15d132ec-7f1b-4f5a-99c0-14c696423a56": {
      "type": "ODOO",
      "domain": [["config_id.module_pos_restaurant", "=", true]],
      "context": { "group_by": [] },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "margin",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        {
          "id": "order_id:count_distinct",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        {
          "id": "product_qty:sum",
          "fieldName": "product_qty",
          "aggregator": "sum"
        },
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum",
          "format": ""
        },
        {
          "id": "margin:sum",
          "fieldName": "margin",
          "aggregator": "sum",
          "format": ""
        }
      ],
      "model": "report.pos.order",
      "columns": [],
      "rows": [{ "fieldName": "product_id" }],
      "name": "Point of Sale Analysis by Product",
      "actionXmlId": "point_of_sale.action_report_pos_order_all",
      "formulaId": "6",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date",
          "type": "datetime"
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "pos_categ_id",
          "type": "many2one"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "2ada09e2-9b25-41c4-96b9-f3d7f077e5cf": {
      "type": "ODOO",
      "domain": [["config_id.module_pos_restaurant", "=", true]],
      "context": {
        "params": {
          "debug": 1,
          "actionStack": [
            {
              "displayName": "Orders",
              "action": "pos-orders",
              "view_type": "pivot"
            }
          ],
          "action": "pos-orders",
          "view_type": "pivot",
          "globalState": {
            "useSampleModel": false,
            "searchModel": "{\"nextGroupId\":14,\"nextGroupNumber\":15,\"nextId\":22,\"query\":[],\"searchItems\":{\"1\":{\"type\":\"field\",\"fieldName\":\"name\",\"fieldType\":\"char\",\"description\":\"Order Ref\",\"groupId\":1,\"id\":1},\"2\":{\"type\":\"field\",\"fieldName\":\"pos_reference\",\"fieldType\":\"char\",\"description\":\"Receipt Number\",\"groupId\":2,\"id\":2},\"3\":{\"type\":\"field\",\"fieldName\":\"date_order\",\"fieldType\":\"datetime\",\"description\":\"Date\",\"groupId\":3,\"id\":3},\"4\":{\"type\":\"field\",\"fieldName\":\"tracking_number\",\"fieldType\":\"char\",\"description\":\"Order Number\",\"groupId\":4,\"id\":4},\"5\":{\"type\":\"field\",\"fieldName\":\"cashier\",\"fieldType\":\"char\",\"description\":\"Cashier name\",\"groupId\":5,\"id\":5},\"6\":{\"type\":\"field\",\"fieldName\":\"partner_id\",\"fieldType\":\"many2one\",\"description\":\"Customer\",\"groupId\":6,\"id\":6},\"7\":{\"type\":\"field\",\"fieldName\":\"session_id\",\"fieldType\":\"many2one\",\"description\":\"Session\",\"groupId\":7,\"id\":7},\"8\":{\"type\":\"field\",\"fieldName\":\"config_id\",\"fieldType\":\"many2one\",\"description\":\"Point of Sale\",\"groupId\":8,\"id\":8},\"9\":{\"type\":\"field\",\"filterDomain\":\"[('lines.product_id', 'ilike', self)]\",\"fieldName\":\"lines\",\"fieldType\":\"one2many\",\"description\":\"Product\",\"groupId\":9,\"id\":9},\"10\":{\"type\":\"filter\",\"domain\":\"[('state', '=', 'invoiced')]\",\"groupNumber\":10,\"name\":\"invoiced\",\"description\":\"Invoiced\",\"groupId\":10,\"id\":10},\"11\":{\"type\":\"filter\",\"domain\":\"[('state', '=', 'done')]\",\"groupNumber\":10,\"name\":\"posted\",\"description\":\"Posted\",\"groupId\":10,\"id\":11},\"12\":{\"type\":\"filter\",\"domain\":\"[('state', '=', 'cancel')]\",\"groupNumber\":10,\"name\":\"cancelled\",\"description\":\"Cancelled\",\"groupId\":10,\"id\":12},\"13\":{\"type\":\"dateFilter\",\"fieldName\":\"date_order\",\"fieldType\":\"datetime\",\"defaultGeneratorIds\":[\"month\"],\"optionsParams\":{\"startYear\":-2,\"endYear\":0,\"startMonth\":-2,\"endMonth\":0,\"customOptions\":[]},\"domain\":\"[]\",\"groupNumber\":12,\"name\":\"order_date\",\"description\":\"Order Date\",\"groupId\":11,\"id\":13},\"14\":{\"type\":\"groupBy\",\"fieldName\":\"session_id\",\"fieldType\":\"many2one\",\"groupNumber\":14,\"name\":\"session\",\"description\":\"Session\",\"groupId\":12,\"id\":14},\"15\":{\"type\":\"groupBy\",\"fieldName\":\"cashier\",\"fieldType\":\"char\",\"groupNumber\":14,\"name\":\"by_cashier\",\"description\":\"Cashier\",\"groupId\":12,\"id\":15},\"16\":{\"type\":\"groupBy\",\"fieldName\":\"config_id\",\"fieldType\":\"many2one\",\"groupNumber\":14,\"name\":\"config_id\",\"description\":\"Point of Sale\",\"groupId\":12,\"id\":16},\"17\":{\"type\":\"groupBy\",\"fieldName\":\"partner_id\",\"fieldType\":\"many2one\",\"groupNumber\":14,\"name\":\"customer\",\"description\":\"Customer\",\"groupId\":12,\"id\":17},\"18\":{\"type\":\"groupBy\",\"fieldName\":\"state\",\"fieldType\":\"selection\",\"groupNumber\":14,\"name\":\"status\",\"description\":\"Status\",\"groupId\":12,\"id\":18},\"19\":{\"type\":\"dateGroupBy\",\"fieldName\":\"date_order\",\"fieldType\":\"datetime\",\"defaultIntervalId\":\"month\",\"groupNumber\":14,\"name\":\"order_month\",\"description\":\"Order Date\",\"groupId\":12,\"id\":19},\"20\":{\"type\":\"comparison\",\"comparisonOptionId\":\"previous_period\",\"description\":\"Order Date: Previous Period\",\"dateFilterId\":13,\"groupId\":13,\"id\":20},\"21\":{\"type\":\"comparison\",\"comparisonOptionId\":\"previous_year\",\"description\":\"Order Date: Previous Year\",\"dateFilterId\":13,\"groupId\":13,\"id\":21}},\"searchPanelInfo\":{\"className\":\"\",\"fold\":false,\"viewTypes\":[\"kanban\",\"list\"],\"loaded\":false,\"shouldReload\":true},\"sections\":[]}"
          }
        }
      },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "amount_total",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        {
          "id": "amount_total:sum",
          "fieldName": "amount_total",
          "aggregator": "sum",
          "format": ""
        },
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "tip_amount:sum",
          "fieldName": "tip_amount",
          "aggregator": "sum",
          "format": ""
        }
      ],
      "model": "pos.order",
      "columns": [],
      "rows": [{ "fieldName": "table_id" }],
      "name": "PoS Orders by Table",
      "actionXmlId": "point_of_sale.action_pos_pos_form",
      "formulaId": "7",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date_order",
          "type": "datetime"
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "lines.product_id.pos_categ_ids",
          "type": "many2many"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "lines.product_id.product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "46b474b9-dc26-424c-b423-ac9209ba9899": {
      "type": "ODOO",
      "domain": [["config_id.module_pos_restaurant", "=", true]],
      "context": { "group_by": [] },
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "price_total",
        "order": "desc",
        "originIndexes": [0]
      },
      "measures": [
        {
          "id": "order_id:count_distinct",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        {
          "id": "product_qty:sum",
          "fieldName": "product_qty",
          "aggregator": "sum"
        },
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum",
          "format": ""
        }
      ],
      "model": "report.pos.order",
      "columns": [],
      "rows": [{ "fieldName": "pos_categ_id" }, { "fieldName": "product_id" }],
      "name": "Point of Sale Analysis by Point of Sale Category",
      "actionXmlId": "point_of_sale.action_report_pos_order_all",
      "formulaId": "9",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date",
          "type": "datetime"
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "pos_categ_id",
          "type": "many2one"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    },
    "bc1df90b-fa7e-417a-868c-5f48e0e20349": {
      "type": "ODOO",
      "domain": [
        "&",
        "&",
        ["user_id", "!=", false],
        ["state", "in", ["paid", "done", "invoiced"]],
        ["config_id.module_pos_restaurant", "=", true]
      ],
      "context": { "group_by": [] },
      "sortedColumn": null,
      "measures": [
        {
          "id": "order_id:count_distinct",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum",
          "format": ""
        }
      ],
      "model": "report.pos.order",
      "columns": [],
      "rows": [{ "fieldName": "user_id" }],
      "name": "Point of Sale Analysis by User",
      "actionXmlId": "point_of_sale.action_report_pos_order_all",
      "formulaId": "10",
      "fieldMatching": {
        "4b44fd69-5c22-4402-be22-636d52226a76": {
          "chain": "date",
          "type": "datetime"
        },
        "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d": {
          "chain": "pos_categ_id",
          "type": "many2one"
        },
        "6cb73c89-2591-456e-a7bc-8eb76e321b9e": {
          "chain": "product_tmpl_id",
          "type": "many2one"
        },
        "7674d2c1-e82b-4199-a991-6fae2268676b": {
          "chain": "employee_id",
          "type": "many2one"
        }
      }
    }
  },
  "pivotNextId": 11,
  "customTableStyles": {},
  "odooVersion": 12,
  "globalFilters": [
    {
      "id": "4b44fd69-5c22-4402-be22-636d52226a76",
      "type": "date",
      "label": "Date",
      "rangeType": "from_to",
      "disabledPeriods": []
    },
    {
      "id": "31b1d5d4-6549-4dbe-9c8e-57d6e6e0889d",
      "type": "relation",
      "label": "Product Category",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "pos.category",
      "includeChildren": false
    },
    {
      "id": "6cb73c89-2591-456e-a7bc-8eb76e321b9e",
      "type": "relation",
      "label": "Product",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "product.template",
      "includeChildren": false
    },
    {
      "id": "7674d2c1-e82b-4199-a991-6fae2268676b",
      "type": "relation",
      "label": "Waiter",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "hr.employee",
      "includeChildren": false
    }
  ],
  "lists": {},
  "listNextId": 1,
  "chartOdooMenusReferences": {}
}
