{
  "title": "Daily Projection Tracking",
  "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": "A1E52-5A04-85",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 64,
                    "maxHeight": 2048,
                    "minWidth": 64,
                    "maxWidth": 2048,
                    "height": "336px",
                    "defaultWidth": 128,
                    "widgetid": "63188122eb1be916f824f80a"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 96,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": 384,
                    "defaultWidth": 512,
                    "widgetid": "63187cceeb1be916f824f790"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 96,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "defaultWidth": 512,
                    "widgetid": "63188332eb1be916f824f8b6",
                    "height": "697px",
                    "autoHeight": "697px"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 96,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "defaultWidth": 512,
                    "widgetid": "63187f09eb1be916f824f7c4",
                    "height": 384
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 96,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "defaultWidth": 512,
                    "widgetid": "6318854aeb1be916f824f92e",
                    "height": "697px",
                    "autoHeight": "697px"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          },
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": "159px",
                    "defaultWidth": 512,
                    "widgetid": "631b3f6cc4e0dc0934003eae",
                    "autoHeight": "159px"
                  }
                ],
                "width": 100,
                "stretchable": false,
                "pxlWidth": 1110,
                "index": 0
              }
            ]
          }
        ],
        "pxlWidth": 1110,
        "index": 0
      }
    ],
    "container": {}
  },
  "original": null,
  "oid": "63187b9beb1be916f824f74f",
  "datasource": {
    "title": "CDNB-Seats and Tickets",
    "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
    "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
    "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
    "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
  },
  "editing": true,
  "filters": [
    {
      "instanceid": "F0C66-5947-FC",
      "isCascading": true,
      "levels": [
        {
          "table": "PERFORMANCE DETAIL",
          "column": "Production",
          "dim": "[PERFORMANCE DETAIL.Production]",
          "datatype": "text",
          "merged": true,
          "title": "Production",
          "collapsed": true,
          "panel": "scope",
          "datasource": {
            "title": "CDNB-Seats and Tickets",
            "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
            "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
            "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
          },
          "filter": {
            "explicit": false,
            "multiSelection": true,
            "all": true
          }
        },
        {
          "table": "PERFORMANCE DETAIL",
          "column": "Production Season",
          "dim": "[PERFORMANCE DETAIL.Production Season]",
          "datatype": "text",
          "merged": true,
          "title": "Production Season",
          "collapsed": true,
          "panel": "scope",
          "datasource": {
            "title": "CDNB-Seats and Tickets",
            "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
            "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
            "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
            "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
          },
          "filter": {
            "explicit": true,
            "multiSelection": true,
            "members": [
              "Chicago 2019",
              "Chicago 2018",
              "Chicago 2017"
            ]
          }
        }
      ],
      "model": {
        "instanceid": "B0CE9-9262-D5",
        "__store": [
          "[PERFORMANCE DETAIL.Production]",
          "[PERFORMANCE DETAIL.Production Season]",
          "[PERFORMANCE DETAIL.Performance Date and Code]",
          "[PERFORMANCE DETAIL.Performance Date and Code]"
        ]
      },
      "disabled": false
    },
    {
      "jaql": {
        "datatype": "numeric",
        "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
        "title": "Order Days Prior to Opening",
        "column": "Order Days Prior to Opening",
        "table": "SEAT & TICKET DETAILS",
        "datasource": {
          "title": "CDNB-Seats and Tickets",
          "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
          "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
          "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
          "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
        },
        "collapsed": true,
        "filter": {
          "explicit": false,
          "multiSelection": true,
          "all": true
        }
      },
      "instanceid": "DB5DF-A50F-FB",
      "isCascading": false,
      "disabled": false
    }
  ],
  "filterToDatasourceMapping": {},
  "parentFolder": "6489f1c3d216511528adfd40",
  "settings": {
    "autoUpdateOnFiltersChange": false
  },
  "subscription": {
    "isDataChange": true,
    "type": "onUpdate",
    "schedule": "* * * * * *",
    "timezone": 480,
    "tzName": "America/Los_Angeles",
    "context": {
      "dashboardid": "63187b9beb1be916f824f74f"
    },
    "active": false,
    "executionPerDay": 1,
    "reportType": {
      "inline": true
    },
    "emailSettings": {
      "isEmail": true,
      "isPdf": false
    },
    "subscribe": false
  },
  "isPublic": null,
  "previewLayout": [
    {
      "type": "previewLayout",
      "format": "A4",
      "orientation": "portrait",
      "layout": "asis",
      "headerSize": "compact",
      "title": true,
      "elasticubeBuilt": true,
      "elasticubeName": true,
      "filters": true,
      "logo": false,
      "pageNumbers": true,
      "pages": [
        {
          "columns": [
            {
              "width": 100,
              "cells": [
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 64,
                          "maxHeight": 1024,
                          "height": 262,
                          "widgetid": "63188122eb1be916f824f80a"
                        }
                      ],
                      "width": 100
                    }
                  ]
                },
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 96,
                          "maxHeight": 1024,
                          "height": 282,
                          "widgetid": "63187cceeb1be916f824f790"
                        }
                      ],
                      "width": 100
                    }
                  ]
                },
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 96,
                          "maxHeight": 1024,
                          "height": 408,
                          "widgetid": "63188332eb1be916f824f8b6"
                        }
                      ],
                      "width": 100
                    }
                  ]
                }
              ]
            }
          ]
        },
        {
          "columns": [
            {
              "width": 100,
              "cells": [
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 96,
                          "maxHeight": 1024,
                          "height": 426,
                          "widgetid": "63187f09eb1be916f824f7c4"
                        }
                      ],
                      "width": 100
                    }
                  ]
                },
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 96,
                          "maxHeight": 1024,
                          "height": 362,
                          "widgetid": "6318854aeb1be916f824f92e"
                        }
                      ],
                      "width": 100
                    }
                  ]
                },
                {
                  "subcells": [
                    {
                      "elements": [
                        {
                          "minHeight": 128,
                          "maxHeight": 1024,
                          "height": 157,
                          "widgetid": "631b3f6cc4e0dc0934003eae"
                        }
                      ],
                      "width": 100
                    }
                  ]
                }
              ]
            }
          ]
        }
      ],
      "savedByButton": "Export",
      "openPath": "PDF Settings"
    }
  ],
  "migrated": true,
  "lastPublish": "2023-06-14T17:01:41.898Z",
  "allowChangeSubscription": false,
  "widgets": [
    {
      "title": "Ticket Count against Goal",
      "type": "chart/line",
      "subtype": "line/basic",
      "oid": "63187cceeb1be916f824f790",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "x-axis",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Order Days Prior to Opening",
                  "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "datatype": "numeric",
                  "title": "Order Days Prior to Opening"
                },
                "disabled": false
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": "((RSUM(([BA9AC-A4F], [6E18D-34A])))/(( [BA9AC-A4F],ALL([8ABB2-B1B]), [6E18D-34A]))*10000)",
                  "context": {
                    "[6C088-587]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Order Days Prior to Opening"
                    },
                    "[6E18D-34A]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "exclude": {
                          "members": [
                            "0"
                          ]
                        }
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[8ABB2-B1B]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "title": "Order Days Prior to Opening"
                    },
                    "[BA9AC-A4F]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    }
                  },
                  "title": "RSUM(Previous Years Goal)"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#547A94",
                    "type": "color"
                  }
                },
                "singleSeriesType": "column",
                "originalJaql": {
                  "type": "measure",
                  "formula": "(RSUM(([D5519-B4B], [E5DD2-564])))/(( [D5519-B4B],ALL([65FBC-BF6]), [E5DD2-564]))*10000",
                  "context": {
                    "[E5DD2-564]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "exclude": {
                          "members": [
                            "0"
                          ]
                        }
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[46CE0-BA2]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Since OnSale",
                      "dim": "[SEAT & TICKET.Order Days Since OnSale]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Order Days Since OnSale"
                    },
                    "[65FBC-BF6]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Since OnSale",
                      "dim": "[SEAT & TICKET.Order Days Since OnSale]",
                      "datatype": "numeric",
                      "title": "Order Days Since OnSale"
                    },
                    "[D5519-B4B]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    }
                  },
                  "title": "Previous Years Goal"
                },
                "quickFunction": "RSUM"
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "((RSUM(([9BA55-3FE], [9F6BB-4C6], [FD4C4-C64]))))",
                  "context": {
                    "[9F6BB-4C6]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "0"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[9BA55-3FE]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    },
                    "[FD4C4-C64]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "filter": {
                        "last": {
                          "count": 500,
                          "offset": 0
                        },
                        "custom": true
                      },
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
                      }
                    }
                  },
                  "title": "RSUM(This Years Production)"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#F48E06",
                    "type": "color"
                  }
                },
                "originalJaql": {
                  "type": "measure",
                  "formula": "(RSUM(([D8829-0FE], [42DEB-F46], [14287-9D1])))",
                  "context": {
                    "[42DEB-F46]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "0"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[D8829-0FE]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    },
                    "[14287-9D1]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "filter": {
                        "last": {
                          "count": 500,
                          "offset": 0
                        },
                        "custom": true
                      },
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
                      },
                      "fiscal": "jul"
                    },
                    "[981A3-360]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "fiscal": "jul"
                    }
                  },
                  "title": "This Years Production"
                },
                "quickFunction": "RSUM"
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "10000",
                  "context": {},
                  "title": "(Target Amount)"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#DB4935",
                    "type": "color"
                  }
                },
                "originalJaql": {
                  "type": "measure",
                  "formula": "10000",
                  "context": {},
                  "title": "Target Amount"
                },
                "quickFunction": "RSUM"
              }
            ]
          },
          {
            "name": "break by",
            "items": []
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "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": {
        "lineWidth": {
          "width": "bold"
        },
        "legend": {
          "enabled": true,
          "position": "bottom"
        },
        "seriesLabels": {
          "enabled": false,
          "rotation": 0
        },
        "markers": {
          "enabled": false,
          "fill": "filled",
          "size": "small"
        },
        "xAxis": {
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "x2Title": {
            "enabled": false
          },
          "gridLines": true,
          "isIntervalEnabled": false
        },
        "yAxis": {
          "inactive": false,
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "gridLines": true,
          "logarithmic": false,
          "isIntervalEnabled": true
        },
        "y2Axis": {
          "inactive": true,
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "gridLines": false,
          "logarithmic": false,
          "isIntervalEnabled": true
        },
        "navigator": {
          "enabled": true
        },
        "dataLimits": {
          "seriesCapacity": 50,
          "categoriesCapacity": 100000
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "order_days_prior_to_opening",
              "title": "Order Days Prior to Opening",
              "singular": "Order Days Prior to Opening",
              "plural": "Order Days Prior to Opening"
            }
          ]
        }
      },
      "instanceid": "F86D2-9AE2-B4",
      "queryStartTime": "2023-10-17T16:24:17",
      "drawing": true,
      "disableSelctor": false,
      "widgetTimingLoged": false,
      "continuousDates": false,
      "nullAsZero": false,
      "forcedRedraw": 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": 1,
        "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
      },
      "chart": {
        "0": {},
        "context": {},
        "length": 1
      },
      "realTimeRefreshing": false,
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "dashboardFiltersMode": "select",
        "selector": true,
        "triggersDomready": true,
        "autoUpdateOnEveryChange": true,
        "drillToAnywhere": true,
        "previousScrollerLocation": {
          "min": null,
          "max": null
        },
        "selectorLocked": false
      },
      "viewState": {
        "activeTab": "filters"
      }
    },
    {
      "title": "RICHTEXT_MAIN.TITLE",
      "type": "richtexteditor",
      "subtype": "richtexteditor",
      "oid": "63188122eb1be916f824f80a",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": []
      },
      "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": {
        "content": {
          "html": "<font size=\"2\"><div style=\"text-align: left;\"><b>Filters</b><br>Select several productions from past seasons and one from this season on the filters.&nbsp;</div><div style=\"text-align: left;\"><br></div><div style=\"text-align: left;\"><b>Formulas</b></div><div style=\"text-align: left;\">The formula for the value 'Previous Years Goal' takes the total ticket count sold that number of weeks since onsale for all productions selected in the dashboard filters, that aren't in this season fiscal year. It then divides this by the total tickets sold overall for those same productions. This tells us what % of tickets were sold each week as a % of the total tickets sold across those productions.&nbsp;</div><div style=\"text-align: left;\">It then multiplies that % each week by the hard-coded ticket count goal for this productions season. The result is a projection of what % of the goal we should achieve in ticket counts each week based on the sales patterns achieved in the previous productions.&nbsp;</div><div style=\"text-align: left;\"><br></div><div style=\"text-align: left;\">This is then compared to a second value called 'This Years Productions'. This simply provides a running sum of ticket counts by week for the productions selected in the dashboard filters that are in this season fiscal year. This allows us to track actual sales against our target sales for the production season.</div></font>",
          "vAlign": "valign-middle",
          "bgColor": "#FFFFFF",
          "textAlign": "center"
        }
      },
      "instanceid": "8FA37-897C-E3",
      "widgetTimingLoged": false,
      "drawing": true,
      "realTimeRefreshing": false,
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "triggersDomready": true,
        "hideFromWidgetList": true,
        "disableExportToCSV": true,
        "disableExportToImage": true,
        "toolbarButton": {
          "css": "add-rich-text",
          "tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
        },
        "selector": false,
        "disallowSelector": true,
        "disallowWidgetTitle": true,
        "supportsHierarchies": false,
        "dashboardFiltersMode": "filter"
      }
    },
    {
      "title": "Ticket Paid Amount against Goal",
      "type": "chart/line",
      "subtype": "line/basic",
      "oid": "63187f09eb1be916f824f7c4",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "x-axis",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Order Days Prior to Opening",
                  "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "datatype": "numeric",
                  "title": "Order Days Prior to Opening"
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": "(RSUM(([09091-06B], [2FE58-58B])))/(( [09091-06B],ALL([F29F9-1B3]), [2FE58-58B]))*2319274",
                  "context": {
                    "[2FE58-58B]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "exclude": {
                          "members": [
                            "0"
                          ]
                        }
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[F29F9-1B3]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "title": "Order Days Prior to Opening"
                    },
                    "[09091-06B]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Paid Amount",
                      "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Paid Amount"
                    }
                  },
                  "title": "Previous Years Pattern"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#547A94",
                    "type": "color"
                  }
                },
                "singleSeriesType": "column"
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "(RSUM(([9513D-47B], [EA49B-669] ,[F550F-FC1])))",
                  "context": {
                    "[EA49B-669]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "0"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[9513D-47B]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Paid Amount",
                      "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Paid Amount"
                    },
                    "[F550F-FC1]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "filter": {
                        "last": {
                          "count": 500,
                          "offset": 0
                        },
                        "custom": true
                      },
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
                      }
                    }
                  },
                  "title": "This Years Production"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#F48E06",
                    "type": "color"
                  }
                }
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "2319274",
                  "context": {},
                  "title": "Budget Amount"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "abbreviations": {
                      "t": true,
                      "b": true,
                      "m": true,
                      "k": true
                    },
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "color": "#DB4935",
                    "type": "color"
                  }
                }
              }
            ]
          },
          {
            "name": "break by",
            "items": []
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "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": {
        "lineWidth": {
          "width": "bold"
        },
        "legend": {
          "enabled": true,
          "position": "bottom"
        },
        "seriesLabels": {
          "enabled": false,
          "rotation": 0
        },
        "markers": {
          "enabled": false,
          "fill": "filled",
          "size": "small"
        },
        "xAxis": {
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "x2Title": {
            "enabled": false
          },
          "gridLines": true,
          "isIntervalEnabled": false
        },
        "yAxis": {
          "inactive": false,
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "gridLines": true,
          "logarithmic": false,
          "isIntervalEnabled": true
        },
        "y2Axis": {
          "inactive": true,
          "enabled": true,
          "ticks": true,
          "labels": {
            "enabled": true,
            "rotation": 0
          },
          "title": {
            "enabled": false
          },
          "gridLines": false,
          "logarithmic": false,
          "isIntervalEnabled": true
        },
        "navigator": {
          "enabled": true
        },
        "dataLimits": {
          "seriesCapacity": 50,
          "categoriesCapacity": 100000
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "order_days_prior_to_opening",
              "title": "Order Days Prior to Opening",
              "singular": "Order Days Prior to Opening",
              "plural": "Order Days Prior to Opening"
            }
          ]
        }
      },
      "instanceid": "F86D2-9AE2-B4",
      "queryStartTime": "2023-01-31T16:54:15",
      "disableSelctor": false,
      "widgetTimingLoged": false,
      "continuousDates": false,
      "nullAsZero": false,
      "forcedRedraw": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": true,
        "volatile": false,
        "hideDrilledDashboards": false,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 1,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true
      },
      "chart": {
        "0": {},
        "context": {},
        "length": 1
      },
      "realTimeRefreshing": false,
      "viewState": {
        "activeTab": "filters"
      },
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "dashboardFiltersMode": "select",
        "selector": true,
        "triggersDomready": true,
        "autoUpdateOnEveryChange": true,
        "drillToAnywhere": true,
        "previousScrollerLocation": {
          "min": null,
          "max": null
        },
        "selectorLocked": false
      },
      "drawing": true,
      "canEditFilters": true
    },
    {
      "title": "Ticket Count against Goal",
      "type": "pivot",
      "subtype": "pivot",
      "oid": "63188332eb1be916f824f8b6",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Order Days Prior to Opening",
                  "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "datatype": "numeric",
                  "title": "Order Days Prior to Opening"
                },
                "field": {
                  "id": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "index": 0
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": "(RSUM(([96002-ED0], [7B2E7-D85])))/(( [96002-ED0],ALL([5A422-5F7]), [7B2E7-D85]))*10000",
                  "context": {
                    "[7B2E7-D85]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "exclude": {
                          "members": [
                            "0"
                          ]
                        }
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[BB1B1-394]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "agg": "countduplicates",
                      "title": "# of Order Days Prior to Opening"
                    },
                    "[5A422-5F7]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "title": "Order Days Prior to Opening"
                    },
                    "[96002-ED0]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    }
                  },
                  "title": "Previous Years Goal"
                },
                "format": {
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 0,
                    "number": {
                      "separated": true
                    }
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "singleSeriesType": "column",
                "field": {
                  "id": "(RSUM(([96002-ED0], [7B2E7-D85])))/(( [96002-ED0],ALL([5A422-5F7]), [7B2E7-D85]))*10000",
                  "index": 1
                }
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "RSUM(([7793F-DA7], [95521-CD4], [6B668-E03]))",
                  "context": {
                    "[95521-CD4]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "0"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[7793F-DA7]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Count",
                      "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Count"
                    },
                    "[6B668-E03]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "filter": {
                        "last": {
                          "count": 500,
                          "offset": 0
                        },
                        "custom": true
                      },
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
                      },
                      "fiscal": "jul"
                    }
                  },
                  "title": "This Years Production"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "RSUM(([7793F-DA7], [95521-CD4], [6B668-E03]))",
                  "index": 2
                }
              }
            ]
          },
          {
            "name": "columns",
            "items": []
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "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": false,
          "members": false,
          "totals": false
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "order_days_prior_to_opening",
              "title": "Order Days Prior to Opening",
              "singular": "Order Days Prior to Opening",
              "plural": "Order Days Prior to Opening"
            }
          ]
        }
      },
      "instanceid": "947C7-793B-B8",
      "queryStartTime": "2022-11-18T09:37:21",
      "disableSelctor": false,
      "widgetTimingLoged": false,
      "continuousDates": false,
      "nullAsZero": false,
      "forcedRedraw": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": true,
        "volatile": false,
        "hideDrilledDashboards": false,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 1,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true
      },
      "chart": {
        "0": {},
        "context": {},
        "length": 1
      },
      "realTimeRefreshing": false,
      "viewState": {
        "activeTab": "filters"
      },
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true,
        "selectorLocked": false
      },
      "drawing": true,
      "canEditFilters": true,
      "currentPage": 18,
      "script_old": null,
      "script": null
    },
    {
      "title": "Ticket Paid Amount against Goal",
      "type": "pivot",
      "subtype": "pivot",
      "oid": "6318854aeb1be916f824f92e",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET DETAILS",
                  "column": "Order Days Prior to Opening",
                  "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "datatype": "numeric",
                  "title": "Order Days Prior to Opening"
                },
                "field": {
                  "id": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                  "index": 0
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": "(RSUM(([A2B72-008], [C4487-0C4])))/(( [A2B72-008],ALL([0175E-A58]), [C4487-0C4]))*2319274",
                  "context": {
                    "[C4487-0C4]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "exclude": {
                          "members": [
                            "0"
                          ]
                        }
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[0175E-A58]": {
                      "table": "SEAT & TICKET DETAILS",
                      "column": "Order Days Prior to Opening",
                      "dim": "[SEAT & TICKET DETAILS.Order Days Prior to Opening]",
                      "datatype": "numeric",
                      "title": "Order Days Prior to Opening"
                    },
                    "[A2B72-008]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Paid Amount",
                      "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Paid Amount"
                    }
                  },
                  "title": "Previous Years Goal"
                },
                "format": {
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "currency": {
                      "symbol": "$",
                      "position": "pre"
                    }
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "singleSeriesType": "column",
                "field": {
                  "id": "(RSUM(([A2B72-008], [C4487-0C4])))/(( [A2B72-008],ALL([0175E-A58]), [C4487-0C4]))*2319274",
                  "index": 1
                }
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "(RSUM(([79E99-5F6] ,[D2E17-4DF],  [36F31-B0D])))",
                  "context": {
                    "[D2E17-4DF]": {
                      "table": "SEASON",
                      "column": "Season Fiscal Current Year Offset",
                      "dim": "[SEASON.Season Fiscal Current Year Offset]",
                      "datatype": "numeric",
                      "title": "Season Fiscal Current Year Offset",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "0"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets",
                        "lastBuildTime": "2022-09-07T05:18:24"
                      }
                    },
                    "[79E99-5F6]": {
                      "table": "SEAT & TICKET VALUES",
                      "column": "Ticket Paid Amount",
                      "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Ticket Paid Amount"
                    },
                    "[36F31-B0D]": {
                      "table": "ORDER DATE",
                      "column": "Date",
                      "dim": "[ORDER DATE.Date (Calendar)]",
                      "datatype": "datetime",
                      "merged": true,
                      "level": "days",
                      "title": "Days in Date",
                      "filter": {
                        "last": {
                          "count": 500,
                          "offset": 0
                        },
                        "custom": true
                      },
                      "datasource": {
                        "title": "CDNB-Seats and Tickets",
                        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
                        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
                        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
                        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
                      },
                      "fiscal": "jul"
                    }
                  },
                  "title": "This Years Production"
                },
                "format": {
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "currency": {
                      "symbol": "$",
                      "position": "pre"
                    }
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "(RSUM(([79E99-5F6] ,[D2E17-4DF],  [36F31-B0D])))",
                  "index": 2
                }
              }
            ]
          },
          {
            "name": "columns",
            "items": []
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "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": false,
          "members": false,
          "totals": false
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "order_days_prior_to_opening",
              "title": "Order Days Prior to Opening",
              "singular": "Order Days Prior to Opening",
              "plural": "Order Days Prior to Opening"
            }
          ]
        }
      },
      "instanceid": "741FF-182A-AA",
      "queryStartTime": "2022-11-18T09:37:54",
      "disableSelctor": false,
      "widgetTimingLoged": false,
      "continuousDates": false,
      "nullAsZero": false,
      "forcedRedraw": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": true,
        "volatile": false,
        "hideDrilledDashboards": false,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 1,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true
      },
      "chart": {
        "0": {},
        "context": {},
        "length": 1
      },
      "realTimeRefreshing": false,
      "viewState": {
        "activeTab": "filters"
      },
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true
      },
      "drawing": true,
      "canEditFilters": true,
      "currentPage": 1,
      "script_old": null,
      "script": null
    },
    {
      "title": "",
      "type": "pivot",
      "subtype": "pivot",
      "oid": "631b3f6cc4e0dc0934003eae",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "CDNB-Seats and Tickets",
        "fullname": "USEA2SAPCUBE204.aws.tnhs.cloud/CDNB-Seats and Tickets",
        "id": "aUSEA2SAPCUBE204LgAaAWSLgAaTNHSLgAaCLOUD_aCDNBLQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE204.aws.tnhs.cloud",
        "database": "aCDNBLQAaSeatsIAAaandIAAaTickets"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "SEASON",
                  "column": "Season",
                  "dim": "[SEASON.Season]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Season",
                  "sort": "desc",
                  "sortDetails": {
                    "field": 0,
                    "dir": "desc",
                    "measurePath": null,
                    "sortingLastDimension": false,
                    "initialized": true
                  }
                },
                "field": {
                  "id": "[SEASON.Season]",
                  "index": 0
                }
              },
              {
                "jaql": {
                  "table": "PERFORMANCE DETAIL",
                  "column": "Production",
                  "dim": "[PERFORMANCE DETAIL.Production]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Production"
                },
                "field": {
                  "id": "[PERFORMANCE DETAIL.Production]",
                  "index": 1
                }
              },
              {
                "jaql": {
                  "table": "PERFORMANCE DETAIL",
                  "column": "Production Season",
                  "dim": "[PERFORMANCE DETAIL.Production Season]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Production Season"
                },
                "field": {
                  "id": "[PERFORMANCE DETAIL.Production Season]",
                  "index": 2
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": "SUM([E5212-D16],MAX([31418-FB1]))",
                  "context": {
                    "[BB287-22E]": {
                      "table": "PERFORMANCE DETAIL",
                      "column": "Budget Amount",
                      "dim": "[PERFORMANCE DETAIL.Budget Amount]",
                      "datatype": "numeric",
                      "agg": "sum",
                      "title": "Total Budget Amount"
                    },
                    "[E5212-D16]": {
                      "table": "PERFORMANCE DETAIL",
                      "column": "Performance ID",
                      "dim": "[PERFORMANCE DETAIL.Performance ID]",
                      "datatype": "numeric",
                      "merged": true,
                      "title": "Performance ID"
                    },
                    "[31418-FB1]": {
                      "table": "PERFORMANCE DETAIL",
                      "column": "Budget Amount",
                      "dim": "[PERFORMANCE DETAIL.Budget Amount]",
                      "datatype": "numeric",
                      "title": "Budget Amount"
                    }
                  },
                  "title": "Budget Amount"
                },
                "format": {
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "currency": {
                      "symbol": "$",
                      "position": "pre"
                    }
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "SUM([E5212-D16],MAX([31418-FB1]))",
                  "index": 3
                }
              },
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Paid Amount",
                  "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total Ticket Paid Amount"
                },
                "format": {
                  "mask": {
                    "abbreviations": {
                      "t": false,
                      "b": false,
                      "m": false,
                      "k": false
                    },
                    "decimals": 2,
                    "currency": {
                      "symbol": "$",
                      "position": "pre"
                    }
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
                  "index": 4
                }
              }
            ]
          },
          {
            "name": "columns",
            "items": []
          },
          {
            "name": "filters",
            "items": []
          }
        ]
      },
      "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": false,
          "members": false,
          "totals": false
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "season",
              "title": "Season",
              "singular": "Season",
              "plural": "Season"
            },
            {
              "id": "production",
              "title": "Production",
              "singular": "Production",
              "plural": "Production"
            },
            {
              "id": "production_season",
              "title": "Production Season",
              "singular": "Production Season",
              "plural": "Production Season"
            }
          ]
        }
      },
      "instanceid": "4C6F4-9C21-43",
      "queryStartTime": "2022-11-18T06:53:13",
      "drawing": true,
      "widgetTimingLoged": false,
      "drillToDashboardConfig": {
        "drilledDashboardPrefix": "_",
        "drilledDashboardsFolderPrefix": "",
        "displayFilterPane": true,
        "displayDashboardsPane": false,
        "displayToolbarRow": true,
        "displayHeaderRow": true,
        "volatile": false,
        "hideDrilledDashboards": false,
        "drillToDashboardMenuCaption": "Jump to dashboard",
        "drillToDashboardRightMenuCaption": "Jump to ",
        "drillToDashboardNavigateType": 1,
        "drillToDashboardNavigateTypePivot": 2,
        "drillToDashboardNavigateTypeCharts": 1,
        "drillToDashboardNavigateTypeOthers": 3,
        "excludeFilterDims": [],
        "includeFilterDims": [],
        "drilledDashboardDisplayType": 2,
        "dashboardIds": [],
        "modalWindowResize": false,
        "showFolderNameOnMenuSelection": false,
        "resetDashFiltersAfterJTD": false,
        "sameCubeRestriction": true,
        "showJTDIcon": true
      },
      "canEditFilters": true,
      "viewState": {
        "activeTab": "filters"
      },
      "realTimeRefreshing": false,
      "dashboardid": "63187b9beb1be916f824f74f",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true,
        "selectorLocked": false
      },
      "script_old": null,
      "script": null
    }
  ],
  "hierarchies": []
}