{
  "version": "18.5.10",
  "sheets": [
    {
      "id": "sheet1",
      "name": "Dashboard",
      "colNumber": 7,
      "rowNumber": 70,
      "rows": {
        "6": { "size": 36 },
        "12": { "size": 22 },
        "22": { "size": 40 },
        "23": { "size": 38 },
        "24": { "size": 26 },
        "25": { "size": 26 },
        "26": { "size": 26 },
        "27": { "size": 26 },
        "28": { "size": 26 },
        "29": { "size": 26 },
        "30": { "size": 26 },
        "31": { "size": 26 },
        "32": { "size": 26 },
        "33": { "size": 26 },
        "35": { "size": 41 },
        "36": { "size": 38 },
        "37": { "size": 26 },
        "38": { "size": 26 },
        "39": { "size": 26 },
        "40": { "size": 26 },
        "41": { "size": 26 },
        "42": { "size": 26 },
        "43": { "size": 26 },
        "44": { "size": 26 },
        "45": { "size": 26 },
        "46": { "size": 26 },
        "48": { "size": 43 },
        "49": { "size": 38 },
        "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 }
      },
      "cols": {
        "0": { "size": 200 },
        "1": { "size": 114 },
        "4": { "size": 191 },
        "5": { "size": 89 }
      },
      "merges": [],
      "cells": {
        "A7": "[Subscriptions](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[[\"event_type\",\"!=\",\"3_transfer\"]],\"context\":{\"group_by\":[\"event_type\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"bar\",\"graph_groupbys\":[\"event_type\"],\"graph_order\":null,\"graph_stacked\":true},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Growth\"})",
        "A23": "[Worst Churn](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",[\"event_type\",\"!=\",\"3_transfer\"],[\"event_type\",\"=\",\"2_churn\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Growth\"})",
        "A24": "=ODOO.LIST.HEADER(1, \"order_id\", _t(\"Subscriptions\"))",
        "A25": "=ODOO.LIST(1,1,\"order_id\")",
        "A26": "=ODOO.LIST(1,2,\"order_id\")",
        "A27": "=ODOO.LIST(1,3,\"order_id\")",
        "A28": "=ODOO.LIST(1,4,\"order_id\")",
        "A29": "=ODOO.LIST(1,5,\"order_id\")",
        "A30": "=ODOO.LIST(1,6,\"order_id\")",
        "A31": "=ODOO.LIST(1,7,\"order_id\")",
        "A32": "=ODOO.LIST(1,8,\"order_id\")",
        "A33": "=ODOO.LIST(1,9,\"order_id\")",
        "A34": "=ODOO.LIST(1,10,\"order_id\")",
        "A36": "[Worst Contraction](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",[\"event_type\",\"!=\",\"3_transfer\"],[\"event_type\",\"=\",\"15_contraction\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A37": "=ODOO.LIST.HEADER(4, \"order_id\", _t(\"Subscriptions\"))",
        "A38": "=ODOO.LIST(4,1,\"order_id\")",
        "A39": "=ODOO.LIST(4,2,\"order_id\")",
        "A40": "=ODOO.LIST(4,3,\"order_id\")",
        "A41": "=ODOO.LIST(4,4,\"order_id\")",
        "A42": "=ODOO.LIST(4,5,\"order_id\")",
        "A43": "=ODOO.LIST(4,6,\"order_id\")",
        "A44": "=ODOO.LIST(4,7,\"order_id\")",
        "A45": "=ODOO.LIST(4,8,\"order_id\")",
        "A46": "=ODOO.LIST(4,9,\"order_id\")",
        "A47": "=ODOO.LIST(4,10,\"order_id\")",
        "A49": "[Top Recurrence](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"not in\",[\"2_renewal\",\"5_renewed\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order\",\"views\":[[false,\"list\"],[false,\"kanban\"],[false,\"form\"],[false,\"pivot\"],[false,\"graph\"],[false,\"cohort\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions\"})",
        "B24": "=ODOO.LIST.HEADER(1, \"amount_signed\", _t(\"Value\"))",
        "B25": "=ODOO.LIST(1,1,\"amount_signed\")",
        "B26": "=ODOO.LIST(1,2,\"amount_signed\")",
        "B27": "=ODOO.LIST(1,3,\"amount_signed\")",
        "B28": "=ODOO.LIST(1,4,\"amount_signed\")",
        "B29": "=ODOO.LIST(1,5,\"amount_signed\")",
        "B30": "=ODOO.LIST(1,6,\"amount_signed\")",
        "B31": "=ODOO.LIST(1,7,\"amount_signed\")",
        "B32": "=ODOO.LIST(1,8,\"amount_signed\")",
        "B33": "=ODOO.LIST(1,9,\"amount_signed\")",
        "B34": "=ODOO.LIST(1,10,\"amount_signed\")",
        "B37": "=ODOO.LIST.HEADER(4, \"amount_signed\", _t(\"Value\"))",
        "B38": "=ODOO.LIST(4,1,\"amount_signed\")",
        "B39": "=ODOO.LIST(4,2,\"amount_signed\")",
        "B40": "=ODOO.LIST(4,3,\"amount_signed\")",
        "B41": "=ODOO.LIST(4,4,\"amount_signed\")",
        "B42": "=ODOO.LIST(4,5,\"amount_signed\")",
        "B43": "=ODOO.LIST(4,6,\"amount_signed\")",
        "B44": "=ODOO.LIST(4,7,\"amount_signed\")",
        "B45": "=ODOO.LIST(4,8,\"amount_signed\")",
        "B46": "=ODOO.LIST(4,9,\"amount_signed\")",
        "B47": "=ODOO.LIST(4,10,\"amount_signed\")",
        "C24": "=ODOO.LIST.HEADER(1, \"recurring_monthly\", _t(\"MRR\"))",
        "C25": "=ODOO.LIST(1,1,\"recurring_monthly\")",
        "C26": "=ODOO.LIST(1,2,\"recurring_monthly\")",
        "C27": "=ODOO.LIST(1,3,\"recurring_monthly\")",
        "C28": "=ODOO.LIST(1,4,\"recurring_monthly\")",
        "C29": "=ODOO.LIST(1,5,\"recurring_monthly\")",
        "C30": "=ODOO.LIST(1,6,\"recurring_monthly\")",
        "C31": "=ODOO.LIST(1,7,\"recurring_monthly\")",
        "C32": "=ODOO.LIST(1,8,\"recurring_monthly\")",
        "C33": "=ODOO.LIST(1,9,\"recurring_monthly\")",
        "C34": "=ODOO.LIST(1,10,\"recurring_monthly\")",
        "C37": "=ODOO.LIST.HEADER(4, \"recurring_monthly\", _t(\"MRR\"))",
        "C38": "=ODOO.LIST(4,1,\"recurring_monthly\")",
        "C39": "=ODOO.LIST(4,2,\"recurring_monthly\")",
        "C40": "=ODOO.LIST(4,3,\"recurring_monthly\")",
        "C41": "=ODOO.LIST(4,4,\"recurring_monthly\")",
        "C42": "=ODOO.LIST(4,5,\"recurring_monthly\")",
        "C43": "=ODOO.LIST(4,6,\"recurring_monthly\")",
        "C44": "=ODOO.LIST(4,7,\"recurring_monthly\")",
        "C45": "=ODOO.LIST(4,8,\"recurring_monthly\")",
        "C46": "=ODOO.LIST(4,9,\"recurring_monthly\")",
        "C47": "=ODOO.LIST(4,10,\"recurring_monthly\")",
        "E23": "[Top New](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",[\"event_type\",\"!=\",\"3_transfer\"],[\"event_type\",\"=\",\"0_creation\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Growth\"})",
        "E24": "=ODOO.LIST.HEADER(3, \"order_id\", _t(\"Subscriptions\"))",
        "E25": "=ODOO.LIST(3,1,\"order_id\")",
        "E26": "=ODOO.LIST(3,2,\"order_id\")",
        "E27": "=ODOO.LIST(3,3,\"order_id\")",
        "E28": "=ODOO.LIST(3,4,\"order_id\")",
        "E29": "=ODOO.LIST(3,5,\"order_id\")",
        "E30": "=ODOO.LIST(3,6,\"order_id\")",
        "E31": "=ODOO.LIST(3,7,\"order_id\")",
        "E32": "=ODOO.LIST(3,8,\"order_id\")",
        "E33": "=ODOO.LIST(3,9,\"order_id\")",
        "E34": "=ODOO.LIST(3,10,\"order_id\")",
        "E36": "[Top Expansion](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",[\"event_type\",\"!=\",\"3_transfer\"],[\"event_type\",\"=\",\"1_expansion\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Growth\"})",
        "E37": "=ODOO.LIST.HEADER(2, \"order_id\", _t(\"Subscriptions\"))",
        "E38": "=ODOO.LIST(2,1,\"order_id\")",
        "E39": "=ODOO.LIST(2,2,\"order_id\")",
        "E40": "=ODOO.LIST(2,3,\"order_id\")",
        "E41": "=ODOO.LIST(2,4,\"order_id\")",
        "E42": "=ODOO.LIST(2,5,\"order_id\")",
        "E43": "=ODOO.LIST(2,6,\"order_id\")",
        "E44": "=ODOO.LIST(2,7,\"order_id\")",
        "E45": "=ODOO.LIST(2,8,\"order_id\")",
        "E46": "=ODOO.LIST(2,9,\"order_id\")",
        "E47": "=ODOO.LIST(2,10,\"order_id\")",
        "F24": "=ODOO.LIST.HEADER(3, \"amount_signed\", _t(\"Value\"))",
        "F25": "=ODOO.LIST(3,1,\"amount_signed\")",
        "F26": "=ODOO.LIST(3,2,\"amount_signed\")",
        "F27": "=ODOO.LIST(3,3,\"amount_signed\")",
        "F28": "=ODOO.LIST(3,4,\"amount_signed\")",
        "F29": "=ODOO.LIST(3,5,\"amount_signed\")",
        "F30": "=ODOO.LIST(3,6,\"amount_signed\")",
        "F31": "=ODOO.LIST(3,7,\"amount_signed\")",
        "F32": "=ODOO.LIST(3,8,\"amount_signed\")",
        "F33": "=ODOO.LIST(3,9,\"amount_signed\")",
        "F34": "=ODOO.LIST(3,10,\"amount_signed\")",
        "F37": "=ODOO.LIST.HEADER(2, \"amount_signed\", _t(\"Value\"))",
        "F38": "=ODOO.LIST(2,1,\"amount_signed\")",
        "F39": "=ODOO.LIST(2,2,\"amount_signed\")",
        "F40": "=ODOO.LIST(2,3,\"amount_signed\")",
        "F41": "=ODOO.LIST(2,4,\"amount_signed\")",
        "F42": "=ODOO.LIST(2,5,\"amount_signed\")",
        "F43": "=ODOO.LIST(2,6,\"amount_signed\")",
        "F44": "=ODOO.LIST(2,7,\"amount_signed\")",
        "F45": "=ODOO.LIST(2,8,\"amount_signed\")",
        "F46": "=ODOO.LIST(2,9,\"amount_signed\")",
        "F47": "=ODOO.LIST(2,10,\"amount_signed\")",
        "G24": "=ODOO.LIST.HEADER(3, \"recurring_monthly\", _t(\"MRR\"))",
        "G25": "=ODOO.LIST(3,1,\"recurring_monthly\")",
        "G26": "=ODOO.LIST(3,2,\"recurring_monthly\")",
        "G27": "=ODOO.LIST(3,3,\"recurring_monthly\")",
        "G28": "=ODOO.LIST(3,4,\"recurring_monthly\")",
        "G29": "=ODOO.LIST(3,5,\"recurring_monthly\")",
        "G30": "=ODOO.LIST(3,6,\"recurring_monthly\")",
        "G31": "=ODOO.LIST(3,7,\"recurring_monthly\")",
        "G32": "=ODOO.LIST(3,8,\"recurring_monthly\")",
        "G33": "=ODOO.LIST(3,9,\"recurring_monthly\")",
        "G34": "=ODOO.LIST(3,10,\"recurring_monthly\")",
        "G37": "=ODOO.LIST.HEADER(2, \"recurring_monthly\", _t(\"MRR\"))",
        "G38": "=ODOO.LIST(2,1,\"recurring_monthly\")",
        "G39": "=ODOO.LIST(2,2,\"recurring_monthly\")",
        "G40": "=ODOO.LIST(2,3,\"recurring_monthly\")",
        "G41": "=ODOO.LIST(2,4,\"recurring_monthly\")",
        "G42": "=ODOO.LIST(2,5,\"recurring_monthly\")",
        "G43": "=ODOO.LIST(2,6,\"recurring_monthly\")",
        "G44": "=ODOO.LIST(2,7,\"recurring_monthly\")",
        "G45": "=ODOO.LIST(2,8,\"recurring_monthly\")",
        "G46": "=ODOO.LIST(2,9,\"recurring_monthly\")",
        "G47": "=ODOO.LIST(2,10,\"recurring_monthly\")",
        "A50": "=PIVOT(10, 10, FALSE, FALSE)"
      },
      "styles": {
        "A7": 1,
        "A23": 1,
        "A36": 1,
        "A49": 1,
        "E23": 1,
        "E36": 1,
        "A24": 2,
        "A37": 2,
        "A50": 2,
        "E24": 2,
        "E37": 2,
        "A25:B34": 3,
        "C25:C30": 3,
        "A38:C47": 3,
        "A51:C60": 3,
        "E25:G34": 3,
        "E38:G47": 3,
        "B24:C24": 4,
        "B37:C37": 4,
        "B50:C50": 4,
        "F24:G24": 4,
        "F37:G37": 4
      },
      "formats": {},
      "borders": {
        "A23:C23": 1,
        "A36:C36": 1,
        "A49:C49": 1,
        "A7:G7": 1,
        "E23:G23": 1,
        "E36:G36": 1,
        "A24:C24": 2,
        "A37:C37": 2,
        "A50:C50": 2,
        "A8:G8": 2,
        "E24:G24": 2,
        "E37:G37": 2,
        "A25:C25": 3,
        "A38:C38": 3,
        "A51:C51": 3,
        "E25:G25": 3,
        "E38:G38": 3,
        "A26:C34": 4,
        "A39:C47": 4,
        "A52:C60": 4,
        "E26:G34": 4,
        "E39:G47": 4,
        "A35:C35": 5,
        "A48:C48": 5,
        "A61:C61": 5,
        "E35:G35": 5,
        "E48:G48": 5
      },
      "conditionalFormats": [
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "C51:C60" },
          "id": "a20481e0-1a94-4a52-9164-dedaea7b9fb8",
          "ranges": ["A51:A60"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "G25:G34" },
          "id": "5c9d17b1-61ec-4f6d-80f6-dc2630e5ddc7",
          "ranges": ["E25:E34"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "C25:C34" },
          "id": "b21a4c37-53f0-4707-85b6-392966e4b0ef",
          "ranges": ["A25:A34"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "C38:C47" },
          "id": "052bb1e2-9c17-4b3d-8576-ab79ac9f560a",
          "ranges": ["A38:A47"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "G38:G47" },
          "id": "93a6920e-f56b-4a9a-9af2-dfe037744b2f",
          "ranges": ["E38:E47"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "a5dcffea-a653-44c3-9563-773e5979da47",
          "width": 209,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "New Subscriptions", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "Data!E2",
            "baselineDescr": { "text": "MRR" },
            "keyValue": "Data!D2",
            "humanize": false,
            "chartId": "a5dcffea-a653-44c3-9563-773e5979da47"
          },
          "offset": { "x": 0, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "259c7a2c-c4ae-4471-8b64-1292ef24ce47",
          "width": 210,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Churn", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "Data!E8",
            "baselineDescr": { "text": "MRR" },
            "keyValue": "Data!B8",
            "humanize": false,
            "chartId": "259c7a2c-c4ae-4471-8b64-1292ef24ce47"
          },
          "offset": { "x": 220, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "d6573225-1b5e-4a1d-930b-19071b5023c4",
          "width": 215,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": { "text": "MRR Evolution", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!C10",
            "baselineDescr": "",
            "keyValue": "Data!D10",
            "humanize": false,
            "chartId": "d6573225-1b5e-4a1d-930b-19071b5023c4"
          },
          "offset": { "x": 442, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "a6a21399-abd8-4175-8239-648be24e3cea",
          "width": 882,
          "height": 342,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["event_type"],
              "measure": "mrr_change_normalized",
              "order": null,
              "resModel": "sale.order.log.report",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [
                ["event_type", "!=", "3_transfer"]
              ],
              "groupBy": ["event_type"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "dataSets": [
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": true,
            "axesDesign": {
              "y": {
                "title": { "text": "MRR Change" }
              }
            },
            "chartId": "a6a21399-abd8-4175-8239-648be24e3cea",
            "fieldMatching": {
              "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
              "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
              "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
              "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 174 },
          "col": 0,
          "row": 0
        },
        {
          "id": "f1b6db9c-ddb7-495f-916c-4f918492ffc4",
          "width": 212,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Non Rec. Rev.", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!D13",
            "baselineDescr": { "text": "over the period" },
            "keyValue": "Data!D12",
            "humanize": false,
            "chartId": "f1b6db9c-ddb7-495f-916c-4f918492ffc4"
          },
          "offset": { "x": 670, "y": 9 },
          "col": 0,
          "row": 0
        }
      ],
      "tables": [
        {
          "range": "A24:C34",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A37:C47",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A50:C60",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E24:G34",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E37:G47",
          "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": "6082093e-fde4-497f-82a2-5d88ffde8e01",
      "name": "Data",
      "colNumber": 26,
      "rowNumber": 102,
      "rows": {},
      "cols": {
        "0": { "size": 138 },
        "1": { "size": 66 }
      },
      "merges": [],
      "cells": {
        "A1": "=_t(\"KPI\")",
        "A2": "=_t(\"New subscriptions\")",
        "A3": "=_t(\"New subscriptions ($)\")",
        "A4": "=_t(\"Expansion\")",
        "A5": "=_t(\"Expansion ($)\")",
        "A6": "=_t(\"Contraction\")",
        "A7": "=_t(\"Contraction ($)\")",
        "A8": "=_t(\"Churn\")",
        "A9": "=_t(\"Churn ($)\")",
        "A10": "=_t(\"MRR\")",
        "A11": "=_t(\"Subscriptions\")",
        "A12": "=_t(\"Non-recurring revenue\")",
        "B1": "=_t(\"Current\")",
        "B2": "=PIVOT.VALUE(1,\"order_id\")",
        "B3": "=PIVOT.VALUE(5,\"mrr_change_normalized\")",
        "B4": "=PIVOT.VALUE(2,\"order_id\")",
        "B5": "=PIVOT.VALUE(6,\"mrr_change_normalized\")",
        "B6": "=PIVOT.VALUE(3,\"order_id\")",
        "B7": "=PIVOT.VALUE(7,\"mrr_change_normalized\")",
        "B8": "=PIVOT.VALUE(4,\"order_id\")",
        "B9": "=PIVOT.VALUE(8,\"mrr_change_normalized\")",
        "B10": "=PIVOT.VALUE(9,\"recurring_monthly\")",
        "B11": "=PIVOT.VALUE(9,\"order_reference\")",
        "B12": "=PIVOT.VALUE(12,\"price_subtotal\")",
        "C1": "=_t(\"Previous\")",
        "C10": "=PIVOT.VALUE(13,\"recurring_monthly\")",
        "D1": "=_t(\"Current\")",
        "D2": "=FORMAT.LARGE.NUMBER(B2)",
        "D4": "=FORMAT.LARGE.NUMBER(B4)",
        "D6": "=FORMAT.LARGE.NUMBER(B6)",
        "D8": "=FORMAT.LARGE.NUMBER(B8)",
        "D10": "=FORMAT.LARGE.NUMBER(B10)",
        "D11": "=FORMAT.LARGE.NUMBER(B11)",
        "D12": "=FORMAT.LARGE.NUMBER(B12)",
        "E1": "=_t(\"Previous\")",
        "E2": "=FORMAT.LARGE.NUMBER(B3)",
        "E4": "=FORMAT.LARGE.NUMBER(B5)",
        "E6": "=FORMAT.LARGE.NUMBER(B7)",
        "E8": "=FORMAT.LARGE.NUMBER(B9)",
        "E10": "=FORMAT.LARGE.NUMBER(C10)",
        "E11": "=FORMAT.LARGE.NUMBER(C11)"
      },
      "styles": { "A1:E1": 5 },
      "formats": {},
      "borders": { "C9": 6, "C10": 7, "C11": 8, "D10": 9 },
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "fontSize": 16, "bold": true },
    "2": { "fontSize": 11, "bold": true },
    "3": { "textColor": "#434343", "verticalAlign": "middle" },
    "4": { "fontSize": 11, "bold": true, "align": "center" },
    "5": { "bold": true }
  },
  "formats": {},
  "borders": {
    "1": {
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "2": {
      "top": { "style": "thin", "color": "#CCCCCC" }
    },
    "3": {
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thick", "color": "#FFFFFF" }
    },
    "6": {
      "bottom": { "style": "thin", "color": "#2D7E84" }
    },
    "7": {
      "top": { "style": "thin", "color": "#2D7E84" },
      "right": { "style": "thin", "color": "#2D7E84" },
      "bottom": { "style": "thin", "color": "#2D7E84" }
    },
    "8": {
      "top": { "style": "thin", "color": "#2D7E84" }
    },
    "9": {
      "left": { "style": "thin", "color": "#2D7E84" }
    }
  },
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "m/d/yyyy",
      "timeFormat": "hh:mm:ss a",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {
    "1": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "0_creation"]
      ],
      "id": "1",
      "measures": [
        { "id": "order_id", "fieldName": "order_id" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "1",
      "columns": [],
      "rows": []
    },
    "2": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "1_expansion"]
      ],
      "id": "2",
      "measures": [
        { "id": "order_id", "fieldName": "order_id" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "2",
      "columns": [],
      "rows": []
    },
    "3": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "15_contraction"]
      ],
      "id": "3",
      "measures": [
        { "id": "order_id", "fieldName": "order_id" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "3",
      "columns": [],
      "rows": []
    },
    "4": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "2_churn"]
      ],
      "id": "4",
      "measures": [
        { "id": "order_id", "fieldName": "order_id" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "4",
      "columns": [],
      "rows": []
    },
    "5": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "0_creation"]
      ],
      "id": "5",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized", "aggregator": "sum" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "5",
      "columns": [],
      "rows": []
    },
    "6": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "1_expansion"]
      ],
      "id": "6",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized", "aggregator": "sum" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "6",
      "columns": [],
      "rows": []
    },
    "7": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "15_contraction"]
      ],
      "id": "7",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized", "aggregator": "sum" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "7",
      "columns": [],
      "rows": []
    },
    "8": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "=", "2_churn"]
      ],
      "id": "8",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized", "aggregator": "sum" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": null,
      "formulaId": "8",
      "columns": [],
      "rows": []
    },
    "9": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "date", "type": "datetime", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_product": 1,
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1
      },
      "domain": [
        "&",
        ["is_subscription", "=", true],
        [
          "subscription_state",
          "in",
          ["3_progress", "4_paused"]
        ]
      ],
      "id": "9",
      "measures": [
        { "id": "recurring_monthly", "fieldName": "recurring_monthly", "aggregator": "sum" },
        { "id": "order_reference", "fieldName": "order_reference", "aggregator": "count" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": null,
      "formulaId": "9",
      "columns": [],
      "rows": []
    },
    "10": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_group_by_product": 1,
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1
      },
      "domain": [
        "&",
        ["is_subscription", "=", true],
        [
          "subscription_state",
          "not in",
          ["3_progress", "4_paused"]
        ]
      ],
      "id": "10",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "aggregator": "count",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "aggregator": "sum",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Plans",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "10",
      "columns": [],
      "rows": [
        { "fieldName": "template_id" }
      ]
    },
    "12": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "date", "type": "datetime", "offset": 0 },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" },
        "2967df50-3aec-4336-af5d-4eaceb383120": {}
      },
      "context": {
        "search_default_Sales": 1,
        "group_by": [],
        "search_default_filter_order_date": 1,
        "search_default_recurring": 0,
        "search_default_non_recurring": 1
      },
      "domain": "[\"&\", (\"state\", \"!=\", \"cancel\"), \"&\", (\"state\", \"not in\", (\"draft\", \"cancel\", \"sent\")), (\"product_tmpl_id.recurring_invoice\", \"!=\", True)]",
      "id": "12",
      "measures": [
        { "id": "price_subtotal", "fieldName": "price_subtotal", "aggregator": "sum" }
      ],
      "model": "sale.report",
      "name": "Sales Analysis",
      "sortedColumn": null,
      "formulaId": "12",
      "columns": [],
      "rows": []
    },
    "13": {
      "type": "ODOO",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "date", "type": "datetime", "offset": -1 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      },
      "context": {
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1,
        "search_default_recurring": 1,
        "search_default_non_recurring": 0
      },
      "domain": [
        "&",
        "&",
        ["is_subscription", "=", true],
        [
          "subscription_state",
          "not in",
          ["2_renewal", "5_renewed"]
        ],
        "&",
        "|",
        ["subscription_state", "=", "3_progress"],
        ["subscription_state", "=", "4_paused"],
        ["product_tmpl_id.recurring_invoice", "=", true]
      ],
      "id": "13",
      "measures": [
        { "id": "recurring_monthly", "fieldName": "recurring_monthly", "aggregator": "sum" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": null,
      "formulaId": "13",
      "columns": [],
      "rows": []
    }
  },
  "pivotNextId": 14,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "5dac8b40-3868-4049-a237-6fc28656c7a4",
      "type": "date",
      "label": "Period",
      "defaultValue": "this_month"
    },
    {
      "id": "2967df50-3aec-4336-af5d-4eaceb383120",
      "type": "relation",
      "label": "Country",
      "defaultValueDisplayNames": [],
      "modelName": "res.country"
    },
    {
      "id": "4e294d4b-9dae-401f-a278-49a0237387a6",
      "type": "relation",
      "label": "Sales Team",
      "defaultValueDisplayNames": [],
      "modelName": "crm.team"
    },
    {
      "id": "64c04791-cd96-44a0-9fc2-4edbc062f23d",
      "type": "relation",
      "label": "Salesperson",
      "defaultValue": { "operator": "in", "ids": "current_user" },
      "defaultValueDisplayNames": [],
      "modelName": "res.users"
    }
  ],
  "lists": {
    "1": {
      "columns": ["order_id", "amount_signed", "recurring_monthly"],
      "domain": [
        ["event_type", "=", "2_churn"]
      ],
      "model": "sale.order.log.report",
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false }
      ],
      "id": "1",
      "name": "MRR Growth by Monthly Recurring Revenue",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      }
    },
    "2": {
      "columns": ["order_id", "amount_signed", "recurring_monthly"],
      "domain": [
        ["event_type", "=", "1_expansion"]
      ],
      "model": "sale.order.log.report",
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false }
      ],
      "id": "2",
      "name": "MRR Growth by Monthly Recurring Revenue",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      }
    },
    "3": {
      "columns": ["order_id", "amount_signed", "recurring_monthly"],
      "domain": [
        ["event_type", "=", "0_creation"]
      ],
      "model": "sale.order.log.report",
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false }
      ],
      "id": "3",
      "name": "MRR Growth by Monthly Recurring Revenue",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      }
    },
    "4": {
      "columns": ["order_id", "amount_signed", "recurring_monthly"],
      "domain": [
        ["event_type", "=", "15_contraction"]
      ],
      "model": "sale.order.log.report",
      "context": { "search_default_group_by_event_date": 1 },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false }
      ],
      "id": "4",
      "name": "MRR Analysis by Monthly Recurring Revenue",
      "fieldMatching": {
        "5dac8b40-3868-4049-a237-6fc28656c7a4": { "chain": "first_contract_date", "type": "date", "offset": 0 },
        "2967df50-3aec-4336-af5d-4eaceb383120": { "chain": "country_id", "type": "many2one" },
        "4e294d4b-9dae-401f-a278-49a0237387a6": { "chain": "team_id", "type": "many2one" },
        "64c04791-cd96-44a0-9fc2-4edbc062f23d": { "chain": "user_id", "type": "many2one" }
      }
    }
  },
  "listNextId": 5,
  "chartOdooMenusReferences": {
    "a6a21399-abd8-4175-8239-648be24e3cea": "sale_subscription.menu_sale_subscription_root",
    "f1b6db9c-ddb7-495f-916c-4f918492ffc4": "sale_subscription.menu_sale_subscription_action",
    "259c7a2c-c4ae-4471-8b64-1292ef24ce47": "sale_subscription.menu_sale_subscription_action",
    "a5dcffea-a653-44c3-9563-773e5979da47": "sale_subscription.menu_sale_subscription_action",
    "d6573225-1b5e-4a1d-930b-19071b5023c4": "sale_subscription.menu_sale_subscription_action"
  }
}
