{
  "version": "18.5.10",
  "sheets": [
    {
      "id": "Sheet1",
      "name": "Dashboard",
      "colNumber": 7,
      "rowNumber": 79,
      "rows": {
        "6": { "size": 43 },
        "7": { "size": 33 },
        "8": { "size": 27 },
        "9": { "size": 27 },
        "10": { "size": 27 },
        "11": { "size": 27 },
        "12": { "size": 27 },
        "13": { "size": 27 },
        "14": { "size": 27 },
        "15": { "size": 27 },
        "16": { "size": 27 },
        "17": { "size": 27 },
        "20": { "size": 40 },
        "21": { "size": 38 },
        "22": { "size": 25 },
        "23": { "size": 25 },
        "24": { "size": 25 },
        "25": { "size": 25 },
        "26": { "size": 25 },
        "27": { "size": 25 },
        "28": { "size": 25 },
        "29": { "size": 25 },
        "30": { "size": 25 },
        "31": { "size": 25 },
        "34": { "size": 40 },
        "35": { "size": 36 },
        "36": { "size": 27 },
        "37": { "size": 27 },
        "38": { "size": 27 },
        "39": { "size": 27 },
        "40": { "size": 27 },
        "41": { "size": 27 },
        "42": { "size": 27 },
        "43": { "size": 27 },
        "44": { "size": 27 },
        "45": { "size": 27 },
        "47": { "size": 40 },
        "48": { "size": 40 },
        "49": { "size": 27 },
        "50": { "size": 27 },
        "51": { "size": 27 },
        "52": { "size": 27 },
        "53": { "size": 27 },
        "54": { "size": 27 },
        "55": { "size": 27 },
        "56": { "size": 27 },
        "57": { "size": 27 },
        "58": { "size": 27 },
        "60": { "size": 40 },
        "61": { "size": 40 },
        "62": { "size": 27 },
        "63": { "size": 27 },
        "64": { "size": 27 },
        "65": { "size": 27 },
        "66": { "size": 27 },
        "67": { "size": 27 },
        "68": { "size": 27 },
        "69": { "size": 27 },
        "70": { "size": 27 },
        "71": { "size": 27 }
      },
      "cols": {
        "0": { "size": 275 },
        "1": { "size": 100 },
        "2": { "size": 100 },
        "3": { "size": 50 },
        "4": { "size": 275 },
        "5": { "size": 100 },
        "6": { "size": 100 }
      },
      "merges": [],
      "cells": {
        "A8": "=ODOO.LIST.HEADER(1, \"name\")",
        "A9": "=ODOO.LIST(1,1,\"name\")",
        "A10": "=ODOO.LIST(1,2,\"name\")",
        "A11": "=ODOO.LIST(1,3,\"name\")",
        "A12": "=ODOO.LIST(1,4,\"name\")",
        "A13": "=ODOO.LIST(1,5,\"name\")",
        "A14": "=ODOO.LIST(1,6,\"name\")",
        "A15": "=ODOO.LIST(1,7,\"name\")",
        "A16": "=ODOO.LIST(1,8,\"name\")",
        "A17": "=ODOO.LIST(1,9,\"name\")",
        "A18": "=ODOO.LIST(1,10,\"name\")",
        "A22": "Stage",
        "A23": "=PIVOT(10,10,false,false,,false)",
        "A36": "=PIVOT(5, 10, FALSE, FALSE)",
        "A48": "[Top Cities](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",[\"type\",\"=\",\"opportunity\"],[\"city\",\"!=\",false]],\"context\":{\"group_by\":[\"city\"],\"pivot_measures\":[\"__count\",\"prorated_revenue\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"city\"]},\"modelName\":\"crm.lead\",\"views\":[[false,\"kanban\"],[false,\"list\"],[false,\"calendar\"],[false,\"pivot\"],[false,\"graph\"],[false,\"map\"],[false,\"form\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Pipeline\",\"positional\":true})",
        "A49": "=PIVOT(6, 10, FALSE, FALSE)",
        "A61": "[Top Salespeople](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",[\"type\",\"=\",\"opportunity\"],[\"user_id\",\"!=\",false]],\"context\":{\"group_by\":[\"user_id\"],\"pivot_measures\":[\"__count\",\"prorated_revenue\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"user_id\"]},\"modelName\":\"crm.lead\",\"views\":[[false,\"kanban\"],[false,\"list\"],[false,\"calendar\"],[false,\"pivot\"],[false,\"graph\"],[false,\"map\"],[false,\"form\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Pipeline\",\"positional\":true})",
        "A62": "=PIVOT(3, 10, FALSE, FALSE)",
        "B8": "=ODOO.LIST.HEADER(1, \"stage_id\")",
        "B9": "=ODOO.LIST(1,1,\"stage_id\")",
        "B10": "=ODOO.LIST(1,2,\"stage_id\")",
        "B11": "=ODOO.LIST(1,3,\"stage_id\")",
        "B12": "=ODOO.LIST(1,4,\"stage_id\")",
        "B13": "=ODOO.LIST(1,5,\"stage_id\")",
        "B14": "=ODOO.LIST(1,6,\"stage_id\")",
        "B15": "=ODOO.LIST(1,7,\"stage_id\")",
        "B16": "=ODOO.LIST(1,8,\"stage_id\")",
        "B17": "=ODOO.LIST(1,9,\"stage_id\")",
        "B18": "=ODOO.LIST(1,10,\"stage_id\")",
        "B22": "# Leads",
        "C8": "=ODOO.LIST.HEADER(1, \"user_id\")",
        "C9": "=ODOO.LIST(1,1,\"user_id\")",
        "C10": "=ODOO.LIST(1,2,\"user_id\")",
        "C11": "=ODOO.LIST(1,3,\"user_id\")",
        "C12": "=ODOO.LIST(1,4,\"user_id\")",
        "C13": "=ODOO.LIST(1,5,\"user_id\")",
        "C14": "=ODOO.LIST(1,6,\"user_id\")",
        "C15": "=ODOO.LIST(1,7,\"user_id\")",
        "C16": "=ODOO.LIST(1,8,\"user_id\")",
        "C17": "=ODOO.LIST(1,9,\"user_id\")",
        "C18": "=ODOO.LIST(1,10,\"user_id\")",
        "C22": "Revenue",
        "E8": "=ODOO.LIST.HEADER(1, \"country_id\")",
        "E9": "=ODOO.LIST(1,1,\"country_id\")",
        "E10": "=ODOO.LIST(1,2,\"country_id\")",
        "E11": "=ODOO.LIST(1,3,\"country_id\")",
        "E12": "=ODOO.LIST(1,4,\"country_id\")",
        "E13": "=ODOO.LIST(1,5,\"country_id\")",
        "E14": "=ODOO.LIST(1,6,\"country_id\")",
        "E15": "=ODOO.LIST(1,7,\"country_id\")",
        "E16": "=ODOO.LIST(1,8,\"country_id\")",
        "E17": "=ODOO.LIST(1,9,\"country_id\")",
        "E18": "=ODOO.LIST(1,10,\"country_id\")",
        "E21": "[Expected Closing](odoo://ir_menu_xml_id/crm.crm_opportunity_report_menu)",
        "E36": "=PIVOT(8, 10, FALSE, FALSE)",
        "E48": "[Top Mediums](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",[\"type\",\"=\",\"opportunity\"],[\"medium_id\",\"!=\",false]],\"context\":{\"group_by\":[\"medium_id\"],\"pivot_measures\":[\"__count\",\"prorated_revenue\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"medium_id\"]},\"modelName\":\"crm.lead\",\"views\":[[false,\"kanban\"],[false,\"list\"],[false,\"calendar\"],[false,\"pivot\"],[false,\"graph\"],[false,\"map\"],[false,\"form\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Pipeline\",\"positional\":true})",
        "E49": "=PIVOT(7, 10, FALSE, FALSE)",
        "E61": "[Top Sales Teams](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",[\"type\",\"=\",\"opportunity\"],[\"team_id\",\"!=\",false]],\"context\":{\"group_by\":[\"team_id\"],\"pivot_measures\":[\"__count\",\"prorated_revenue\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"team_id\"]},\"modelName\":\"crm.lead\",\"views\":[[false,\"kanban\"],[false,\"list\"],[false,\"calendar\"],[false,\"pivot\"],[false,\"graph\"],[false,\"map\"],[false,\"form\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Pipeline\",\"positional\":true})",
        "E62": "=PIVOT(4, 10, FALSE, FALSE)",
        "F8": "=ODOO.LIST.HEADER(1, \"prorated_revenue\", _t(\"Revenue\"))",
        "F9": "=ODOO.LIST(1,1,\"prorated_revenue\")",
        "F10": "=ODOO.LIST(1,2,\"prorated_revenue\")",
        "F11": "=ODOO.LIST(1,3,\"prorated_revenue\")",
        "F12": "=ODOO.LIST(1,4,\"prorated_revenue\")",
        "F13": "=ODOO.LIST(1,5,\"prorated_revenue\")",
        "F14": "=ODOO.LIST(1,6,\"prorated_revenue\")",
        "F15": "=ODOO.LIST(1,7,\"prorated_revenue\")",
        "F16": "=ODOO.LIST(1,8,\"prorated_revenue\")",
        "F17": "=ODOO.LIST(1,9,\"prorated_revenue\")",
        "F18": "=ODOO.LIST(1,10,\"prorated_revenue\")",
        "G8": "=ODOO.LIST.HEADER(1, \"probability\", _t(\"Success (%)\"))",
        "G9": "=ODOO.LIST(1,1,\"probability\")",
        "G10": "=ODOO.LIST(1,2,\"probability\")",
        "G11": "=ODOO.LIST(1,3,\"probability\")",
        "G12": "=ODOO.LIST(1,4,\"probability\")",
        "G13": "=ODOO.LIST(1,5,\"probability\")",
        "G14": "=ODOO.LIST(1,6,\"probability\")",
        "G15": "=ODOO.LIST(1,7,\"probability\")",
        "G16": "=ODOO.LIST(1,8,\"probability\")",
        "G17": "=ODOO.LIST(1,9,\"probability\")",
        "G18": "=ODOO.LIST(1,10,\"probability\")"
      },
      "styles": {
        "A7": 1,
        "A21": 1,
        "A35": 1,
        "A48": 1,
        "A61": 1,
        "E21": 1,
        "E35": 1,
        "E48": 1,
        "E61": 1,
        "A22": 2,
        "A36": 2,
        "A49": 2,
        "A62": 2,
        "A8:E8": 2,
        "E36": 2,
        "E49": 2,
        "E62": 2,
        "A9:A18": 3,
        "A37:C43": 4,
        "A50:C59": 4,
        "A63:C72": 4,
        "B9:G18": 4,
        "E37:G46": 4,
        "E50:G59": 4,
        "E63:G72": 4,
        "B22:C22": 5,
        "B36:C36": 5,
        "B49:C49": 5,
        "B62:C62": 5,
        "F8:G8": 5,
        "F36:G36": 5,
        "F49:G49": 5,
        "F62:G62": 5
      },
      "formats": {},
      "borders": {
        "A9": 1,
        "A23": 1,
        "A37": 1,
        "A50": 1,
        "A63": 1,
        "E37": 1,
        "E50": 1,
        "E63": 1,
        "A10:A17": 2,
        "A24:A31": 2,
        "A38:A45": 2,
        "A51:A58": 2,
        "A64:A71": 2,
        "E38:E45": 2,
        "E51:E58": 2,
        "E64:E71": 2,
        "A18": 3,
        "A32": 3,
        "A46": 3,
        "A59": 3,
        "A72": 3,
        "E46": 3,
        "E59": 3,
        "E72": 3,
        "A48:C48": 4,
        "A61:C61": 4,
        "E21:G21": 4,
        "E48:G48": 4,
        "E61:G61": 4,
        "A49:C49": 5,
        "A62:C62": 5,
        "E49:G49": 5,
        "E62:G62": 5,
        "B23": 6,
        "B37": 6,
        "B50": 6,
        "B63": 6,
        "B9:F9": 6,
        "F37": 6,
        "F50": 6,
        "F63": 6,
        "B24:B31": 7,
        "B38:B45": 7,
        "B51:B58": 7,
        "B64:B71": 7,
        "B10:F17": 7,
        "F38:F45": 7,
        "F51:F58": 7,
        "F64:F71": 7,
        "B32": 8,
        "B46": 8,
        "B59": 8,
        "B72": 8,
        "B18:F18": 8,
        "F46": 8,
        "F59": 8,
        "F72": 8,
        "C23": 9,
        "C37": 9,
        "C50": 9,
        "C63": 9,
        "G9": 9,
        "G37": 9,
        "G50": 9,
        "G63": 9,
        "C24:C31": 10,
        "C38:C45": 10,
        "C51:C58": 10,
        "C64:C71": 10,
        "G10:G17": 10,
        "G38:G45": 10,
        "G51:G58": 10,
        "G64:G71": 10,
        "C32": 11,
        "C46": 11,
        "C59": 11,
        "C72": 11,
        "G18": 11,
        "G46": 11,
        "G59": 11,
        "G72": 11
      },
      "conditionalFormats": [
        {
          "id": "13881108-f614-4278-89c4-a58fda80496c",
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "F9:F18" },
          "ranges": ["A9:A18"]
        },
        {
          "id": "160a3e6f-6265-4a3e-a84e-a93efce715c6",
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "C63:C72" },
          "ranges": ["A63:A72"]
        },
        {
          "id": "adcc4f6a-b796-4ad9-ab48-ecdb91c2ef05",
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "G63:G72" },
          "ranges": ["E63:E72"]
        },
        {
          "id": "14099357-8292-4a05-92d3-33656028ed9e",
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "C37:C46" },
          "ranges": ["A37:A46"]
        },
        {
          "id": "66f8207d-2f52-4321-a1e2-c8b76117aff0",
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "C50:C59" },
          "ranges": ["A50:A59"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "G50:G59" },
          "id": "0c8a2d29-0965-4f95-a091-6526cd056eea",
          "ranges": ["E50:E58"]
        },
        {
          "id": "bd248e0c-82e6-4f75-a8f0-7c25bb0e3ebe",
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "G37:G46" },
          "ranges": ["E37:E46"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "C23:C32" },
          "id": "df4deb50-e2aa",
          "ranges": ["A23:A32"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "09ab3fe3-04d6-4c9f-97ff-bb37fee0e692",
          "width": 200,
          "height": 109,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": { "text": "Expected", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!E4",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "Data!D4",
            "humanize": false,
            "chartId": "09ab3fe3-04d6-4c9f-97ff-bb37fee0e692"
          },
          "offset": { "x": 0, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "5dc98740-8fc9-432d-b386-59e6e5c8b7e8",
          "width": 200,
          "height": 109,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": { "text": "Closed", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!E5",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "Data!D5",
            "humanize": false,
            "chartId": "5dc98740-8fc9-432d-b386-59e6e5c8b7e8"
          },
          "offset": { "x": 208, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "735dabd8-96dc-44a1-9871-f35a94c347f5",
          "width": 200,
          "height": 109,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Open opportunities", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baselineDescr": { "text": "to close" },
            "keyValue": "Data!D7",
            "humanize": false,
            "chartId": "735dabd8-96dc-44a1-9871-f35a94c347f5"
          },
          "offset": { "x": 416, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "6c739756-da1e-4e9b-bd26-e74e6cd10c88",
          "width": 476,
          "height": 311,
          "tag": "chart",
          "data": {
            "title": { "text": "", "bold": true, "fontSize": 20, "color": "#01666B" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["date_deadline:month", "team_id"],
              "measure": "prorated_revenue",
              "order": null,
              "resModel": "crm.lead",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": { "default_type": "opportunity" },
              "domain": [
                "&",
                ["type", "=", "opportunity"],
                ["date_deadline", "!=", false]
              ],
              "groupBy": ["date_deadline:month", "team_id"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "dataSets": [],
            "humanize": true,
            "verticalAxisPosition": "left",
            "stacked": true,
            "axesDesign": {
              "x": {
                "title": { "text": "" }
              },
              "y": {
                "title": { "text": "Revenue" }
              }
            },
            "chartId": "6c739756-da1e-4e9b-bd26-e74e6cd10c88",
            "fieldMatching": {
              "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
              "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
              "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
              "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
              "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
              "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
              "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
              "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
            }
          },
          "offset": { "x": 49, "y": 1 },
          "col": 3,
          "row": 21
        },
        {
          "id": "371be81c-1fac",
          "col": 0,
          "row": 6,
          "offset": { "x": 0, "y": 11 },
          "width": 1000,
          "height": 362,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "2a5063b0-4c4b": {
                "type": "combo",
                "dataSetsHaveTitle": true,
                "dataSets": [
                  { "dataRange": "F8:F18", "yAxisId": "y", "type": "bar" },
                  { "dataRange": "G8:G18", "type": "line", "yAxisId": "y1" }
                ],
                "legendPosition": "top",
                "labelRange": "A8:A18",
                "title": { "text": "", "bold": true, "color": "#01666B", "fontSize": 21 },
                "aggregated": false,
                "axesDesign": {
                  "y": {
                    "title": { "text": "Revenue" }
                  },
                  "y1": {
                    "title": { "text": "Probability" }
                  }
                },
                "humanize": true
              }
            },
            "items": [
              { "type": "chart", "chartId": "2a5063b0-4c4b", "title": "Graph" },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "title": {
              "text": "Top Opportunities",
              "fontSize": 21,
              "color": "#01666B",
              "bold": true
            },
            "fieldMatching": {}
          }
        },
        {
          "id": "d8fb9812-04f0",
          "col": 0,
          "row": 20,
          "offset": { "x": 0, "y": 7 },
          "width": 491,
          "height": 349,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "5adf5fa8-e0e4-4e13-a3ac-259d67389cfb": {
                "title": { "text": "", "bold": true, "fontSize": 21, "color": "#01666B" },
                "background": "#FFFFFF",
                "legendPosition": "top",
                "metaData": {
                  "groupBy": ["stage_id", "team_id"],
                  "measure": "prorated_revenue",
                  "order": null,
                  "resModel": "crm.lead",
                  "mode": "bar"
                },
                "searchParams": {
                  "comparison": null,
                  "context": { "default_type": "opportunity" },
                  "domain": [
                    ["type", "=", "opportunity"]
                  ],
                  "groupBy": ["stage_id", "team_id"],
                  "orderBy": []
                },
                "type": "odoo_bar",
                "dataSets": [],
                "humanize": true,
                "verticalAxisPosition": "left",
                "stacked": true,
                "axesDesign": {
                  "y": {
                    "title": { "text": "Revenue" }
                  }
                }
              },
              "a53f3ad6-5a53": {
                "title": { "text": "", "fontSize": 21, "color": "#01666B", "bold": true },
                "background": "#FFFFFF",
                "legendPosition": "top",
                "metaData": {
                  "groupBy": ["stage_id"],
                  "measure": "prorated_revenue",
                  "order": null,
                  "resModel": "crm.lead",
                  "mode": "bar",
                  "cumulated": true
                },
                "searchParams": {
                  "context": {
                    "list_view_ref": "crm.crm_case_tree_view_oppor",
                    "default_type": "opportunity"
                  },
                  "domain": [],
                  "groupBy": ["stage_id"],
                  "orderBy": []
                },
                "type": "odoo_funnel",
                "actionXmlId": "crm_enterprise.crm_opportunity_action_dashboard",
                "dataSets": [],
                "humanize": true,
                "cumulative": true
              }
            },
            "items": [
              { "type": "chart", "chartId": "a53f3ad6-5a53" },
              {
                "type": "chart",
                "chartId": "5adf5fa8-e0e4-4e13-a3ac-259d67389cfb",
                "title": "Bar"
              },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "title": { "text": "Pipeline", "bold": true, "fontSize": 21, "color": "#01666B" },
            "fieldMatching": {
              "5adf5fa8-e0e4-4e13-a3ac-259d67389cfb": {
                "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
                "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
                "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
                "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
                "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
                "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
                "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
                "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
              },
              "a53f3ad6-5a53": {
                "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
                "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
                "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
                "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
                "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
                "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
                "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
                "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
              }
            }
          }
        },
        {
          "id": "2e2fe2d8-ad50",
          "col": 0,
          "row": 34,
          "offset": { "x": 0, "y": 8 },
          "width": 491,
          "height": 360,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "af11f776-28fb": {
                "title": { "text": "", "fontSize": 21, "color": "#01666B", "bold": true },
                "background": "#FFFFFF",
                "legendPosition": "left",
                "metaData": {
                  "groupBy": ["country_id"],
                  "measure": "prorated_revenue",
                  "order": null,
                  "resModel": "crm.lead",
                  "mode": "bar"
                },
                "searchParams": {
                  "context": {
                    "list_view_ref": "crm.crm_case_tree_view_oppor",
                    "default_type": "opportunity"
                  },
                  "domain": [],
                  "groupBy": ["country_id"],
                  "orderBy": []
                },
                "type": "odoo_geo",
                "actionXmlId": "crm_enterprise.crm_opportunity_action_dashboard",
                "dataSets": [],
                "humanize": true,
                "colorScale": "blues"
              },
              "df10a4eb-48ac": {
                "title": { "text": "", "color": "#01666B", "fontSize": 21, "bold": true },
                "background": "#FFFFFF",
                "legendPosition": "left",
                "metaData": {
                  "groupBy": ["country_id"],
                  "measure": "__count",
                  "order": null,
                  "resModel": "crm.lead",
                  "mode": "bar"
                },
                "searchParams": {
                  "context": {
                    "list_view_ref": "crm.crm_case_tree_view_oppor",
                    "default_type": "opportunity"
                  },
                  "domain": [],
                  "groupBy": ["country_id"],
                  "orderBy": []
                },
                "type": "odoo_geo",
                "actionXmlId": "crm_enterprise.crm_opportunity_action_dashboard",
                "dataSets": [],
                "humanize": true,
                "colorScale": "blues"
              }
            },
            "items": [
              { "type": "chart", "chartId": "af11f776-28fb", "title": "Revenue" },
              { "type": "chart", "chartId": "df10a4eb-48ac", "title": "Leads" },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "title": {
              "text": "Top Countries",
              "fontSize": 21,
              "bold": true,
              "color": "#01666B"
            },
            "fieldMatching": {
              "af11f776-28fb": {
                "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
                "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
                "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
                "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
                "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
                "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
                "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
                "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
              },
              "df10a4eb-48ac": {
                "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
                "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
                "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
                "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
                "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
                "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
                "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
                "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
              }
            }
          }
        },
        {
          "id": "0f2fc6cd-0b55",
          "col": 3,
          "row": 34,
          "offset": { "x": 49, "y": 8 },
          "width": 476,
          "height": 353,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "6aeb5a7c-00a7": {
                "title": { "text": "", "fontSize": 21, "color": "#01666B", "bold": true },
                "background": "#FFFFFF",
                "legendPosition": "top",
                "metaData": {
                  "groupBy": ["source_id"],
                  "measure": "prorated_revenue",
                  "order": null,
                  "resModel": "crm.lead",
                  "mode": "bar"
                },
                "searchParams": {
                  "context": {
                    "list_view_ref": "crm.crm_case_tree_view_oppor",
                    "default_type": "opportunity"
                  },
                  "domain": [],
                  "groupBy": ["source_id"],
                  "orderBy": []
                },
                "type": "odoo_treemap",
                "actionXmlId": "crm_enterprise.crm_opportunity_action_dashboard",
                "dataSets": [],
                "humanize": true
              }
            },
            "items": [
              { "type": "chart", "chartId": "6aeb5a7c-00a7", "title": "Graph" },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "title": {
              "text": "Revenues by source",
              "bold": true,
              "fontSize": 21,
              "color": "#01666B"
            },
            "fieldMatching": {
              "6aeb5a7c-00a7": {
                "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
                "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
                "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
                "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
                "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
                "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
                "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
                "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
              }
            }
          }
        }
      ],
      "tables": [
        {
          "range": "A8:G18",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A23",
          "type": "dynamic",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 0,
            "bandedRows": false,
            "bandedColumns": false,
            "styleId": "None",
            "automaticAutofill": false
          }
        },
        {
          "range": "A36:C46",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A49:C59",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E36:G46",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E49:G59",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E62:G72",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A62:C72",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    },
    {
      "id": "a51634aa-7103-45b3-ab61-fd26c0824a1f",
      "name": "Data",
      "colNumber": 26,
      "rowNumber": 102,
      "rows": {},
      "cols": {
        "0": { "size": 122 },
        "1": { "size": 141 },
        "2": { "size": 141 },
        "3": { "size": 141 },
        "4": { "size": 141 }
      },
      "merges": [],
      "cells": {
        "A1": "=_t(\"KPI\")",
        "A2": "=_t(\"Expected count\")",
        "A3": "=_t(\"Closed count\")",
        "A4": "=_t(\"Expected revenue\")",
        "A5": "=_t(\"Closed revenue\")",
        "A6": "=_t(\"Percentage closed\")",
        "A7": "=_t(\"To close\")",
        "B1": "=_t(\"Current\")",
        "B2": "=PIVOT.VALUE(1,\"__count\")",
        "B3": "=PIVOT.VALUE(1,\"__count\",\"won_status\",\"won\")",
        "B4": "=PIVOT.VALUE(1,\"prorated_revenue\")",
        "B5": "=PIVOT.VALUE(1,\"prorated_revenue\",\"won_status\",\"won\")",
        "B6": "=IFERROR(B3/B2)",
        "B7": "=PIVOT.VALUE(1,\"__count\",\"won_status\",\"pending\")",
        "C1": "=_t(\"Previous\")",
        "C2": "=PIVOT.VALUE(2,\"__count\")",
        "C3": "=PIVOT.VALUE(2,\"__count\",\"won_status\",\"won\")",
        "C4": "=PIVOT.VALUE(2,\"prorated_revenue\")",
        "C5": "=PIVOT.VALUE(2,\"prorated_revenue\",\"won_status\",\"won\")",
        "C6": "=IFERROR(C3/C2)",
        "C7": "=PIVOT.VALUE(2,\"__count\",\"won_status\",\"pending\")",
        "D1": "=_t(\"Current\")",
        "D2": "=FORMAT.LARGE.NUMBER(B2)",
        "D3": "=FORMAT.LARGE.NUMBER(B3)",
        "D4": "=FORMAT.LARGE.NUMBER(B4)",
        "D5": "=FORMAT.LARGE.NUMBER(B5)",
        "D6": "=B6",
        "D7": "=FORMAT.LARGE.NUMBER(B7)",
        "E1": "=_t(\"Previous\")",
        "E2": "=FORMAT.LARGE.NUMBER(C2)",
        "E3": "=FORMAT.LARGE.NUMBER(C3)",
        "E4": "=FORMAT.LARGE.NUMBER(C4)",
        "E5": "=FORMAT.LARGE.NUMBER(C5)",
        "E6": "=C6",
        "E7": "=FORMAT.LARGE.NUMBER(C7)"
      },
      "styles": { "A1:E1": 6, "D2:E7": 7 },
      "formats": { "B6:E6": 1 },
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "textColor": "#01666b", "bold": true, "fontSize": 16 },
    "2": { "fontSize": 11, "bold": true, "textColor": "#434343" },
    "3": { "textColor": "#01666B", "verticalAlign": "middle" },
    "4": { "textColor": "#434343", "verticalAlign": "middle" },
    "5": {
      "fontSize": 11,
      "bold": true,
      "textColor": "#434343",
      "align": "center"
    },
    "6": { "bold": true },
    "7": { "fillColor": "#f8f9fa" }
  },
  "formats": { "1": "0%" },
  "borders": {
    "1": {
      "right": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "2": {
      "top": { "style": "medium", "color": "#FFFFFF" },
      "right": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "3": {
      "top": { "style": "medium", "color": "#FFFFFF" },
      "right": { "style": "medium", "color": "#FFFFFF" }
    },
    "4": {
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "5": {
      "top": { "style": "thin", "color": "#CCCCCC" }
    },
    "6": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "right": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "7": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "top": { "style": "medium", "color": "#FFFFFF" },
      "right": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "8": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "top": { "style": "medium", "color": "#FFFFFF" },
      "right": { "style": "medium", "color": "#FFFFFF" }
    },
    "9": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "10": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "top": { "style": "medium", "color": "#FFFFFF" },
      "bottom": { "style": "medium", "color": "#FFFFFF" }
    },
    "11": {
      "left": { "style": "medium", "color": "#FFFFFF" },
      "top": { "style": "medium", "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": {
    "1": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        ["type", "=", "opportunity"]
      ],
      "id": "1",
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency"
        }
      ],
      "model": "crm.lead",
      "name": "expected - current",
      "sortedColumn": null,
      "formulaId": "1",
      "columns": [],
      "rows": [
        { "fieldName": "won_status" }
      ]
    },
    "2": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": -1 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        ["type", "=", "opportunity"]
      ],
      "id": "2",
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency"
        }
      ],
      "model": "crm.lead",
      "name": "expected - previous",
      "sortedColumn": null,
      "formulaId": "2",
      "columns": [],
      "rows": [
        { "fieldName": "won_status" }
      ]
    },
    "3": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["user_id", "!=", false]
      ],
      "id": "3",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "Salesperson",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "3",
      "columns": [],
      "rows": [
        { "fieldName": "user_id" }
      ]
    },
    "4": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["team_id", "!=", false]
      ],
      "id": "4",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "Sales Team",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "4",
      "columns": [],
      "rows": [
        { "fieldName": "team_id" }
      ]
    },
    "5": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["country_id", "!=", false]
      ],
      "id": "5",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "Country",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "5",
      "columns": [],
      "rows": [
        { "fieldName": "country_id" }
      ]
    },
    "6": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["city", "!=", false]
      ],
      "id": "6",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "City",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "6",
      "columns": [],
      "rows": [
        { "fieldName": "city" }
      ]
    },
    "7": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["medium_id", "!=", false]
      ],
      "id": "7",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "Medium",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "7",
      "columns": [],
      "rows": [
        { "fieldName": "medium_id" }
      ]
    },
    "8": {
      "type": "ODOO",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date", "offset": 0 },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      },
      "context": { "default_type": "opportunity" },
      "domain": [
        "&",
        ["type", "=", "opportunity"],
        ["source_id", "!=", false]
      ],
      "id": "8",
      "measures": [
        { "id": "__count", "fieldName": "__count", "userDefinedName": "# Leads" },
        {
          "id": "prorated_revenue",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency",
          "userDefinedName": "Revenue"
        }
      ],
      "model": "crm.lead",
      "name": "Source",
      "sortedColumn": {
        "measure": "prorated_revenue",
        "order": "desc",
        "domain": []
      },
      "formulaId": "8",
      "columns": [],
      "rows": [
        { "fieldName": "source_id" }
      ]
    },
    "d2a6f75c-a0a1": {
      "type": "ODOO",
      "domain": [],
      "context": {
        "list_view_ref": "crm.crm_case_tree_view_oppor",
        "default_type": "opportunity"
      },
      "sortedColumn": {
        "domain": [],
        "order": "desc",
        "measure": "prorated_revenue:sum"
      },
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "prorated_revenue:sum",
          "fieldName": "prorated_revenue",
          "aggregator": "sum_currency"
        }
      ],
      "model": "crm.lead",
      "columns": [],
      "rows": [
        { "fieldName": "stage_id" }
      ],
      "name": "Pipeline Analysis by Stage (copy)",
      "actionXmlId": "crm_enterprise.crm_opportunity_action_dashboard",
      "formulaId": "10",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      }
    }
  },
  "pivotNextId": 12,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "bf6dcdb0-d22d-468c-b6a9-64f717005043",
      "type": "date",
      "label": "Period",
      "defaultValue": "last_30_days"
    },
    {
      "id": "9f3d4602-0b4b-4eb4-b013-959d72af88ab",
      "type": "relation",
      "label": "Stage",
      "modelName": "crm.stage",
      "defaultValueDisplayNames": []
    },
    {
      "id": "9c8a3e99-903a-40a3-8799-5eaf098b884f",
      "type": "relation",
      "label": "Salesperson",
      "modelName": "res.users",
      "defaultValueDisplayNames": []
    },
    {
      "id": "aaba8a27-cf83-4397-a9ad-a85bba4c8016",
      "type": "relation",
      "label": "Sales Team",
      "modelName": "crm.team",
      "defaultValueDisplayNames": []
    },
    {
      "id": "f6ef716d-3135-4963-b645-bc12c6a3421b",
      "type": "relation",
      "label": "Country",
      "modelName": "res.country",
      "defaultValueDisplayNames": []
    },
    {
      "id": "ec772492-b1db-4a63-be55-a4e0c3167edf",
      "type": "text",
      "label": "City"
    },
    {
      "id": "c21a4660-9a0a-4757-8d28-1c8d95f73edb",
      "type": "relation",
      "label": "Medium",
      "modelName": "utm.medium",
      "defaultValueDisplayNames": []
    },
    {
      "id": "c33d6d0a-df2d-4150-86b0-112cd250ddbd",
      "type": "relation",
      "label": "Source",
      "modelName": "utm.source",
      "defaultValueDisplayNames": []
    }
  ],
  "lists": {
    "1": {
      "columns": [
        "name",
        "email_from",
        "phone",
        "country_id",
        "user_id",
        "activity_ids",
        "my_activity_date_deadline",
        "prorated_revenue",
        "stage_id",
        "probability"
      ],
      "domain": [
        ["type", "=", "opportunity"]
      ],
      "model": "crm.lead",
      "context": { "default_type": "opportunity" },
      "orderBy": [
        { "name": "prorated_revenue", "asc": false }
      ],
      "id": "1",
      "name": "list opps",
      "fieldMatching": {
        "bf6dcdb0-d22d-468c-b6a9-64f717005043": { "chain": "date_deadline", "type": "date" },
        "9f3d4602-0b4b-4eb4-b013-959d72af88ab": { "chain": "stage_id", "type": "many2one" },
        "9c8a3e99-903a-40a3-8799-5eaf098b884f": { "chain": "user_id", "type": "many2one" },
        "aaba8a27-cf83-4397-a9ad-a85bba4c8016": { "chain": "team_id", "type": "many2one" },
        "f6ef716d-3135-4963-b645-bc12c6a3421b": { "chain": "country_id", "type": "many2one" },
        "ec772492-b1db-4a63-be55-a4e0c3167edf": { "chain": "city", "type": "char" },
        "c21a4660-9a0a-4757-8d28-1c8d95f73edb": { "chain": "medium_id", "type": "many2one" },
        "c33d6d0a-df2d-4150-86b0-112cd250ddbd": { "chain": "source_id", "type": "many2one" }
      }
    }
  },
  "listNextId": 2,
  "chartOdooMenusReferences": {
    "5adf5fa8-e0e4-4e13-a3ac-259d67389cfb": "crm.crm_menu_root",
    "6c739756-da1e-4e9b-bd26-e74e6cd10c88": "crm.crm_menu_root",
    "09ab3fe3-04d6-4c9f-97ff-bb37fee0e692": "crm.crm_opportunity_report_menu",
    "5dc98740-8fc9-432d-b386-59e6e5c8b7e8": "crm.crm_opportunity_report_menu",
    "735dabd8-96dc-44a1-9871-f35a94c347f5": "crm.menu_crm_opportunities",
    "2a5063b0-4c4b": "crm.crm_opportunity_report_menu",
    "a53f3ad6-5a53": "crm.crm_opportunity_report_menu",
    "df10a4eb-48ac": "crm.crm_opportunity_report_menu",
    "6aeb5a7c-00a7": "crm.crm_opportunity_report_menu",
    "af11f776-28fb": "crm.crm_opportunity_report_menu"
  }
}
