{
  "version": 22,
  "sheets": [
    {
      "id": "sheet1",
      "name": "Dashboard",
      "colNumber": 9,
      "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": 100 },
        "1": { "size": 175 },
        "2": { "size": 114 },
        "3": { "size": 100 },
        "4": { "size": 50 },
        "5": { "size": 100 },
        "6": { "size": 175 },
        "7": { "size": 114 },
        "8": { "size": 100 }
      },
      "merges": [
        "A51:B51",
        "A52:B52",
        "A53:B53",
        "A54:B54",
        "A55:B55",
        "A56:B56",
        "A57:B57",
        "A61:B61",
        "A60:B60",
        "A59:B59",
        "A58:B58",
        "F61:G61",
        "F60:G60",
        "F59:G59",
        "F58:G58",
        "F57:G57",
        "F56:G56",
        "F55:G55",
        "F54:G54",
        "F53:G53",
        "F52:G52",
        "F51:G51",
        "A74:B74",
        "A73:B73",
        "A72:B72",
        "A71:B71",
        "A70:B70",
        "A69:B69",
        "A68:B68",
        "A67:B67",
        "A66:B66",
        "A65:B65",
        "A64:B64",
        "F74:G74",
        "F73:G73",
        "F72:G72",
        "F71:G71",
        "F70:G70",
        "F69:G69",
        "F68:G68",
        "F67:G67",
        "F66:G66",
        "F65:G65",
        "F64:G64",
        "A87:B87",
        "A86:B86",
        "A85:B85",
        "A84:B84",
        "A83:B83",
        "A82:B82",
        "A81:B81",
        "A80:B80",
        "A79:B79",
        "A78:B78",
        "A77:B77",
        "F87:G87",
        "F86:G86",
        "F85:G85",
        "F84:G84",
        "F83:G83",
        "F82:G82",
        "F81:G81",
        "F80:G80",
        "F79:G79",
        "F78:G78",
        "F77:G77",
        "A38:B38",
        "A39:B39",
        "A40:B40",
        "A41:B41",
        "A42:B42",
        "A43:B43",
        "A44:B44",
        "A45:B45",
        "A46:B46",
        "A47:B47",
        "A48:B48",
        "F48:G48",
        "F47:G47",
        "F46:G46",
        "F45:G45",
        "F44:G44",
        "F43:G43",
        "F42:G42",
        "F41:G41",
        "F40:G40",
        "F39:G39"
      ],
      "cells": {
        "A7": {
          "content": "[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": {
          "content": "[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": {
          "content": "[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": { "content": "=_t(\"Customer\")" },
        "A39": { "content": "=ODOO.LIST(2,1,\"partner_id\")" },
        "A40": { "content": "=ODOO.LIST(2,2,\"partner_id\")" },
        "A41": { "content": "=ODOO.LIST(2,3,\"partner_id\")" },
        "A42": { "content": "=ODOO.LIST(2,4,\"partner_id\")" },
        "A43": { "content": "=ODOO.LIST(2,5,\"partner_id\")" },
        "A44": { "content": "=ODOO.LIST(2,6,\"partner_id\")" },
        "A45": { "content": "=ODOO.LIST(2,7,\"partner_id\")" },
        "A46": { "content": "=ODOO.LIST(2,8,\"partner_id\")" },
        "A47": { "content": "=ODOO.LIST(2,9,\"partner_id\")" },
        "A48": { "content": "=ODOO.LIST(2,10,\"partner_id\")" },
        "A50": {
          "content": "[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": { "content": "=_t(\"Plans\")" },
        "A52": { "content": "=PIVOT.HEADER(5,\"#template_id\",1)" },
        "A53": { "content": "=PIVOT.HEADER(5,\"#template_id\",2)" },
        "A54": { "content": "=PIVOT.HEADER(5,\"#template_id\",3)" },
        "A55": { "content": "=PIVOT.HEADER(5,\"#template_id\",4)" },
        "A56": { "content": "=PIVOT.HEADER(5,\"#template_id\",5)" },
        "A57": { "content": "=PIVOT.HEADER(5,\"#template_id\",6)" },
        "A58": { "content": "=PIVOT.HEADER(5,\"#template_id\",7)" },
        "A59": { "content": "=PIVOT.HEADER(5,\"#template_id\",8)" },
        "A60": { "content": "=PIVOT.HEADER(5,\"#template_id\",9)" },
        "A61": { "content": "=PIVOT.HEADER(5,\"#template_id\",10)" },
        "A63": {
          "content": "[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": { "content": "=_t(\"Sales Team\")" },
        "A65": { "content": "=PIVOT.HEADER(6,\"#team_id\",1)" },
        "A66": { "content": "=PIVOT.HEADER(6,\"#team_id\",2)" },
        "A67": { "content": "=PIVOT.HEADER(6,\"#team_id\",3)" },
        "A68": { "content": "=PIVOT.HEADER(6,\"#team_id\",4)" },
        "A69": { "content": "=PIVOT.HEADER(6,\"#team_id\",5)" },
        "A70": { "content": "=PIVOT.HEADER(6,\"#team_id\",6)" },
        "A71": { "content": "=PIVOT.HEADER(6,\"#team_id\",7)" },
        "A72": { "content": "=PIVOT.HEADER(6,\"#team_id\",8)" },
        "A73": { "content": "=PIVOT.HEADER(6,\"#team_id\",9)" },
        "A74": { "content": "=PIVOT.HEADER(6,\"#team_id\",10)" },
        "A76": {
          "content": "[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": { "content": "=_t(\"Recurrence\")" },
        "A78": { "content": "=PIVOT.HEADER(9,\"#plan_id\",1)" },
        "A79": { "content": "=PIVOT.HEADER(9,\"#plan_id\",2)" },
        "A80": { "content": "=PIVOT.HEADER(9,\"#plan_id\",3)" },
        "A81": { "content": "=PIVOT.HEADER(9,\"#plan_id\",4)" },
        "A82": { "content": "=PIVOT.HEADER(9,\"#plan_id\",5)" },
        "A83": { "content": "=PIVOT.HEADER(9,\"#plan_id\",6)" },
        "A84": { "content": "=PIVOT.HEADER(9,\"#plan_id\",7)" },
        "A85": { "content": "=PIVOT.HEADER(9,\"#plan_id\",8)" },
        "A86": { "content": "=PIVOT.HEADER(9,\"#plan_id\",9)" },
        "A87": { "content": "=PIVOT.HEADER(9,\"#plan_id\",10)" },
        "C38": { "content": "=_t(\"Salesperson\")" },
        "C39": { "content": "=ODOO.LIST(2,1,\"user_id\")" },
        "C40": { "content": "=ODOO.LIST(2,2,\"user_id\")" },
        "C41": { "content": "=ODOO.LIST(2,3,\"user_id\")" },
        "C42": { "content": "=ODOO.LIST(2,4,\"user_id\")" },
        "C43": { "content": "=ODOO.LIST(2,5,\"user_id\")" },
        "C44": { "content": "=ODOO.LIST(2,6,\"user_id\")" },
        "C45": { "content": "=ODOO.LIST(2,7,\"user_id\")" },
        "C46": { "content": "=ODOO.LIST(2,8,\"user_id\")" },
        "C47": { "content": "=ODOO.LIST(2,9,\"user_id\")" },
        "C48": { "content": "=ODOO.LIST(2,10,\"user_id\")" },
        "C51": { "content": "=_t(\"# Subscriptions\")" },
        "C52": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",1)"
        },
        "C53": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",2)"
        },
        "C54": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",3)"
        },
        "C55": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",4)"
        },
        "C56": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",5)"
        },
        "C57": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",6)"
        },
        "C58": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",7)"
        },
        "C59": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",8)"
        },
        "C60": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",9)"
        },
        "C61": {
          "content": "=PIVOT.VALUE(5,\"order_reference\",\"#template_id\",10)"
        },
        "C64": { "content": "=_t(\"# Subscriptions\")" },
        "C65": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",1)"
        },
        "C66": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",2)"
        },
        "C67": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",3)"
        },
        "C68": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",4)"
        },
        "C69": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",5)"
        },
        "C70": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",6)"
        },
        "C71": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",7)"
        },
        "C72": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",8)"
        },
        "C73": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",9)"
        },
        "C74": {
          "content": "=PIVOT.VALUE(6,\"order_reference\",\"#team_id\",10)"
        },
        "C77": { "content": "=_t(\"# Subscriptions\")" },
        "C78": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",1)"
        },
        "C79": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",2)"
        },
        "C80": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",3)"
        },
        "C81": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",4)"
        },
        "C82": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",5)"
        },
        "C83": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",6)"
        },
        "C84": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",7)"
        },
        "C85": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",8)"
        },
        "C86": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",9)"
        },
        "C87": {
          "content": "=PIVOT.VALUE(9,\"order_reference\",\"#plan_id\",10)"
        },
        "D38": { "content": "=_t(\"MRR\")" },
        "D39": { "content": "=ODOO.LIST(2,1,\"recurring_monthly\")" },
        "D40": { "content": "=ODOO.LIST(2,2,\"recurring_monthly\")" },
        "D41": { "content": "=ODOO.LIST(2,3,\"recurring_monthly\")" },
        "D42": { "content": "=ODOO.LIST(2,4,\"recurring_monthly\")" },
        "D43": { "content": "=ODOO.LIST(2,5,\"recurring_monthly\")" },
        "D44": { "content": "=ODOO.LIST(2,6,\"recurring_monthly\")" },
        "D45": { "content": "=ODOO.LIST(2,7,\"recurring_monthly\")" },
        "D46": { "content": "=ODOO.LIST(2,8,\"recurring_monthly\")" },
        "D47": { "content": "=ODOO.LIST(2,9,\"recurring_monthly\")" },
        "D48": { "content": "=ODOO.LIST(2,10,\"recurring_monthly\")" },
        "D51": { "content": "=_t(\"MRR\")" },
        "D52": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",1)"
        },
        "D53": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",2)"
        },
        "D54": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",3)"
        },
        "D55": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",4)"
        },
        "D56": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",5)"
        },
        "D57": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",6)"
        },
        "D58": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",7)"
        },
        "D59": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",8)"
        },
        "D60": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",9)"
        },
        "D61": {
          "content": "=PIVOT.VALUE(5,\"recurring_monthly\",\"#template_id\",10)"
        },
        "D64": { "content": "=_t(\"MRR\")" },
        "D65": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",1)"
        },
        "D66": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",2)"
        },
        "D67": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",3)"
        },
        "D68": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",4)"
        },
        "D69": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",5)"
        },
        "D70": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",6)"
        },
        "D71": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",7)"
        },
        "D72": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",8)"
        },
        "D73": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",9)"
        },
        "D74": {
          "content": "=PIVOT.VALUE(6,\"recurring_monthly\",\"#team_id\",10)"
        },
        "D77": { "content": "=_t(\"Value\")" },
        "D78": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",1)"
        },
        "D79": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",2)"
        },
        "D80": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",3)"
        },
        "D81": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",4)"
        },
        "D82": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",5)"
        },
        "D83": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",6)"
        },
        "D84": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",7)"
        },
        "D85": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",8)"
        },
        "D86": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",9)"
        },
        "D87": {
          "content": "=PIVOT.VALUE(9,\"price_subtotal\",\"#plan_id\",10)"
        },
        "F7": {
          "content": "[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\"})"
        },
        "F22": {
          "content": "[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\"})"
        },
        "F37": {
          "content": "[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\"})"
        },
        "F38": { "content": "=_t(\"Customer\")" },
        "F39": { "content": "=ODOO.LIST(1,1,\"partner_id\")" },
        "F40": { "content": "=ODOO.LIST(1,2,\"partner_id\")" },
        "F41": { "content": "=ODOO.LIST(1,3,\"partner_id\")" },
        "F42": { "content": "=ODOO.LIST(1,4,\"partner_id\")" },
        "F43": { "content": "=ODOO.LIST(1,5,\"partner_id\")" },
        "F44": { "content": "=ODOO.LIST(1,6,\"partner_id\")" },
        "F45": { "content": "=ODOO.LIST(1,7,\"partner_id\")" },
        "F46": { "content": "=ODOO.LIST(1,8,\"partner_id\")" },
        "F47": { "content": "=ODOO.LIST(1,9,\"partner_id\")" },
        "F48": { "content": "=ODOO.LIST(1,10,\"partner_id\")" },
        "F50": {
          "content": "[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\"})"
        },
        "F51": { "content": "=_t(\"Product\")" },
        "F52": { "content": "=PIVOT.HEADER(4,\"#product_id\",1)" },
        "F53": { "content": "=PIVOT.HEADER(4,\"#product_id\",2)" },
        "F54": { "content": "=PIVOT.HEADER(4,\"#product_id\",3)" },
        "F55": { "content": "=PIVOT.HEADER(4,\"#product_id\",4)" },
        "F56": { "content": "=PIVOT.HEADER(4,\"#product_id\",5)" },
        "F57": { "content": "=PIVOT.HEADER(4,\"#product_id\",6)" },
        "F58": { "content": "=PIVOT.HEADER(4,\"#product_id\",7)" },
        "F59": { "content": "=PIVOT.HEADER(4,\"#product_id\",8)" },
        "F60": { "content": "=PIVOT.HEADER(4,\"#product_id\",9)" },
        "F61": { "content": "=PIVOT.HEADER(4,\"#product_id\",10)" },
        "F63": {
          "content": "[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\"})"
        },
        "F64": { "content": "=_t(\"Salesperson\")" },
        "F65": { "content": "=PIVOT.HEADER(7,\"#user_id\",1)" },
        "F66": { "content": "=PIVOT.HEADER(7,\"#user_id\",2)" },
        "F67": { "content": "=PIVOT.HEADER(7,\"#user_id\",3)" },
        "F68": { "content": "=PIVOT.HEADER(7,\"#user_id\",4)" },
        "F69": { "content": "=PIVOT.HEADER(7,\"#user_id\",5)" },
        "F70": { "content": "=PIVOT.HEADER(7,\"#user_id\",6)" },
        "F71": { "content": "=PIVOT.HEADER(7,\"#user_id\",7)" },
        "F72": { "content": "=PIVOT.HEADER(7,\"#user_id\",8)" },
        "F73": { "content": "=PIVOT.HEADER(7,\"#user_id\",9)" },
        "F74": { "content": "=PIVOT.HEADER(7,\"#user_id\",10)" },
        "F76": {
          "content": "[Top Countries](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\":[\"country_id\"]},\"modelName\":\"sale.subscription.report\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"list\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Subscriptions Analysis\"})"
        },
        "F77": { "content": "=_t(\"Countries\")" },
        "F78": { "content": "=PIVOT.HEADER(8,\"#country_id\",1)" },
        "F79": { "content": "=PIVOT.HEADER(8,\"#country_id\",2)" },
        "F80": { "content": "=PIVOT.HEADER(8,\"#country_id\",3)" },
        "F81": { "content": "=PIVOT.HEADER(8,\"#country_id\",4)" },
        "F82": { "content": "=PIVOT.HEADER(8,\"#country_id\",5)" },
        "F83": { "content": "=PIVOT.HEADER(8,\"#country_id\",6)" },
        "F84": { "content": "=PIVOT.HEADER(8,\"#country_id\",7)" },
        "F85": { "content": "=PIVOT.HEADER(8,\"#country_id\",8)" },
        "F86": { "content": "=PIVOT.HEADER(8,\"#country_id\",9)" },
        "F87": { "content": "=PIVOT.HEADER(8,\"#country_id\",10)" },
        "H38": { "content": "=_t(\"Salesperson\")" },
        "H39": { "content": "=ODOO.LIST(1,1,\"user_id\")" },
        "H40": { "content": "=ODOO.LIST(1,2,\"user_id\")" },
        "H41": { "content": "=ODOO.LIST(1,3,\"user_id\")" },
        "H42": { "content": "=ODOO.LIST(1,4,\"user_id\")" },
        "H43": { "content": "=ODOO.LIST(1,5,\"user_id\")" },
        "H44": { "content": "=ODOO.LIST(1,6,\"user_id\")" },
        "H45": { "content": "=ODOO.LIST(1,7,\"user_id\")" },
        "H46": { "content": "=ODOO.LIST(1,8,\"user_id\")" },
        "H47": { "content": "=ODOO.LIST(1,9,\"user_id\")" },
        "H48": { "content": "=ODOO.LIST(1,10,\"user_id\")" },
        "H51": { "content": "=_t(\"# Subscriptions\")" },
        "H52": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",1)"
        },
        "H53": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",2)"
        },
        "H54": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",3)"
        },
        "H55": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",4)"
        },
        "H56": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",5)"
        },
        "H57": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",6)"
        },
        "H58": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",7)"
        },
        "H59": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",8)"
        },
        "H60": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",9)"
        },
        "H61": {
          "content": "=PIVOT.VALUE(4,\"order_reference\",\"#product_id\",10)"
        },
        "H64": { "content": "=_t(\"# Subscriptions\")" },
        "H65": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",1)"
        },
        "H66": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",2)"
        },
        "H67": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",3)"
        },
        "H68": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",4)"
        },
        "H69": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",5)"
        },
        "H70": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",6)"
        },
        "H71": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",7)"
        },
        "H72": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",8)"
        },
        "H73": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",9)"
        },
        "H74": {
          "content": "=PIVOT.VALUE(7,\"order_reference\",\"#user_id\",10)"
        },
        "H77": { "content": "=_t(\"# Orders\")" },
        "H78": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",1)"
        },
        "H79": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",2)"
        },
        "H80": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",3)"
        },
        "H81": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",4)"
        },
        "H82": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",5)"
        },
        "H83": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",6)"
        },
        "H84": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",7)"
        },
        "H85": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",8)"
        },
        "H86": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",9)"
        },
        "H87": {
          "content": "=PIVOT.VALUE(8,\"order_reference\",\"#country_id\",10)"
        },
        "I38": { "content": "=_t(\"MRR\")" },
        "I39": { "content": "=ODOO.LIST(1,1,\"recurring_monthly\")" },
        "I40": { "content": "=ODOO.LIST(1,2,\"recurring_monthly\")" },
        "I41": { "content": "=ODOO.LIST(1,3,\"recurring_monthly\")" },
        "I42": { "content": "=ODOO.LIST(1,4,\"recurring_monthly\")" },
        "I43": { "content": "=ODOO.LIST(1,5,\"recurring_monthly\")" },
        "I44": { "content": "=ODOO.LIST(1,6,\"recurring_monthly\")" },
        "I45": { "content": "=ODOO.LIST(1,7,\"recurring_monthly\")" },
        "I46": { "content": "=ODOO.LIST(1,8,\"recurring_monthly\")" },
        "I47": { "content": "=ODOO.LIST(1,9,\"recurring_monthly\")" },
        "I48": { "content": "=ODOO.LIST(1,10,\"recurring_monthly\")" },
        "I51": { "content": "=_t(\"MRR\")" },
        "I52": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",1)"
        },
        "I53": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",2)"
        },
        "I54": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",3)"
        },
        "I55": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",4)"
        },
        "I56": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",5)"
        },
        "I57": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",6)"
        },
        "I58": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",7)"
        },
        "I59": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",8)"
        },
        "I60": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",9)"
        },
        "I61": {
          "content": "=PIVOT.VALUE(4,\"recurring_monthly\",\"#product_id\",10)"
        },
        "I64": { "content": "=_t(\"MRR\")" },
        "I65": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",1)"
        },
        "I66": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",2)"
        },
        "I67": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",3)"
        },
        "I68": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",4)"
        },
        "I69": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",5)"
        },
        "I70": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",6)"
        },
        "I71": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",7)"
        },
        "I72": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",8)"
        },
        "I73": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",9)"
        },
        "I74": {
          "content": "=PIVOT.VALUE(7,\"recurring_monthly\",\"#user_id\",10)"
        },
        "I77": { "content": "=_t(\"MRR\")" },
        "I78": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",1)"
        },
        "I79": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",2)"
        },
        "I80": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",3)"
        },
        "I81": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",4)"
        },
        "I82": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",5)"
        },
        "I83": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",6)"
        },
        "I84": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",7)"
        },
        "I85": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",8)"
        },
        "I86": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",9)"
        },
        "I87": {
          "content": "=PIVOT.VALUE(8,\"recurring_monthly\",\"#country_id\",10)"
        }
      },
      "styles": {
        "A7": 1,
        "A22": 1,
        "A37": 1,
        "A50": 1,
        "A63": 1,
        "A76": 1,
        "F7": 1,
        "F22": 1,
        "F37": 1,
        "F50": 1,
        "F63": 1,
        "F76": 1,
        "A51:B51": 2,
        "A64:B64": 2,
        "A77:B77": 2,
        "A38:C38": 2,
        "F38": 2,
        "F51:G51": 2,
        "F64:G64": 2,
        "F77:G77": 2,
        "H38": 2,
        "A39:D48": 3,
        "A52:D61": 3,
        "A65:D74": 3,
        "A78:D87": 3,
        "F39:I48": 3,
        "F52:I61": 3,
        "F65:I74": 3,
        "F78:I87": 3,
        "D38": 4,
        "C51:D51": 4,
        "C64:D64": 4,
        "C77:D77": 4,
        "I38": 4,
        "H51:I51": 4,
        "H64:I64": 4,
        "H77:I77": 4
      },
      "formats": {},
      "borders": {
        "A7:D7": 1,
        "A22:D22": 1,
        "A37:D37": 1,
        "A50:D50": 1,
        "A63:D63": 1,
        "F7:I7": 1,
        "F22:I22": 1,
        "F37:I37": 1,
        "F50:I50": 1,
        "F63:I63": 1,
        "A8:D8": 2,
        "A23:D23": 2,
        "A38:D38": 2,
        "A51:D51": 2,
        "A64:D64": 2,
        "F8:I8": 2,
        "F23:I23": 2,
        "F38:I38": 2,
        "F51:I51": 2,
        "F64:I64": 2,
        "A39": 3,
        "A52": 3,
        "A65": 3,
        "A78": 3,
        "F39": 3,
        "F52": 3,
        "F65": 3,
        "F78": 3,
        "A40:A48": 4,
        "A53:A61": 4,
        "A66:A74": 4,
        "A79:A87": 4,
        "F40:F48": 4,
        "F53:F61": 4,
        "F66:F74": 4,
        "F79:F87": 4,
        "A49:D49": 5,
        "A62:D62": 5,
        "A75:D75": 5,
        "A88:D88": 5,
        "F49:I49": 5,
        "F62:I62": 5,
        "F75:I75": 5,
        "F88:I88": 5,
        "B39": 6,
        "B52": 6,
        "B65": 6,
        "B78": 6,
        "G39": 6,
        "G52": 6,
        "G65": 6,
        "G78": 6,
        "B40:B48": 7,
        "B53:B61": 7,
        "B66:B74": 7,
        "B79:B87": 7,
        "G40:G48": 7,
        "G53:G61": 7,
        "G66:G74": 7,
        "G79:G87": 7,
        "C39": 8,
        "C52": 8,
        "C65": 8,
        "C78": 8,
        "H39": 8,
        "H52": 8,
        "H65": 8,
        "H78": 8,
        "C40:C48": 9,
        "C53:C61": 9,
        "C66:C74": 9,
        "C79:C87": 9,
        "H40:H48": 9,
        "H53:H61": 9,
        "H66:H74": 9,
        "H79:H87": 9,
        "D39": 10,
        "D52": 10,
        "D65": 10,
        "D78": 10,
        "I39": 10,
        "I52": 10,
        "I65": 10,
        "I78": 10,
        "D40:D48": 11,
        "D53:D61": 11,
        "D66:D74": 11,
        "D79:D87": 11,
        "I40:I48": 11,
        "I53:I61": 11,
        "I66:I74": 11,
        "I79:I87": 11
      },
      "conditionalFormats": [
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15531509,
            "rangeValues": "D52:D61"
          },
          "id": "a6a2a4dd-3f0f-40f2-a5f7-1556d0061717",
          "ranges": ["A52:A61"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16708338,
            "rangeValues": "I52:I61"
          },
          "id": "50dc872e-92aa-41b4-a35e-1a65f3a1daa0",
          "ranges": ["F52:F61"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16775149,
            "rangeValues": "D65:D74"
          },
          "id": "d34123f8-de5e-432d-9adb-57b0669ce225",
          "ranges": ["A65:A74"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15726335,
            "rangeValues": "I65:I74"
          },
          "id": "baa3d9df-cc13-4d21-958e-81b1aefba124",
          "ranges": ["F65:F74"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16708338,
            "rangeValues": "I78:I87"
          },
          "id": "de99a6f1-28a6-46bf-be58-0f1cc31853b0",
          "ranges": ["F78:F87"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15531509,
            "rangeValues": "D78:D87"
          },
          "id": "7da51d8e-ae22-44a4-bc36-03bdf51f31da",
          "ranges": ["A78:A87"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 16775149,
            "rangeValues": "D39:D48"
          },
          "id": "dfe0b361-bb44-47d7-aa06-5680833e46e6",
          "ranges": ["A39:A48"]
        },
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15726335,
            "rangeValues": "I39:I48"
          },
          "id": "544404fc-03ad-411d-adf7-aae3adf0aa0f",
          "ranges": ["F39:F48"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "51823220-f22b-4359-8711-579a249c91bb",
          "x": 7,
          "y": 9,
          "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": "ARR",
            "keyValue": "Data!D3",
            "humanize": false
          }
        },
        {
          "id": "67858d0e-b5ba-4a3c-bf9e-c0fceaeedf65",
          "x": 233,
          "y": 9,
          "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": "/sub.",
            "keyValue": "Data!B6",
            "humanize": false
          }
        },
        {
          "id": "2461b920-4fdd-4b3f-8bc5-8e33bd818987",
          "x": 537,
          "y": 178,
          "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",
            "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"
              }
            }
          }
        },
        {
          "id": "38f6014f-c8a5-41e7-8cba-c8682b567473",
          "x": 0,
          "y": 540,
          "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",
            "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"
              }
            }
          }
        },
        {
          "id": "a1de0db0-db97-4b9f-b581-f103544da310",
          "x": 537,
          "y": 540,
          "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",
            "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"
              }
            }
          }
        },
        {
          "id": "096cbdfa-ca41-4fb7-abec-12773c2f4e9b",
          "x": 458,
          "y": 9,
          "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": "Month(s)",
            "keyValue": "Data!D11",
            "humanize": false
          }
        },
        {
          "id": "c89ec529-8055-4dee-b7ba-8a1e8680f82b",
          "x": 682,
          "y": 9,
          "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
          }
        },
        {
          "id": "2673174b-3fc1-4807-9d5f-8fad50c73c17",
          "x": 0,
          "y": 178,
          "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",
            "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"
              }
            }
          }
        }
      ],
      "tables": [],
      "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": { "content": "=_t(\"KPI\")" },
        "A2": {
          "content": "=PIVOT.HEADER(1,\"measure\",\"mrr_change_normalized\")"
        },
        "A3": {
          "content": "=PIVOT.HEADER(2,\"measure\",\"recurring_monthly:sum\")"
        },
        "A4": {
          "content": "=PIVOT.HEADER(2,\"measure\",\"recurring_yearly\")"
        },
        "A5": { "content": "=_t(\"New MRR\")" },
        "A6": { "content": "=_t(\"Total Subscriptions\")" },
        "A7": { "content": "=_t(\"Avg MRR / Subscriptions\")" },
        "A8": { "content": "=_t(\"Churned\")" },
        "A9": { "content": "=_t(\"Churned %\")" },
        "A10": { "content": "=_t(\"Total churned\")" },
        "A11": { "content": "=_t(\"Lifespan\")" },
        "A12": { "content": "=_t(\"Lifetime Value\")" },
        "B1": { "content": "=_t(\"Current\")" },
        "B2": { "content": "=PIVOT.VALUE(1,\"mrr_change_normalized\")" },
        "B3": { "content": "=PIVOT.VALUE(2,\"recurring_monthly:sum\")" },
        "B4": { "content": "=PIVOT.VALUE(2,\"recurring_yearly\")" },
        "B5": {
          "content": "=IFERROR(PIVOT.VALUE(3,\"mrr_change_normalized\",\"event_type\",\"0_creation\",\"event_date:year\",YEAR(NOW())))"
        },
        "B6": { "content": "=PIVOT.VALUE(10,\"order_reference\")" },
        "B7": { "content": "=IFERROR(B3/B6)" },
        "B8": { "content": "=PIVOT.VALUE(11,\"order_reference\")" },
        "B9": { "content": "=B8/(B6+B8)" },
        "B10": { "content": "=PIVOT.VALUE(12,\"price_subtotal\")" },
        "B11": { "content": "=1/B9" },
        "B12": { "content": "=B7/B9" },
        "C1": { "content": "=_t(\"Previous\")" },
        "C5": {
          "content": "=PIVOT.VALUE(3,\"mrr_change_normalized\",\"event_type\",\"0_creation\",\"event_date:year\",YEAR(NOW())-1)"
        },
        "D1": { "content": "=_t(\"Current\")" },
        "D2": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B2))" },
        "D3": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B3))" },
        "D4": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B4))" },
        "D5": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B5))" },
        "D6": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B6))" },
        "D7": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B7))" },
        "D8": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B8))" },
        "D9": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B9))" },
        "D10": { "content": "=-IFERROR(FORMAT.LARGE.NUMBER(B10))" },
        "D11": { "content": "=IFERROR(FORMAT.LARGE.NUMBER(B11))" },
        "D12": { "content": "=FORMAT.LARGE.NUMBER(B12)" },
        "E1": { "content": "=_t(\"Previous\")" },
        "E5": { "content": "=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" } },
    "6": {
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "right": { "style": "thin", "color": "#FFFFFF" }
    },
    "7": {
      "top": { "style": "thin", "color": "#FFFFFF" },
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "right": { "style": "thin", "color": "#FFFFFF" }
    },
    "8": {
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "left": { "style": "thin", "color": "#FFFFFF" },
      "right": { "style": "thin", "color": "#FFFFFF" }
    },
    "9": {
      "top": { "style": "thin", "color": "#FFFFFF" },
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "left": { "style": "thin", "color": "#FFFFFF" },
      "right": { "style": "thin", "color": "#FFFFFF" }
    },
    "10": {
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "left": { "style": "thin", "color": "#FFFFFF" }
    },
    "11": {
      "top": { "style": "thin", "color": "#FFFFFF" },
      "bottom": { "style": "thin", "color": "#FFFFFF" },
      "left": { "style": "thin", "color": "#FFFFFF" }
    }
  },
  "revisionId": "6a1fba62-7f5c-4a82-a13b-25a19fb93974",
  "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": {
        "groupId": [[], []],
        "measure": "mrr_change_normalized",
        "order": "desc"
      },
      "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",
      "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": {
        "groupId": [[], []],
        "measure": "arr_change_normalized",
        "order": "asc"
      },
      "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" },
        { "id": "recurring_monthly", "fieldName": "recurring_monthly" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Product Variant",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "recurring_monthly",
        "order": "desc"
      },
      "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": "recurring_monthly", "fieldName": "recurring_monthly" },
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Subscription Template",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "recurring_monthly",
        "order": "desc"
      },
      "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": "recurring_monthly", "fieldName": "recurring_monthly" },
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Sales Team",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "recurring_monthly",
        "order": "desc"
      },
      "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": "recurring_monthly", "fieldName": "recurring_monthly" },
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Salesperson",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "recurring_monthly",
        "order": "desc"
      },
      "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": "recurring_monthly", "fieldName": "recurring_monthly" },
        { "id": "order_reference", "fieldName": "order_reference" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Country",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "recurring_monthly",
        "order": "desc"
      },
      "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" },
        { "id": "price_subtotal", "fieldName": "price_subtotal" }
      ],
      "model": "sale.subscription.report",
      "name": "Subscription Analysis by Recurrence",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "price_subtotal",
        "order": "desc"
      },
      "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"
        }
      },
      "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"
        }
      },
      "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"
        }
      },
      "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": {},
  "odooVersion": 12,
  "globalFilters": [
    {
      "id": "e6db018b-19ec-42c3-b29e-11b1e3910916",
      "type": "relation",
      "label": "Land",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "res.country"
    },
    {
      "id": "dbb716a1-5977-47ee-a53e-ca5716303433",
      "type": "relation",
      "label": "Product",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "product.template"
    },
    {
      "id": "7d95fe28-fd13-4805-948c-95742e7d6733",
      "type": "relation",
      "label": "Customer",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "res.partner"
    },
    {
      "id": "b75963ca-ab5f-4da5-9c90-67526517e5e7",
      "type": "relation",
      "label": "Sales Team",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "crm.team"
    },
    {
      "id": "4181e8e3-2e7e-42be-a88b-f24acb7d03e7",
      "type": "relation",
      "label": "Salesperson",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "res.users"
    },
    {
      "id": "ec466626-f54a-4955-9611-eaa2719f1afb",
      "type": "relation",
      "label": "Source",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "modelName": "utm.source"
    },
    {
      "id": "85d94827-6ce2-429c-9775-ef646cfddb6b",
      "type": "relation",
      "label": "Medium",
      "defaultValue": [],
      "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": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": {
          "chain": "partner_id",
          "type": "many2many"
        },
        "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": {},
        "7d95fe28-fd13-4805-948c-95742e7d6733": {
          "chain": "partner_id",
          "type": "many2many"
        },
        "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"
  }
}
