{
  "title": "Package Sales by Campaign",
  "oid": "64ffa40a5bda141f403a2831",
  "desc": "",
  "source": null,
  "type": "dashboard",
  "style": {
    "name": "vivid",
    "palette": {
      "colors": [
        "#547A94",
        "#F48E06",
        "#DB4935",
        "#333333",
        "#008775"
      ],
      "min": "#547A94",
      "max": "#F48E06",
      "name": "Tessitura",
      "sortOrder": 0
    }
  },
  "layout": {
    "instanceid": "E9BA7-0EC9-BB",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": "226px",
                    "defaultWidth": 512,
                    "widgetid": "6500c860960a6e10d41a2595",
                    "autoHeight": "226px"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1180,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "defaultWidth": 512,
                    "widgetid": "6500d5a1960a6e10d41a25ab",
                    "height": "456px",
                    "autoHeight": "456px"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1285,
                "index": 0
              }
            ]
          }
        ],
        "pxlWidth": 0,
        "index": 0
      }
    ],
    "container": {
      "sizzle1694530705128": {
        "undefined": {
          "parentNode": [
            12970.050259120075,
            109,
            true
          ]
        }
      }
    }
  },
  "original": null,
  "dataExploration": false,
  "datasource": {
    "title": "TNHS-Seats and Tickets",
    "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
    "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
    "address": "CWALLINGFORD-TN",
    "database": "aTNHSLQAaSeatsIAAaandIAAaTickets"
  },
  "filters": [
    {
      "jaql": {
        "table": "ORDER DETAILS",
        "column": "Mode of Sale",
        "dim": "[ORDER DETAILS.Mode of Sale]",
        "datatype": "text",
        "merged": true,
        "title": "Mode of Sale",
        "datasource": {
          "title": "TNHS-Seats and Tickets",
          "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
          "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
          "address": "CWALLINGFORD-TN",
          "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
          "lastBuildTime": "2023-09-11T17:52:18.828Z"
        },
        "collapsed": true,
        "filter": {
          "explicit": false,
          "multiSelection": true,
          "all": true
        }
      },
      "instanceid": "A6B84-7D4F-2F",
      "isCascading": false,
      "disabled": false
    },
    {
      "instanceid": "E0372-910D-DF",
      "isCascading": true,
      "disabled": false,
      "levels": [
        {
          "table": "PACKAGE DETAIL",
          "column": "Package Mode",
          "dim": "[PACKAGE.Package Mode1]",
          "datatype": "text",
          "merged": true,
          "title": "Package Mode",
          "collapsed": true,
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "panel": "scope",
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true,
            "filter": {
              "explicit": true,
              "multiSelection": true,
              "members": [
                "Fixed Seat Package"
              ]
            }
          }
        },
        {
          "table": "PACKAGE DETAIL",
          "column": "Package Season",
          "dim": "[PACKAGE DETAIL.Package Season]",
          "datatype": "text",
          "merged": true,
          "title": "Package Season",
          "collapsed": true,
          "panel": "scope",
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "filter": {
            "explicit": true,
            "multiSelection": true,
            "members": [
              "2023 Ballet"
            ]
          }
        },
        {
          "table": "PACKAGE DETAIL",
          "column": "Type",
          "dim": "[PACKAGE.Type1]",
          "datatype": "text",
          "merged": true,
          "title": "Type",
          "collapsed": true,
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "panel": "scope",
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true
          }
        },
        {
          "table": "PACKAGE DETAIL",
          "column": "Package",
          "dim": "[PACKAGE.Package1]",
          "datatype": "text",
          "merged": true,
          "title": "Package",
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "collapsed": true,
          "panel": "scope",
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true
          }
        },
        {
          "table": "ZONE",
          "column": "Zone Map",
          "dim": "[ZONE.Zone Map]",
          "datatype": "text",
          "merged": true,
          "title": "Zone Map",
          "collapsed": true,
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true
          },
          "panel": "scope"
        },
        {
          "table": "ZONE",
          "column": "Zone",
          "dim": "[ZONE.Zone]",
          "datatype": "text",
          "merged": true,
          "title": "Zone",
          "collapsed": true,
          "datasource": {
            "title": "TNHS-Seats and Tickets",
            "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
            "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "CWALLINGFORD-TN",
            "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
            "lastBuildTime": "2023-09-12T14:37:38.871Z"
          },
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true
          }
        }
      ],
      "model": {
        "instanceid": "5AC7B-AB12-46",
        "__store": [
          "[PACKAGE.Package Mode1]",
          "[PACKAGE DETAIL.Package Season]",
          "[PACKAGE.Type1]",
          "[PACKAGE.Package1]",
          "[PACKAGE.Package Zone Map1]",
          "[ZONE.Zone Map]",
          "[ZONE.Zone Map]",
          "[ZONE.Zone]"
        ]
      }
    },
    {
      "jaql": {
        "table": "ORDER DETAILS",
        "column": "Order Paid Status",
        "dim": "[ORDER DETAILS.Order Paid Status]",
        "datatype": "text",
        "merged": true,
        "title": "Order Paid Status",
        "collapsed": true,
        "datasource": {
          "title": "TNHS-Seats and Tickets",
          "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
          "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
          "address": "CWALLINGFORD-TN",
          "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
          "lastBuildTime": "2023-09-12T14:37:38.871Z"
        },
        "filter": {
          "explicit": false,
          "multiSelection": true,
          "all": true
        }
      },
      "instanceid": "5AD1E-63B6-3A",
      "isCascading": false,
      "disabled": false
    }
  ],
  "editing": true,
  "settings": {
    "autoUpdateOnFiltersChange": true
  },
  "filterToDatasourceMapping": {},
  "widgets": [
    {
      "title": "Summary",
      "subtype": "pivot",
      "oid": "6500c860960a6e10d41a2595",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "TNHS-Seats and Tickets",
        "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
        "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "CWALLINGFORD-TN",
        "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
        "lastBuildTime": "2023-09-12T10:37:38"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "PACKAGE CAMPAIGN",
                  "column": "Campaign",
                  "dim": "[PACKAGE.Campaign]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Campaign"
                },
                "field": {
                  "id": "[PACKAGE.Campaign]",
                  "index": 0
                },
                "format": {
                  "subtotal": true
                }
              },
              {
                "jaql": {
                  "table": "PACKAGE DETAIL",
                  "column": "Package Code",
                  "dim": "[PACKAGE.Package Code1]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Package Code"
                },
                "field": {
                  "id": "[PACKAGE.Package Code1]",
                  "index": 1
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Count",
                  "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Count"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Count]_sum",
                  "index": 3
                }
              },
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Original Value",
                  "dim": "[SEAT & TICKET VALUES.Ticket Original Value]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "number": {
                      "separated": true
                    }
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Original Value]_sum",
                  "index": 4
                }
              },
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Original Paid Amount",
                  "dim": "[SEAT & TICKET VALUES.Ticket Original Paid Amount]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Paid"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "number": {
                      "separated": true
                    }
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Original Paid Amount]_sum",
                  "index": 5
                }
              }
            ]
          },
          {
            "name": "columns",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Seated Status",
                  "dim": "[SEAT & TICKET.Seated Status]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Seated Status"
                },
                "field": {
                  "id": "[SEAT & TICKET.Seated Status]",
                  "index": 2
                }
              }
            ]
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "type": "pivot",
      "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
      "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
      "style": {
        "pageSize": 25,
        "automaticHeight": true,
        "colors": {
          "rows": true,
          "columns": false,
          "headers": true,
          "members": false,
          "totals": true
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "campaign",
              "title": "Campaign",
              "singular": "Campaign",
              "plural": "Campaign"
            },
            {
              "id": "package_code",
              "title": "Package Code",
              "singular": "Package Code",
              "plural": "Package Code"
            },
            {
              "id": "seated_status",
              "title": "Seated Status",
              "singular": "Seated Status",
              "plural": "Seated Status"
            }
          ]
        },
        "rowsGrandTotal": true,
        "columnsGrandTotal": true
      },
      "instanceid": "E9A8F-0AA4-FD",
      "queryStartTime": "2023-09-12T17:20:58",
      "drawing": true,
      "widgetTimingLoged": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": false,
        "volatile": false,
        "hideDrilledDashboards": false,
        "hideSharedDashboardsForNonOwner": true,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 2,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true,
        "sendPieChartMeasureFiltersOnClick": true,
        "forceZeroInsteadNull": false,
        "mergeTargetDashboardFilters": false,
        "drillToDashboardByName": true
      },
      "realTimeRefreshing": false,
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true
      },
      "dashboardid": "64ffa40a5bda141f403a2831",
      "viewState": {
        "activeTab": "design"
      }
    },
    {
      "title": "",
      "subtype": "pivot",
      "oid": "6500d5a1960a6e10d41a25ab",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "TNHS-Seats and Tickets",
        "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets",
        "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "CWALLINGFORD-TN",
        "database": "aTNHSLQAaSeatsIAAaandIAAaTickets",
        "lastBuildTime": "2023-09-12T10:37:38"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "PACKAGE CAMPAIGN",
                  "column": "Campaign",
                  "dim": "[PACKAGE.Campaign]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Campaign"
                },
                "field": {
                  "id": "[PACKAGE.Campaign]",
                  "index": 0
                },
                "format": {
                  "subtotal": true
                }
              },
              {
                "jaql": {
                  "table": "PACKAGE DETAIL",
                  "column": "Package Code",
                  "dim": "[PACKAGE.Package Code1]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Package Code"
                },
                "field": {
                  "id": "[PACKAGE.Package Code1]",
                  "index": 1
                },
                "format": {
                  "subtotal": true
                }
              },
              {
                "jaql": {
                  "table": "ZONE",
                  "column": "Zone Rank",
                  "dim": "[ZONE.Zone Rank]",
                  "datatype": "numeric",
                  "title": "."
                },
                "field": {
                  "id": "[ZONE.Zone Rank]",
                  "index": 2
                },
                "format": {
                  "width": 36
                }
              },
              {
                "jaql": {
                  "table": "ZONE",
                  "column": "Zone",
                  "dim": "[ZONE.Zone]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Zone"
                },
                "field": {
                  "id": "[ZONE.Zone]",
                  "index": 3
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Count",
                  "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Count"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Count]_sum",
                  "index": 5
                }
              },
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Original Value",
                  "dim": "[SEAT & TICKET VALUES.Ticket Original Value]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "number": {
                      "separated": true
                    }
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Original Value]_sum",
                  "index": 6
                }
              },
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Original Paid Amount",
                  "dim": "[SEAT & TICKET VALUES.Ticket Original Paid Amount]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Paid"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "number": {
                      "separated": true
                    }
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Original Paid Amount]_sum",
                  "index": 7
                }
              }
            ]
          },
          {
            "name": "columns",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Seated Status",
                  "dim": "[SEAT & TICKET.Seated Status]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Seated Status"
                },
                "field": {
                  "id": "[SEAT & TICKET.Seated Status]",
                  "index": 4
                }
              }
            ]
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "type": "pivot",
      "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
      "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
      "style": {
        "pageSize": 25,
        "automaticHeight": true,
        "colors": {
          "rows": true,
          "columns": false,
          "headers": true,
          "members": false,
          "totals": true
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "campaign",
              "title": "Campaign",
              "singular": "Campaign",
              "plural": "Campaign"
            },
            {
              "id": "package_code",
              "title": "Package Code",
              "singular": "Package Code",
              "plural": "Package Code"
            },
            {
              "id": ".",
              "title": ".",
              "singular": ".",
              "plural": "."
            },
            {
              "id": "zone",
              "title": "Zone",
              "singular": "Zone",
              "plural": "Zone"
            },
            {
              "id": "seated_status",
              "title": "Seated Status",
              "singular": "Seated Status",
              "plural": "Seated Status"
            }
          ]
        },
        "rowsGrandTotal": true,
        "columnsGrandTotal": true
      },
      "instanceid": "E9A8F-0AA4-FD",
      "queryStartTime": "2023-09-12T17:23:32",
      "widgetTimingLoged": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": false,
        "volatile": false,
        "hideDrilledDashboards": false,
        "hideSharedDashboardsForNonOwner": true,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 2,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true,
        "sendPieChartMeasureFiltersOnClick": true,
        "forceZeroInsteadNull": false,
        "mergeTargetDashboardFilters": false,
        "drillToDashboardByName": true
      },
      "realTimeRefreshing": false,
      "viewState": {
        "activeTab": "design"
      },
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true
      },
      "dashboardid": "64ffa40a5bda141f403a2831",
      "drawing": true
    }
  ],
  "hierarchies": []
}