{
  "version": "18.5.10",
  "sheets": [
    {
      "id": "sheet1",
      "name": "Dashboard",
      "colNumber": 7,
      "rowNumber": 91,
      "rows": {
        "6": { "size": 40 },
        "21": { "size": 40 },
        "22": { "size": 40 },
        "36": { "size": 40 },
        "37": { "size": 40 },
        "38": { "size": 29 },
        "39": { "size": 29 },
        "40": { "size": 29 },
        "41": { "size": 29 },
        "42": { "size": 29 },
        "43": { "size": 29 },
        "44": { "size": 29 },
        "45": { "size": 29 },
        "46": { "size": 29 },
        "47": { "size": 29 },
        "49": { "size": 40 },
        "50": { "size": 40 },
        "51": { "size": 29 },
        "52": { "size": 29 },
        "53": { "size": 29 },
        "54": { "size": 29 },
        "55": { "size": 29 },
        "56": { "size": 29 },
        "57": { "size": 29 },
        "58": { "size": 29 },
        "59": { "size": 29 },
        "60": { "size": 29 },
        "62": { "size": 40 },
        "63": { "size": 40 },
        "64": { "size": 29 },
        "65": { "size": 29 },
        "66": { "size": 29 },
        "67": { "size": 29 },
        "68": { "size": 29 },
        "69": { "size": 29 },
        "70": { "size": 29 },
        "71": { "size": 29 },
        "72": { "size": 29 },
        "73": { "size": 29 },
        "75": { "size": 40 },
        "76": { "size": 40 },
        "77": { "size": 29 },
        "78": { "size": 29 },
        "79": { "size": 29 },
        "80": { "size": 29 },
        "81": { "size": 29 },
        "82": { "size": 29 },
        "83": { "size": 29 },
        "84": { "size": 29 },
        "85": { "size": 29 },
        "86": { "size": 29 }
      },
      "cols": {
        "0": { "size": 275 },
        "1": { "size": 114 },
        "2": { "size": 100 },
        "3": { "size": 50 },
        "4": { "size": 274 },
        "5": { "size": 114 },
        "6": { "size": 100 }
      },
      "merges": [],
      "cells": {
        "A7": "[MRR by Products Category](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"event_type\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"pie\",\"graph_groupbys\":[\"event_type\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A22": "[MRR by Country](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"country_id\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"pie\",\"graph_groupbys\":[\"country_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A37": "[Top Quotations](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",[\"subscription_state\",\"in\",[\"1_draft\",\"2_renewal\",\"3_progress\",\"4_paused\",\"5_renewed\",\"6_churn\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order\",\"views\":[[false,\"list\"],[false,\"kanban\"],[false,\"calendar\"],[false,\"form\"],[false,\"pivot\"],[false,\"graph\"],[false,\"cohort\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Quotations\"})",
        "A38": "=ODOO.LIST.HEADER(2, \"partner_id\")",
        "A39": "=ODOO.LIST(2,1,\"partner_id\")",
        "A40": "=ODOO.LIST(2,2,\"partner_id\")",
        "A41": "=ODOO.LIST(2,3,\"partner_id\")",
        "A42": "=ODOO.LIST(2,4,\"partner_id\")",
        "A43": "=ODOO.LIST(2,5,\"partner_id\")",
        "A44": "=ODOO.LIST(2,6,\"partner_id\")",
        "A45": "=ODOO.LIST(2,7,\"partner_id\")",
        "A46": "=ODOO.LIST(2,8,\"partner_id\")",
        "A47": "=ODOO.LIST(2,9,\"partner_id\")",
        "A48": "=ODOO.LIST(2,10,\"partner_id\")",
        "A50": "[Top Plans](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[\"product_id\"],\"pivot_measures\":[\"recurring_monthly\",\"order_reference\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"template_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})",
        "A51": "=PIVOT(5, 10, FALSE, FALSE)",
        "A63": "[Top Sales Team](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[\"product_id\"],\"pivot_measures\":[\"recurring_monthly\",\"order_reference\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"team_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})",
        "A64": "=PIVOT(6, 10, FALSE, FALSE)",
        "A76": "[Top Recurrences](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[\"product_id\"],\"pivot_measures\":[\"recurring_monthly\",\"order_reference\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"plan_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})",
        "A77": "=PIVOT(9, 10, FALSE, FALSE)",
        "B38": "=ODOO.LIST.HEADER(2, \"user_id\")",
        "B39": "=ODOO.LIST(2,1,\"user_id\")",
        "B40": "=ODOO.LIST(2,2,\"user_id\")",
        "B41": "=ODOO.LIST(2,3,\"user_id\")",
        "B42": "=ODOO.LIST(2,4,\"user_id\")",
        "B43": "=ODOO.LIST(2,5,\"user_id\")",
        "B44": "=ODOO.LIST(2,6,\"user_id\")",
        "B45": "=ODOO.LIST(2,7,\"user_id\")",
        "B46": "=ODOO.LIST(2,8,\"user_id\")",
        "B47": "=ODOO.LIST(2,9,\"user_id\")",
        "B48": "=ODOO.LIST(2,10,\"user_id\")",
        "C38": "=ODOO.LIST.HEADER(2, \"recurring_monthly\", _t(\"MRR\"))",
        "C39": "=ODOO.LIST(2,1,\"recurring_monthly\")",
        "C40": "=ODOO.LIST(2,2,\"recurring_monthly\")",
        "C41": "=ODOO.LIST(2,3,\"recurring_monthly\")",
        "C42": "=ODOO.LIST(2,4,\"recurring_monthly\")",
        "C43": "=ODOO.LIST(2,5,\"recurring_monthly\")",
        "C44": "=ODOO.LIST(2,6,\"recurring_monthly\")",
        "C45": "=ODOO.LIST(2,7,\"recurring_monthly\")",
        "C46": "=ODOO.LIST(2,8,\"recurring_monthly\")",
        "C47": "=ODOO.LIST(2,9,\"recurring_monthly\")",
        "C48": "=ODOO.LIST(2,10,\"recurring_monthly\")",
        "E7": "[MRR by Recurrence](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"plan_id\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"pie\",\"graph_groupbys\":[\"plan_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "E22": "[MRR by Sales Team](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"team_id\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"pie\",\"graph_groupbys\":[\"team_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "E37": "[Top Subscriptions](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]],\"|\",[\"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\"})",
        "E38": "=ODOO.LIST.HEADER(1, \"partner_id\")",
        "E39": "=ODOO.LIST(1,1,\"partner_id\")",
        "E40": "=ODOO.LIST(1,2,\"partner_id\")",
        "E41": "=ODOO.LIST(1,3,\"partner_id\")",
        "E42": "=ODOO.LIST(1,4,\"partner_id\")",
        "E43": "=ODOO.LIST(1,5,\"partner_id\")",
        "E44": "=ODOO.LIST(1,6,\"partner_id\")",
        "E45": "=ODOO.LIST(1,7,\"partner_id\")",
        "E46": "=ODOO.LIST(1,8,\"partner_id\")",
        "E47": "=ODOO.LIST(1,9,\"partner_id\")",
        "E48": "=ODOO.LIST(1,10,\"partner_id\")",
        "E50": "[Top Products](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]]],\"context\":{\"group_by\":[],\"pivot_measures\":[\"order_reference\",\"recurring_monthly\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"product_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})",
        "E51": "=PIVOT(4, 10, FALSE, FALSE)",
        "E63": "[Top Salesman](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[\"&\",\"&\",[\"is_subscription\",\"=\",true],[\"subscription_state\",\"in\",[\"3_progress\",\"4_paused\"]],\"|\",[\"subscription_state\",\"=\",\"3_progress\"],[\"subscription_state\",\"=\",\"4_paused\"]],\"context\":{\"group_by\":[\"product_id\"],\"pivot_measures\":[\"recurring_monthly\",\"order_reference\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"user_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})",
        "E64": "=PIVOT(7, 10, FALSE, FALSE)",
        "E77": "=PIVOT(8, 10, FALSE, FALSE)",
        "F38": "=ODOO.LIST.HEADER(1, \"user_id\")",
        "F39": "=ODOO.LIST(1,1,\"user_id\")",
        "F40": "=ODOO.LIST(1,2,\"user_id\")",
        "F41": "=ODOO.LIST(1,3,\"user_id\")",
        "F42": "=ODOO.LIST(1,4,\"user_id\")",
        "F43": "=ODOO.LIST(1,5,\"user_id\")",
        "F44": "=ODOO.LIST(1,6,\"user_id\")",
        "F45": "=ODOO.LIST(1,7,\"user_id\")",
        "F46": "=ODOO.LIST(1,8,\"user_id\")",
        "F47": "=ODOO.LIST(1,9,\"user_id\")",
        "F48": "=ODOO.LIST(1,10,\"user_id\")",
        "G38": "=ODOO.LIST.HEADER(1, \"recurring_monthly\", _t(\"MRR\"))",
        "G39": "=ODOO.LIST(1,1,\"recurring_monthly\")",
        "G40": "=ODOO.LIST(1,2,\"recurring_monthly\")",
        "G41": "=ODOO.LIST(1,3,\"recurring_monthly\")",
        "G42": "=ODOO.LIST(1,4,\"recurring_monthly\")",
        "G43": "=ODOO.LIST(1,5,\"recurring_monthly\")",
        "G44": "=ODOO.LIST(1,6,\"recurring_monthly\")",
        "G45": "=ODOO.LIST(1,7,\"recurring_monthly\")",
        "G46": "=ODOO.LIST(1,8,\"recurring_monthly\")",
        "G47": "=ODOO.LIST(1,9,\"recurring_monthly\")",
        "G48": "=ODOO.LIST(1,10,\"recurring_monthly\")"
      },
      "styles": {
        "A7": 1,
        "A22": 1,
        "A37": 1,
        "A50": 1,
        "A63": 1,
        "A76": 1,
        "E7": 1,
        "E22": 1,
        "E37": 1,
        "E50": 1,
        "E63": 1,
        "E76": 1,
        "A51": 2,
        "A64": 2,
        "A77": 2,
        "A38:B38": 2,
        "E64": 2,
        "E77": 2,
        "E38:F38": 2,
        "E51:F51": 2,
        "A39:C48": 3,
        "A52:C61": 3,
        "A65:C74": 3,
        "A78:C87": 3,
        "E39:G48": 3,
        "E52:G61": 3,
        "E65:G74": 3,
        "E78:G87": 3,
        "C38": 4,
        "B51:C51": 4,
        "B64:C64": 4,
        "B77:C77": 4,
        "G38": 4,
        "G51": 4,
        "F64:G64": 4,
        "F77:G77": 4
      },
      "formats": {},
      "borders": {
        "A7:C7": 1,
        "A22:C22": 1,
        "A37:C37": 1,
        "A50:C50": 1,
        "A63:C63": 1,
        "A76:C76": 1,
        "E7:G7": 1,
        "E22:G22": 1,
        "E37:G37": 1,
        "E50:G50": 1,
        "E63:G63": 1,
        "A8:C8": 2,
        "A23:C23": 2,
        "A38:C38": 2,
        "A51:C51": 2,
        "A64:C64": 2,
        "E8:G8": 2,
        "E23:G23": 2,
        "E38:G38": 2,
        "E51:G51": 2,
        "E64:G64": 2,
        "A39:C39": 3,
        "A52:C52": 3,
        "A65:C65": 3,
        "A78:C78": 3,
        "E39:G39": 3,
        "E52:G52": 3,
        "E65:G65": 3,
        "E78:G78": 3,
        "A40:C48": 4,
        "A53:C61": 4,
        "A66:C74": 4,
        "A79:C87": 4,
        "E40:G48": 4,
        "E53:G61": 4,
        "E66:G74": 4,
        "E79:G87": 4,
        "A49:C49": 5,
        "A62:C62": 5,
        "A75:C75": 5,
        "A88:C88": 5,
        "E49:G49": 5,
        "E62:G62": 5,
        "E75:G75": 5,
        "E88:G88": 5
      },
      "conditionalFormats": [
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "C52:C61" },
          "id": "a6a2a4dd-3f0f-40f2-a5f7-1556d0061717",
          "ranges": ["A52:A61"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "G52:G61" },
          "id": "50dc872e-92aa-41b4-a35e-1a65f3a1daa0",
          "ranges": ["E52:E61"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "C65:C74" },
          "id": "d34123f8-de5e-432d-9adb-57b0669ce225",
          "ranges": ["A65:A74"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "G65:G74" },
          "id": "baa3d9df-cc13-4d21-958e-81b1aefba124",
          "ranges": ["E65:E74"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "G78:G87" },
          "id": "de99a6f1-28a6-46bf-be58-0f1cc31853b0",
          "ranges": ["E78:E87"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "C78:C87" },
          "id": "7da51d8e-ae22-44a4-bc36-03bdf51f31da",
          "ranges": ["A78:A87"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "C39:C48" },
          "id": "dfe0b361-bb44-47d7-aa06-5680833e46e6",
          "ranges": ["A39:A48"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "G39:G48" },
          "id": "544404fc-03ad-411d-adf7-aae3adf0aa0f",
          "ranges": ["E39:E48"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "51823220-f22b-4359-8711-579a249c91bb",
          "width": 215,
          "height": 111,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Monthly Rec. Rev.", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!D4",
            "baselineDescr": { "text": "ARR" },
            "keyValue": "Data!D3",
            "humanize": false,
            "chartId": "51823220-f22b-4359-8711-579a249c91bb"
          },
          "offset": { "x": 7, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "67858d0e-b5ba-4a3c-bf9e-c0fceaeedf65",
          "width": 215,
          "height": 111,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Subscriptions", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "Data!B7",
            "baselineDescr": { "text": "/sub." },
            "keyValue": "Data!B6",
            "humanize": false,
            "chartId": "67858d0e-b5ba-4a3c-bf9e-c0fceaeedf65"
          },
          "offset": { "x": 233, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "2461b920-4fdd-4b3f-8bc5-8e33bd818987",
          "width": 490,
          "height": 320,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["plan_id"],
              "measure": "recurring_monthly",
              "order": null,
              "resModel": "sale.subscription.report",
              "mode": "pie"
            },
            "searchParams": {
              "comparison": null,
              "context": {
                "search_default_filter_progress": 1,
                "search_default_filter_paused": 1,
                "search_default_recurring": 1,
                "search_default_non_recurring": 0
              },
              "domain": [
                "&",
                "&",
                "&",
                ["product_tmpl_id.recurring_invoice", "=", true],
                [
                  "subscription_state",
                  "in",
                  ["3_progress", "4_paused"]
                ],
                ["recurring_monthly", "!=", false],
                ["state", "!=", "cancel"]
              ],
              "groupBy": ["plan_id"],
              "orderBy": []
            },
            "type": "odoo_pie",
            "dataSets": [
              {}
            ],
            "chartId": "2461b920-4fdd-4b3f-8bc5-8e33bd818987",
            "fieldMatching": {
              "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
              "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
              "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
              "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
              "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
              "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
              "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
            }
          },
          "offset": { "x": 537, "y": 178 },
          "col": 0,
          "row": 0
        },
        {
          "id": "38f6014f-c8a5-41e7-8cba-c8682b567473",
          "width": 489,
          "height": 339,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["country_id"],
              "measure": "recurring_monthly",
              "order": null,
              "resModel": "sale.subscription.report",
              "mode": "pie"
            },
            "searchParams": {
              "comparison": null,
              "context": {
                "search_default_filter_progress": 1,
                "search_default_filter_paused": 1,
                "search_default_recurring": 1,
                "search_default_non_recurring": 0
              },
              "domain": [
                "&",
                "&",
                "&",
                ["product_tmpl_id.recurring_invoice", "=", true],
                [
                  "subscription_state",
                  "in",
                  ["3_progress", "4_paused"]
                ],
                ["recurring_monthly", "!=", false],
                ["state", "!=", "cancel"]
              ],
              "groupBy": ["country_id"],
              "orderBy": []
            },
            "type": "odoo_pie",
            "dataSets": [
              {}
            ],
            "chartId": "38f6014f-c8a5-41e7-8cba-c8682b567473",
            "fieldMatching": {
              "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
              "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
              "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
              "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
              "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
              "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
              "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 540 },
          "col": 0,
          "row": 0
        },
        {
          "id": "a1de0db0-db97-4b9f-b581-f103544da310",
          "width": 490,
          "height": 340,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["team_id"],
              "measure": "recurring_monthly",
              "order": null,
              "resModel": "sale.subscription.report",
              "mode": "pie"
            },
            "searchParams": {
              "comparison": null,
              "context": {
                "search_default_filter_progress": 1,
                "search_default_filter_paused": 1,
                "search_default_recurring": 1,
                "search_default_non_recurring": 0
              },
              "domain": [
                "&",
                "&",
                "&",
                ["product_tmpl_id.recurring_invoice", "=", true],
                [
                  "subscription_state",
                  "in",
                  ["3_progress", "4_paused"]
                ],
                ["recurring_monthly", "!=", false],
                ["state", "!=", "cancel"]
              ],
              "groupBy": ["team_id"],
              "orderBy": []
            },
            "type": "odoo_pie",
            "dataSets": [
              {}
            ],
            "chartId": "a1de0db0-db97-4b9f-b581-f103544da310",
            "fieldMatching": {
              "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
              "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
              "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
              "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
              "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
              "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
              "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
            }
          },
          "offset": { "x": 537, "y": 540 },
          "col": 0,
          "row": 0
        },
        {
          "id": "096cbdfa-ca41-4fb7-abec-12773c2f4e9b",
          "width": 213,
          "height": 111,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Cust. Lifespan", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baselineDescr": { "text": "Month(s)" },
            "keyValue": "Data!D11",
            "humanize": false,
            "chartId": "096cbdfa-ca41-4fb7-abec-12773c2f4e9b"
          },
          "offset": { "x": 458, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "c89ec529-8055-4dee-b7ba-8a1e8680f82b",
          "width": 213,
          "height": 111,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Cust. Lifetime Value", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baselineDescr": "",
            "keyValue": "Data!D12",
            "humanize": false,
            "chartId": "c89ec529-8055-4dee-b7ba-8a1e8680f82b"
          },
          "offset": { "x": 682, "y": 9 },
          "col": 0,
          "row": 0
        },
        {
          "id": "2673174b-3fc1-4807-9d5f-8fad50c73c17",
          "width": 489,
          "height": 320,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["categ_id"],
              "measure": "recurring_monthly",
              "order": null,
              "resModel": "sale.subscription.report",
              "mode": "pie"
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [
                "&",
                "&",
                ["is_subscription", "=", true],
                "|",
                ["subscription_state", "=", "3_progress"],
                ["subscription_state", "=", "4_paused"],
                ["product_tmpl_id.recurring_invoice", "=", true]
              ],
              "groupBy": ["categ_id"],
              "orderBy": []
            },
            "type": "odoo_pie",
            "actionXmlId": "sale_subscription.sale_subscription_report_analysis_action",
            "dataSets": [
              {}
            ],
            "chartId": "2673174b-3fc1-4807-9d5f-8fad50c73c17",
            "fieldMatching": {
              "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
              "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
              "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
              "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
              "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
              "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
              "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 178 },
          "col": 0,
          "row": 0
        },
        {
          "id": "41a939b0-5396",
          "col": 3,
          "row": 75,
          "offset": { "x": 49, "y": 6 },
          "width": 489,
          "height": 385,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "a1a6cd7a-8749": {
                "title": {},
                "background": "#FFFFFF",
                "legendPosition": "left",
                "metaData": {
                  "groupBy": ["country_id"],
                  "measure": "recurring_monthly",
                  "order": null,
                  "resModel": "sale.subscription.report",
                  "mode": "bar"
                },
                "searchParams": {
                  "context": {},
                  "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]
                  ],
                  "groupBy": ["country_id"],
                  "orderBy": []
                },
                "type": "odoo_geo",
                "actionXmlId": "sale_subscription.sale_subscription_report_analysis_action",
                "dataSets": [
                  {}
                ],
                "colorScale": "blues"
              }
            },
            "items": [
              { "type": "chart", "chartId": "a1a6cd7a-8749", "title": "Map" },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "title": {
              "text": "Top Countries",
              "fontSize": 21,
              "color": "#01666B",
              "bold": true
            },
            "fieldMatching": {
              "a1a6cd7a-8749": {
                "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
                "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
                "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
                "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
                "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
                "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
                "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
              }
            }
          }
        }
      ],
      "tables": [
        {
          "range": "A38:C48",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A51:C61",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A64:C74",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A77:C87",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E38:G48",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E51:G61",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E64:G74",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E77:G87",
          "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": "eae01f9c-c461-4489-ade4-957ef2459d40",
      "name": "Data",
      "colNumber": 26,
      "rowNumber": 104,
      "rows": {},
      "cols": {
        "0": { "size": 215 },
        "1": { "size": 89 },
        "2": { "size": 89 },
        "3": { "size": 162 },
        "4": { "size": 89 }
      },
      "merges": [],
      "cells": {
        "A1": "=_t(\"KPI\")",
        "A2": "=PIVOT.HEADER(1,\"measure\",\"mrr_change_normalized\")",
        "A3": "=PIVOT.HEADER(2,\"measure\",\"recurring_monthly:sum\")",
        "A4": "=PIVOT.HEADER(2,\"measure\",\"recurring_yearly\")",
        "A5": "=_t(\"New MRR\")",
        "A6": "=_t(\"Total Subscriptions\")",
        "A7": "=_t(\"Avg MRR / Subscriptions\")",
        "A8": "=_t(\"Churned\")",
        "A9": "=_t(\"Churned %\")",
        "A10": "=_t(\"Total churned\")",
        "A11": "=_t(\"Lifespan\")",
        "A12": "=_t(\"Lifetime Value\")",
        "B1": "=_t(\"Current\")",
        "B2": "=PIVOT.VALUE(1,\"mrr_change_normalized\")",
        "B3": "=PIVOT.VALUE(2,\"recurring_monthly:sum\")",
        "B4": "=PIVOT.VALUE(2,\"recurring_yearly\")",
        "B5": "=IFERROR(PIVOT.VALUE(3,\"mrr_change_normalized\",\"event_type\",\"0_creation\",\"event_date:year\",YEAR(NOW())))",
        "B6": "=PIVOT.VALUE(10,\"order_reference\")",
        "B7": "=IFERROR(B3/B6)",
        "B8": "=PIVOT.VALUE(11,\"order_reference\")",
        "B9": "=B8/(B6+B8)",
        "B10": "=PIVOT.VALUE(12,\"price_subtotal\")",
        "B11": "=1/B9",
        "B12": "=B7/B9",
        "C1": "=_t(\"Previous\")",
        "C5": "=PIVOT.VALUE(3,\"mrr_change_normalized\",\"event_type\",\"0_creation\",\"event_date:year\",YEAR(NOW())-1)",
        "D1": "=_t(\"Current\")",
        "D2": "=IFERROR(FORMAT.LARGE.NUMBER(B2))",
        "D3": "=IFERROR(FORMAT.LARGE.NUMBER(B3))",
        "D4": "=IFERROR(FORMAT.LARGE.NUMBER(B4))",
        "D5": "=IFERROR(FORMAT.LARGE.NUMBER(B5))",
        "D6": "=IFERROR(FORMAT.LARGE.NUMBER(B6))",
        "D7": "=IFERROR(FORMAT.LARGE.NUMBER(B7))",
        "D8": "=IFERROR(FORMAT.LARGE.NUMBER(B8))",
        "D9": "=IFERROR(FORMAT.LARGE.NUMBER(B9))",
        "D10": "=-IFERROR(FORMAT.LARGE.NUMBER(B10))",
        "D11": "=IFERROR(FORMAT.LARGE.NUMBER(B11))",
        "D12": "=FORMAT.LARGE.NUMBER(B12)",
        "E1": "=_t(\"Previous\")",
        "E5": "=IFERROR(FORMAT.LARGE.NUMBER(C5))"
      },
      "styles": { "A1:E1": 5, "C5": 6, "D2": 6, "D4:D12": 6, "E2:E12": 6 },
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "textColor": "#01666b", "bold": true, "fontSize": 16 },
    "2": { "textColor": "#434343", "bold": true, "fontSize": 11 },
    "3": { "textColor": "#434343", "verticalAlign": "middle" },
    "4": {
      "textColor": "#434343",
      "bold": true,
      "fontSize": 11,
      "align": "center"
    },
    "5": { "bold": true },
    "6": { "fillColor": "#F3F3F3" }
  },
  "formats": {},
  "borders": {
    "1": {
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "2": {
      "top": { "style": "thin", "color": "#CCCCCC" }
    },
    "3": {
      "bottom": { "style": "thin", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thin", "color": "#FFFFFF" },
      "bottom": { "style": "thin", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thin", "color": "#FFFFFF" }
    }
  },
  "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": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": {},
        "85d94827-6ce2-429c-9775-ef646cfddb6b": {}
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "!=", "3_transfer"]
      ],
      "id": "1",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "desc",
        "domain": []
      },
      "formulaId": "1",
      "columns": [],
      "rows": []
    },
    "2": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "2",
      "measures": [
        { "id": "recurring_yearly", "fieldName": "recurring_yearly" },
        {
          "id": "recurring_monthly:sum",
          "fieldName": "recurring_monthly",
          "aggregator": "sum",
          "isHidden": false
        }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": {
        "measure": "recurring_monthly:sum",
        "order": "desc",
        "domain": []
      },
      "formulaId": "2",
      "columns": [],
      "rows": []
    },
    "3": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": {},
        "85d94827-6ce2-429c-9775-ef646cfddb6b": {}
      },
      "context": {
        "search_default_group_by_event_date": 1,
        "search_default_group_by_event_type": 1
      },
      "domain": [
        ["event_type", "!=", "3_transfer"]
      ],
      "id": "3",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis by Event Date (Year)",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "asc",
        "domain": []
      },
      "formulaId": "3",
      "columns": [
        { "fieldName": "event_date", "granularity": "year" }
      ],
      "rows": [
        { "fieldName": "event_type" }
      ]
    },
    "4": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "4",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Product",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "4",
      "columns": [],
      "rows": [
        { "fieldName": "product_id" }
      ]
    },
    "5": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
      },
      "context": {
        "params": { "model": "sale.subscription.report", "view_type": "pivot" },
        "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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "5",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Plans",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "5",
      "columns": [],
      "rows": [
        { "fieldName": "template_id" }
      ]
    },
    "6": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
      },
      "context": {
        "params": { "model": "sale.subscription.report", "view_type": "pivot" },
        "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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "6",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Sales Team",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "6",
      "columns": [],
      "rows": [
        { "fieldName": "team_id" }
      ]
    },
    "7": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "7",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Salesperson",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "7",
      "columns": [],
      "rows": [
        { "fieldName": "user_id" }
      ]
    },
    "8": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "8",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subcriptions"
        },
        {
          "id": "recurring_monthly",
          "fieldName": "recurring_monthly",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Countries",
      "sortedColumn": {
        "measure": "recurring_monthly",
        "order": "desc",
        "domain": []
      },
      "formulaId": "8",
      "columns": [],
      "rows": [
        { "fieldName": "country_id" }
      ]
    },
    "9": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_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"]
        ],
        ["state", "!=", "cancel"]
      ],
      "id": "9",
      "measures": [
        {
          "id": "order_reference",
          "fieldName": "order_reference",
          "userDefinedName": "# Subscriptions"
        },
        {
          "id": "price_subtotal",
          "fieldName": "price_subtotal",
          "userDefinedName": "Value"
        }
      ],
      "model": "sale.subscription.report",
      "name": "Recurrence",
      "sortedColumn": {
        "measure": "price_subtotal",
        "order": "desc",
        "domain": []
      },
      "formulaId": "9",
      "columns": [],
      "rows": [
        { "fieldName": "plan_id" }
      ]
    },
    "10": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": {},
        "ec466626-f54a-4955-9611-eaa2719f1afb": {},
        "85d94827-6ce2-429c-9775-ef646cfddb6b": {}
      },
      "context": {
        "search_default_group_by_product": 1,
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1
      },
      "domain": [
        "&",
        "&",
        ["is_subscription", "=", true],
        ["subscription_state", "=", "3_progress"],
        ["state", "!=", "cancel"]
      ],
      "id": "10",
      "measures": [
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": null,
      "formulaId": "10",
      "columns": [],
      "rows": []
    },
    "11": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": {},
        "ec466626-f54a-4955-9611-eaa2719f1afb": {},
        "85d94827-6ce2-429c-9775-ef646cfddb6b": {}
      },
      "context": {
        "search_default_group_by_product": 1,
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1
      },
      "domain": [
        "&",
        "&",
        ["is_subscription", "=", true],
        ["subscription_state", "=", "6_churn"],
        ["state", "!=", "cancel"]
      ],
      "id": "11",
      "measures": [
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": null,
      "formulaId": "11",
      "columns": [],
      "rows": []
    },
    "12": {
      "type": "ODOO",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": {},
        "ec466626-f54a-4955-9611-eaa2719f1afb": {},
        "85d94827-6ce2-429c-9775-ef646cfddb6b": {}
      },
      "context": {
        "search_default_group_by_product": 1,
        "search_default_filter_progress": 1,
        "search_default_filter_paused": 1
      },
      "domain": [
        "&",
        "&",
        ["is_subscription", "=", true],
        ["subscription_state", "=", "6_churn"],
        ["state", "!=", "cancel"]
      ],
      "id": "12",
      "measures": [
        { "id": "price_subtotal", "fieldName": "price_subtotal" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis",
      "sortedColumn": null,
      "formulaId": "12",
      "columns": [],
      "rows": []
    }
  },
  "pivotNextId": 13,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "e6db018b-19ec-42c3-b29e-11b1e3910916",
      "type": "relation",
      "label": "Country",
      "defaultValueDisplayNames": [],
      "modelName": "res.country"
    },
    {
      "id": "dbb716a1-5977-47ee-a53e-ca5716303433",
      "type": "relation",
      "label": "Product",
      "defaultValueDisplayNames": [],
      "modelName": "product.template"
    },
    {
      "id": "7d95fe28-fd13-4805-948c-95742e7d6733",
      "type": "relation",
      "label": "Customer",
      "defaultValueDisplayNames": [],
      "modelName": "res.partner"
    },
    {
      "id": "b75963ca-ab5f-4da5-9c90-67526517e5e7",
      "type": "relation",
      "label": "Sales Team",
      "defaultValueDisplayNames": [],
      "modelName": "crm.team"
    },
    {
      "id": "4181e8e3-2e7e-42be-a88b-f24acb7d03e7",
      "type": "relation",
      "label": "Salesperson",
      "defaultValueDisplayNames": [],
      "modelName": "res.users"
    },
    {
      "id": "ec466626-f54a-4955-9611-eaa2719f1afb",
      "type": "relation",
      "label": "Source",
      "defaultValueDisplayNames": [],
      "modelName": "utm.source"
    },
    {
      "id": "85d94827-6ce2-429c-9775-ef646cfddb6b",
      "type": "relation",
      "label": "Medium",
      "defaultValueDisplayNames": [],
      "modelName": "utm.medium"
    }
  ],
  "lists": {
    "1": {
      "columns": ["name", "partner_id", "user_id", "recurring_monthly"],
      "domain": [
        "&",
        "&",
        "&",
        ["product_tmpl_id.recurring_invoice", "=", true],
        [
          "subscription_state",
          "in",
          ["3_progress", "4_paused"]
        ],
        ["recurring_monthly", "!=", false],
        ["state", "!=", "cancel"]
      ],
      "model": "sale.subscription.report",
      "context": {
        "default_is_subscription": 1,
        "search_default_progress": 1,
        "search_default_paused": 1
      },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false },
        { "name": "id", "asc": false }
      ],
      "id": "1",
      "name": "Subscriptions by Monthly Recurring",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
      }
    },
    "2": {
      "columns": ["name", "partner_id", "user_id", "recurring_monthly"],
      "domain": [
        "&",
        "&",
        "&",
        ["product_tmpl_id.recurring_invoice", "=", true],
        ["subscription_state", "=", "1_draft"],
        ["recurring_monthly", "!=", false],
        ["state", "!=", "cancel"]
      ],
      "model": "sale.subscription.report",
      "context": { "default_subscription_state": "1_draft" },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false },
        { "name": "id", "asc": false }
      ],
      "id": "2",
      "name": "Quotations by Monthly Recurring",
      "fieldMatching": {
        "e6db018b-19ec-42c3-b29e-11b1e3910916": { "chain": "country_id", "type": "many2one" },
        "dbb716a1-5977-47ee-a53e-ca5716303433": { "chain": "product_tmpl_id", "type": "many2one" },
        "7d95fe28-fd13-4805-948c-95742e7d6733": { "chain": "partner_id", "type": "many2one" },
        "b75963ca-ab5f-4da5-9c90-67526517e5e7": { "chain": "team_id", "type": "many2one" },
        "4181e8e3-2e7e-42be-a88b-f24acb7d03e7": { "chain": "user_id", "type": "many2one" },
        "ec466626-f54a-4955-9611-eaa2719f1afb": { "chain": "source_id", "type": "many2one" },
        "85d94827-6ce2-429c-9775-ef646cfddb6b": { "chain": "medium_id", "type": "many2one" }
      }
    }
  },
  "listNextId": 15,
  "chartOdooMenusReferences": {
    "51823220-f22b-4359-8711-579a249c91bb": "sale_subscription.menu_sale_subscription_analysis",
    "67858d0e-b5ba-4a3c-bf9e-c0fceaeedf65": "sale_subscription.menu_sale_subscription_analysis",
    "2461b920-4fdd-4b3f-8bc5-8e33bd818987": "sale_subscription.menu_sale_subscription_root",
    "38f6014f-c8a5-41e7-8cba-c8682b567473": "sale_subscription.menu_sale_subscription_root",
    "a1de0db0-db97-4b9f-b581-f103544da310": "sale_subscription.menu_sale_subscription_root",
    "096cbdfa-ca41-4fb7-abec-12773c2f4e9b": "sale_subscription.menu_sale_subscription_analysis",
    "c89ec529-8055-4dee-b7ba-8a1e8680f82b": "sale_subscription.menu_sale_subscription_analysis"
  }
}
