{
  "version": 21,
  "sheets": [
    {
      "id": "sheet1",
      "name": "Dashboard",
      "colNumber": 5,
      "rowNumber": 35,
      "rows": {
        "6": { "size": 40 },
        "22": { "size": 40 },
        "23": { "size": 40 },
        "24": { "size": 29 },
        "25": { "size": 29 },
        "26": { "size": 29 },
        "27": { "size": 29 },
        "28": { "size": 29 },
        "29": { "size": 29 },
        "30": { "size": 29 },
        "31": { "size": 29 },
        "32": { "size": 29 },
        "33": { "size": 29 }
      },
      "cols": {
        "0": { "size": 372 },
        "1": { "size": 100 },
        "2": { "size": 50 },
        "3": { "size": 209 },
        "4": { "size": 260 }
      },
      "merges": [],
      "cells": {
        "A7": {
          "content": "[Daily Sessions](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"start_date:day\"],\"graph_measure\":\"__count\",\"graph_mode\":\"bar\",\"graph_groupbys\":[\"start_date:day\"]},\"modelName\":\"im_livechat.report.channel\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Session per Day\"})"
        },
        "A23": {
          "content": "[Top Operators](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[],\"pivot_measures\":[\"nbr_channel\",\"time_to_answer\",\"duration\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"partner_id\"]},\"modelName\":\"im_livechat.report.operator\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Operator Analysis\"})"
        },
        "A24": { "content": "=_t(\"Operator\")" },
        "A25": { "content": "=PIVOT.HEADER(3,\"#partner_id\",1)" },
        "A26": { "content": "=PIVOT.HEADER(3,\"#partner_id\",2)" },
        "A27": { "content": "=PIVOT.HEADER(3,\"#partner_id\",3)" },
        "A28": { "content": "=PIVOT.HEADER(3,\"#partner_id\",4)" },
        "A29": { "content": "=PIVOT.HEADER(3,\"#partner_id\",5)" },
        "A30": { "content": "=PIVOT.HEADER(3,\"#partner_id\",6)" },
        "A31": { "content": "=PIVOT.HEADER(3,\"#partner_id\",7)" },
        "A32": { "content": "=PIVOT.HEADER(3,\"#partner_id\",8)" },
        "A33": { "content": "=PIVOT.HEADER(3,\"#partner_id\",9)" },
        "A34": { "content": "=PIVOT.HEADER(3,\"#partner_id\",10)" },
        "B24": { "content": "=_t(\"Sessions\")" },
        "B25": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",1)"
        },
        "B26": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",2)"
        },
        "B27": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",3)"
        },
        "B28": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",4)"
        },
        "B29": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",5)"
        },
        "B30": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",6)"
        },
        "B31": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",7)"
        },
        "B32": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",8)"
        },
        "B33": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",9)"
        },
        "B34": {
          "content": "=PIVOT.VALUE(3,\"nbr_channel\",\"#partner_id\",10)"
        },
        "D7": {
          "content": "[Sessions by Operator](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"partner_id\"],\"graph_measure\":\"nbr_channel\",\"graph_mode\":\"bar\",\"graph_groupbys\":[\"partner_id\"]},\"modelName\":\"im_livechat.report.operator\",\"views\":[[false,\"graph\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Operator Analysis\"})"
        },
        "D24": { "content": "=_t(\"Time to answer (seconds)\")" },
        "D25": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",1)"
        },
        "D26": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",2)"
        },
        "D27": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",3)"
        },
        "D28": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",4)"
        },
        "D29": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",5)"
        },
        "D30": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",6)"
        },
        "D31": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",7)"
        },
        "D32": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",8)"
        },
        "D33": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",9)"
        },
        "D34": {
          "content": "=PIVOT.VALUE(3,\"time_to_answer\",\"#partner_id\",10)"
        },
        "E24": { "content": "=_t(\"Average session (seconds)\")" },
        "E25": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",1)" },
        "E26": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",2)" },
        "E27": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",3)" },
        "E28": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",4)" },
        "E29": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",5)" },
        "E30": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",6)" },
        "E31": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",7)" },
        "E32": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",8)" },
        "E33": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",9)" },
        "E34": { "content": "=PIVOT.VALUE(3,\"duration\",\"#partner_id\",10)" }
      },
      "styles": {
        "A7": 1,
        "A23": 1,
        "D7": 1,
        "A24": 2,
        "A25:B34": 3,
        "D25:E34": 3,
        "B24": 4,
        "D24:E24": 4
      },
      "formats": {},
      "borders": {
        "A7:B7": 1,
        "D7:E7": 1,
        "A23:E23": 1,
        "A8:B8": 2,
        "D8:E8": 2,
        "A24:E24": 2,
        "A25": 3,
        "A26:A34": 4,
        "A35:E35": 5,
        "B25:D25": 6,
        "B26:D34": 7,
        "E25": 8,
        "E26:E34": 9
      },
      "conditionalFormats": [
        {
          "rule": {
            "type": "DataBarRule",
            "color": 15531509,
            "rangeValues": "B25:B34"
          },
          "id": "e2eeb59b-247b-4b2e-9327-4b53b2933b02",
          "ranges": ["A25:A34"]
        }
      ],
      "figures": [
        {
          "id": "082454d7-d797-48a6-8db5-9182050a8c55",
          "x": 0,
          "y": 12,
          "width": 200,
          "height": 102,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": { "text": "Sessions", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "Data!E2",
            "baselineDescr": "since last period",
            "keyValue": "Data!D2",
            "humanize": false
          }
        },
        {
          "id": "57b7bb2f-2b24-435a-83de-d56a0452ac10",
          "x": 0,
          "y": 178,
          "width": 474,
          "height": 343,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["start_date:day"],
              "measure": "__count",
              "order": null,
              "resModel": "im_livechat.report.channel",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [],
              "groupBy": ["start_date:day"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "verticalAxisPosition": "left",
            "stacked": false,
            "fieldMatching": {
              "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
                "chain": "start_date",
                "type": "datetime",
                "offset": 0
              },
              "5124b7b1-aa17-46cc-b574-2309708de75b": {
                "chain": "partner_id",
                "type": "many2one"
              }
            }
          }
        },
        {
          "id": "876d7cf5-21ea-441e-b4fd-08556365cb8a",
          "x": 520,
          "y": 178,
          "width": 472,
          "height": 345,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["partner_id"],
              "measure": "nbr_channel",
              "order": "DESC",
              "resModel": "im_livechat.report.operator",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [],
              "groupBy": ["partner_id"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "verticalAxisPosition": "left",
            "stacked": true,
            "fieldMatching": {
              "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
                "chain": "start_date",
                "type": "datetime",
                "offset": 0
              },
              "5124b7b1-aa17-46cc-b574-2309708de75b": {
                "chain": "partner_id",
                "type": "many2one"
              }
            }
          }
        },
        {
          "id": "ced6ca85-c9d2-4804-9100-e1ca5fd290d1",
          "x": 213,
          "y": 12,
          "width": 200,
          "height": 102,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Avg. Time to Answer",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "Data!E3",
            "baselineDescr": "last period",
            "keyValue": "Data!D3",
            "humanize": false
          }
        },
        {
          "id": "e0b92164-4451-4c0b-bd28-3bab46fd88de",
          "x": 426,
          "y": 12,
          "width": 200,
          "height": 102,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Avg. Session Duration",
              "color": "#434343",
              "bold": true
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "Data!E4",
            "baselineDescr": "last period",
            "keyValue": "Data!D4",
            "humanize": false
          }
        },
        {
          "id": "5b8972f1-db5f-48dd-aeca-c0bc87c7155d",
          "x": 636,
          "y": 12,
          "width": 200,
          "height": 102,
          "tag": "chart",
          "data": {
            "background": "#EFF6FF",
            "sectionRule": {
              "colors": {
                "lowerColor": "#cc0000",
                "middleColor": "#f1c232",
                "upperColor": "#6aa84f"
              },
              "rangeMin": "0",
              "rangeMax": "5",
              "lowerInflectionPoint": { "type": "number", "value": "1" },
              "upperInflectionPoint": { "type": "number", "value": "3" }
            },
            "title": {
              "text": "Average Rating",
              "bold": true,
              "color": "#434343"
            },
            "type": "gauge",
            "dataRange": "Data!D5"
          }
        }
      ],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    },
    {
      "id": "16705d67-20c0-466d-ac72-3b955432e0ba",
      "name": "Data",
      "colNumber": 26,
      "rowNumber": 95,
      "rows": {},
      "cols": {
        "0": { "size": 136 },
        "1": { "size": 110 },
        "2": { "size": 110 },
        "3": { "size": 110 },
        "4": { "size": 110 }
      },
      "merges": [],
      "cells": {
        "A1": { "content": "=_t(\"KPI\")" },
        "A2": { "content": "=_t(\"Sessions\")" },
        "A3": { "content": "=_t(\"Avg. time to answer\")" },
        "A4": { "content": "=_t(\"Avg. session duration\")" },
        "A5": { "content": "=_t(\"Rating\")" },
        "B1": { "content": "=_t(\"Current\")" },
        "B2": { "content": "=PIVOT.VALUE(4,\"__count\")" },
        "B3": { "content": "=PIVOT.VALUE(1,\"time_to_answer\")" },
        "B4": { "content": "=PIVOT.VALUE(1,\"duration\")" },
        "B5": { "content": "=PIVOT.VALUE(1,\"rating\")" },
        "C1": { "content": "=_t(\"Previous\")" },
        "C2": { "content": "=PIVOT.VALUE(5,\"__count\")" },
        "C3": { "content": "=PIVOT.VALUE(2,\"time_to_answer\")" },
        "C4": { "content": "=PIVOT.VALUE(2,\"duration\")" },
        "D1": { "content": "=_t(\"Current\")" },
        "D2": { "content": "=FORMAT.LARGE.NUMBER(B2)" },
        "D3": { "content": "=CONCATENATE(-ROUND(B3/60),\"min\")" },
        "D4": { "content": "=CONCATENATE(ROUND(B4/60),\"min\")" },
        "D5": { "content": "=B5" },
        "E1": { "content": "=_t(\"Previous\")" },
        "E2": { "content": "=FORMAT.LARGE.NUMBER(C2)" },
        "E3": { "content": "=-ROUND(C3/60)" },
        "E4": { "content": "=ROUND(C4/60)" }
      },
      "styles": { "A1:E1": 5, "D2:D5": 6, "E2:E4": 6 },
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": { "ROW": [], "COL": [] },
      "dataValidationRules": [],
      "comments": {}
    }
  ],
  "styles": {
    "1": { "textColor": "#01666b", "bold": true, "fontSize": 16 },
    "2": { "textColor": "#434343", "fontSize": 11, "bold": true },
    "3": { "textColor": "#434343", "verticalAlign": "middle" },
    "4": {
      "textColor": "#434343",
      "fontSize": 11,
      "bold": true,
      "align": "center"
    },
    "5": { "bold": true },
    "6": { "fillColor": "#f2f2f2" }
  },
  "formats": {},
  "borders": {
    "1": { "bottom": { "style": "thin", "color": "#CCCCCC" } },
    "2": { "top": { "style": "thin", "color": "#CCCCCC" } },
    "3": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": { "top": { "style": "thick", "color": "#FFFFFF" } },
    "6": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "7": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" },
      "right": { "style": "thick", "color": "#FFFFFF" }
    },
    "8": {
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    },
    "9": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" },
      "left": { "style": "thick", "color": "#FFFFFF" }
    }
  },
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "mm/dd/yyyy",
      "timeFormat": "hh:mm:ss",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {
    "1": {
      "type": "ODOO",
      "fieldMatching": {
        "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
          "chain": "start_date",
          "type": "datetime",
          "offset": 0
        },
        "5124b7b1-aa17-46cc-b574-2309708de75b": {
          "chain": "partner_id",
          "type": "many2one"
        }
      },
      "context": {},
      "domain": [],
      "id": "1",
      "measures": [
        { "id": "duration", "fieldName": "duration" },
        { "id": "time_to_answer", "fieldName": "time_to_answer" },
        { "id": "rating", "fieldName": "rating" }
      ],
      "model": "im_livechat.report.channel",
      "name": "stats 2 - current",
      "sortedColumn": null,
      "formulaId": "1",
      "columns": [],
      "rows": []
    },
    "2": {
      "type": "ODOO",
      "fieldMatching": {
        "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
          "chain": "start_date",
          "type": "datetime",
          "offset": -1
        },
        "5124b7b1-aa17-46cc-b574-2309708de75b": {
          "chain": "partner_id",
          "type": "many2one"
        }
      },
      "context": {},
      "domain": [],
      "id": "2",
      "measures": [
        { "id": "duration", "fieldName": "duration" },
        { "id": "time_to_answer", "fieldName": "time_to_answer" },
        { "id": "rating", "fieldName": "rating" }
      ],
      "model": "im_livechat.report.channel",
      "name": "stats 2 - previous",
      "sortedColumn": null,
      "formulaId": "2",
      "columns": [],
      "rows": []
    },
    "3": {
      "type": "ODOO",
      "fieldMatching": {
        "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
          "chain": "start_date",
          "type": "datetime",
          "offset": 0
        },
        "5124b7b1-aa17-46cc-b574-2309708de75b": {
          "chain": "partner_id",
          "type": "many2one"
        }
      },
      "context": {},
      "domain": [],
      "id": "3",
      "measures": [
        { "id": "nbr_channel", "fieldName": "nbr_channel" },
        { "id": "time_to_answer", "fieldName": "time_to_answer" },
        { "id": "duration", "fieldName": "duration" }
      ],
      "model": "im_livechat.report.operator",
      "name": "Livechat Support Statistics by Operator",
      "sortedColumn": {
        "groupId": [[], []],
        "measure": "nbr_channel",
        "order": "desc"
      },
      "formulaId": "3",
      "columns": [],
      "rows": [{ "fieldName": "partner_id" }]
    },
    "4": {
      "type": "ODOO",
      "fieldMatching": {
        "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
          "chain": "start_date",
          "type": "datetime",
          "offset": 0
        },
        "5124b7b1-aa17-46cc-b574-2309708de75b": {
          "chain": "partner_id",
          "type": "many2one"
        }
      },
      "context": {},
      "domain": [],
      "id": "4",
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "im_livechat.report.channel",
      "name": "sessions count - current",
      "sortedColumn": null,
      "formulaId": "4",
      "columns": [],
      "rows": []
    },
    "5": {
      "type": "ODOO",
      "fieldMatching": {
        "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac": {
          "chain": "start_date",
          "type": "datetime",
          "offset": -1
        },
        "5124b7b1-aa17-46cc-b574-2309708de75b": {
          "chain": "partner_id",
          "type": "many2one"
        }
      },
      "context": {},
      "domain": [],
      "id": "5",
      "measures": [{ "id": "__count", "fieldName": "__count" }],
      "model": "im_livechat.report.channel",
      "name": "sessions count - previous",
      "sortedColumn": null,
      "formulaId": "5",
      "columns": [],
      "rows": []
    }
  },
  "pivotNextId": 6,
  "customTableStyles": {},
  "odooVersion": 12,
  "globalFilters": [
    {
      "id": "4db3e2d2-5471-44a4-80ca-7c2fa4f1a5ac",
      "type": "date",
      "label": "Period",
      "defaultValue": "last_month",
      "rangeType": "relative"
    },
    {
      "id": "5124b7b1-aa17-46cc-b574-2309708de75b",
      "type": "relation",
      "label": "Operator",
      "modelName": "res.partner",
      "defaultValue": [],
      "defaultValueDisplayNames": [],
      "rangeType": "year"
    }
  ],
  "lists": {},
  "listNextId": 1,
  "chartOdooMenusReferences": {
    "57b7bb2f-2b24-435a-83de-d56a0452ac10": "im_livechat.menu_livechat_root",
    "876d7cf5-21ea-441e-b4fd-08556365cb8a": "im_livechat.menu_livechat_root",
    "082454d7-d797-48a6-8db5-9182050a8c55": "im_livechat.menu_reporting_livechat_channel",
    "ced6ca85-c9d2-4804-9100-e1ca5fd290d1": "im_livechat.menu_reporting_livechat_channel",
    "e0b92164-4451-4c0b-bd28-3bab46fd88de": "im_livechat.menu_reporting_livechat_channel",
    "5b8972f1-db5f-48dd-aeca-c0bc87c7155d": "im_livechat.rating_rating_menu_livechat"
  }
}
