{
"title": "Sharing Dashboard",
"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": "4CE60-EDAA-06",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "36px",
"defaultWidth": 128,
"widgetid": "629d8da9edc0f31b0816f5bc"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1430,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "32px",
"defaultWidth": 128,
"widgetid": "629d8da9edc0f31b0816f5b8"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1430,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 256,
"maxHeight": 2048,
"minWidth": 256,
"maxWidth": 2048,
"height": 640,
"defaultWidth": 512,
"widgetid": "629d8da9edc0f31b0816f5b9"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1430,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": 512,
"defaultWidth": 512,
"widgetid": "629d8da9edc0f31b0816f5bb"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1430,
"index": 0
}
]
}
],
"pxlWidth": 1430,
"index": 0
}
],
"container": {}
},
"original": null,
"oid": "629d8da9edc0f31b0816f5b3",
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
},
"editing": true,
"filters": [
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
},
"collapsed": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022 Season"
]
}
},
"instanceid": "9AED9-F9FF-FE",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-03T22:18:21"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022 Chamber Series",
"2022 Classics Unwrapped",
"2022 Matinee Series",
"2022 Messiah",
"2022 Sanctuary Series",
"2022 She Speaks",
"2022 Showcase Series",
"2022 Special Events",
"2022 Symphony Series",
"2022 Beethoven Symphonies",
"2022 Family"
]
}
},
"instanceid": "DA098-67DF-9F",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance",
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-03-29T22:19:08"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"She Speaks – Discovery",
"She Speaks – Epic",
"She Speaks – Home-Grown",
"She Speaks – Panorama",
"She Speaks – Symposium",
"She Speaks – Trailblazers",
"She Speaks – Women Composers"
],
"filter": {
"turnedOff": true,
"exclude": {
"members": [
"She Speaks – Women Composers",
"She Speaks – Symposium",
"She Speaks – Home-Grown",
"She Speaks – Discovery",
"She Speaks – Epic",
"She Speaks – Panorama",
"She Speaks – Trailblazers"
]
}
}
}
},
"instanceid": "26B86-4397-68",
"isCascading": false,
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-09T22:18:53"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022 Classics Unwrapped 1"
]
}
},
"instanceid": "06D52-F8F1-CE",
"isCascading": false,
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"collapsed": false,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-13T22:18:33"
},
"filter": {
"doesntContain": "comp"
}
},
"instanceid": "209EF-5C3F-D7",
"isCascading": false,
"disabled": true
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "Lists",
"dim": "[CONSTITUENT.Lists]",
"datatype": "text",
"merged": true,
"title": "Lists",
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-15T22:18:57"
},
"collapsed": false,
"filter": {
"contains": ",29643,"
}
},
"instanceid": "F3471-8CB6-A0",
"isCascading": false,
"disabled": true
},
{
"jaql": {
"datatype": "datetime",
"dim": "[ORDER DATE.Date (Calendar)]",
"title": "Weeks in Date",
"level": "weeks",
"firstday": "mon",
"column": "Date",
"table": "ORDER DATE",
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
},
"collapsed": true,
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
}
},
"instanceid": "CA348-5386-19",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"parentFolder": "626a0e1bb944b12ea0bb24bd",
"widgets": [
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-03T22:18:21"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "629d8da9edc0f31b0816f5b8",
"type": "richtexteditor",
"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": "",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "F9D2B-CE45-3A",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "629d8da9edc0f31b0816f5b3",
"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": "WIP stats - includes comp tickets",
"subtype": "pivot",
"desc": null,
"source": null,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[ORDER DATE.Date (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"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": 0
},
"format": {
"width": 265
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([1BD79-4E2])",
"context": {
"[1BD79-4E2]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
}
},
"title": "Total Sold Tickets"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 97
},
"field": {
"id": "sum([1BD79-4E2])",
"index": 1
}
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "Individual Ticket Buyers"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 132
},
"field": {
"id": "[CONSTITUENT.Constituent ID]_count",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "Count([80217-9C8],IF(MIN(DDIFF([A89E6-EAE],[3BF1F-36A]))=0, MAX([80217-9C8]),NULL))",
"context": {
"[3BF1F-36A]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in First Performance Date"
},
"[80217-9C8]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[A89E6-EAE]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "First Time Buyers"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 119
},
"field": {
"id": "Count([80217-9C8],IF(MIN(DDIFF([A89E6-EAE],[3BF1F-36A]))=0, MAX([80217-9C8]),NULL))",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "(SUM([9E502-1F5],IF(MIN(DDIFF([5622C-F88],[F67D1-EEA]))=0, MAX([AF716-2C8]),NULL)))/[AF716-2C8]",
"context": {
"[F67D1-EEA]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in First Performance Date"
},
"[AF716-2C8]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[9E502-1F5]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[5622C-F88]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "% new audience"
},
"format": {
"mask": {
"decimals": "auto",
"percent": true
},
"width": 90,
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(SUM([9E502-1F5],IF(MIN(DDIFF([5622C-F88],[F67D1-EEA]))=0, MAX([AF716-2C8]),NULL)))/[AF716-2C8]",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "SUM([B0F67-065],IF(MIN(DDIFF([51A58-53F],[5B0D6-6E4]))=0, MAX([74E77-389]),NULL))",
"context": {
"[5B0D6-6E4]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in First Performance Date"
},
"[74E77-389]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[B0F67-065]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[51A58-53F]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "First Time Tickets"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"width": 90,
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "SUM([B0F67-065],IF(MIN(DDIFF([51A58-53F],[5B0D6-6E4]))=0, MAX([74E77-389]),NULL))",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum ( [608B6-24C] ) , [FD577-E25] )",
"context": {
"[608B6-24C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[FD577-E25]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"filter": {
"contains": "sub"
},
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Number of Subscriber Tickets"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 104
},
"field": {
"id": "(sum ( [608B6-24C] ) , [FD577-E25] )",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "((sum ( [42B0A-2FD] ) , [B0E91-7DC] )/[42B0A-2FD])",
"context": {
"[42B0A-2FD]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[B0E91-7DC]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"filter": {
"contains": "sub"
},
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "% Subscriber Tickets"
},
"format": {
"mask": {
"decimals": "auto",
"percent": true
},
"width": 106,
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "((sum ( [42B0A-2FD] ) , [B0E91-7DC] )/[42B0A-2FD])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum ( [9F7AB-0ED] ) , [B99F2-F2E] )",
"context": {
"[9F7AB-0ED]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[B99F2-F2E]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"filter": {
"contains": "live pass"
},
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Number of Live Pass Tickets"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 108
},
"field": {
"id": "(sum ( [9F7AB-0ED] ) , [B99F2-F2E] )",
"index": 8
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([85296-CA8]/[5F0B3-0B5])",
"context": {
"[5F0B3-0B5]": {
"table": "ORDER DETAILS",
"column": "Order ID",
"dim": "[ORDER DETAILS.Order ID]",
"datatype": "numeric",
"agg": "count",
"title": "# of unique Order ID"
},
"[85296-CA8]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
}
},
"title": "Average ticket number per order"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 122
},
"field": {
"id": "sum([85296-CA8]/[5F0B3-0B5])",
"index": 9
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum ( [5D74F-C78] ) , [C97A0-84F] )",
"context": {
"[5D74F-C78]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[F5551-B62]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"filter": {
"or": [
{
"contains": "30 and under"
},
{
"contains": "30 & under"
}
]
},
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
},
"[C97A0-84F]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type",
"dim": "[PERFORMANCE PRICING.Price Type]",
"datatype": "text",
"merged": true,
"title": "Price Type",
"filter": {
"or": [
{
"contains": "30 and under"
},
{
"contains": "30 & under"
},
{
"contains": "30andunder"
}
]
},
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Number of 30 & Under Tickets"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 128
},
"field": {
"id": "(sum ( [5D74F-C78] ) , [C97A0-84F] )",
"index": 10
}
},
{
"jaql": {
"type": "measure",
"formula": "MIN(DDiff([82C3E-F31],NOW([82C3E-F31])))",
"context": {
"[82C3E-F31]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"sortDetails": {
"field": 11,
"dir": "asc",
"sortingLastDimension": true,
"measurePath": null,
"initialized": true
},
"sort": "asc",
"title": "Ignore"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "MIN(DDiff([82C3E-F31],NOW([82C3E-F31])))",
"index": 11
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "629d8da9edc0f31b0816f5b9",
"type": "pivot",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"pageSize": "8",
"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": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
}
]
}
},
"instanceid": "0FFBD-AE36-92",
"queryStartTime": "2022-05-12T16:36:50",
"widgetTimingLoged": false,
"drawing": true,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "629d8da9edc0f31b0816f5b3",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true,
"drillTarget": {
"oid": "5ea86ddd42ba532104076b38",
"caption": "_Constituents",
"folder": "5f919b510f6e292eb436be59"
},
"selectorLocked": false
},
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 2,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"drilledDashboardDisplay": {}
},
{
"title": "Ticket Sales Weeks Prior to Performance",
"subtype": "column/classic",
"desc": null,
"source": "6053d61cb92cbf0b34ff2434",
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[SEATING.Screen]",
"[CONSTITUENT.Lists]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"disabled": true
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon"
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "dd, MMM",
"days": "dd MMM",
"minutes": "HH:mm"
}
},
"hierarchies": [
"calendar",
"calendar - weeks"
],
"disabled": false
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([011C5-65A])",
"context": {
"[011C5-65A]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
}
},
"title": "sum([Total Ticket Count])"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"number": {
"separated": true
}
},
"color_bkp": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category"
},
"format": {
"members": {
"Standard": {
"color": "#547A94",
"title": "Standard",
"sortData": "Standard",
"inResultset": true
},
"Subscription": {
"color": "#F48E06",
"title": "Subscription",
"sortData": "Subscription",
"inResultset": true
},
"Comp": {
"color": "#DB4935",
"title": "Comp",
"sortData": "Comp"
},
"Discount": {
"color": "#333333",
"title": "Discount",
"sortData": "Discount"
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance",
"filter": {
"explicit": false,
"multiSelection": "true",
"all": true
},
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
},
"title": "Order Weeks Prior to Performance",
"disabled": true
},
{
"jaql": {
"table": "ATTENDED DATE",
"column": "Date",
"dim": "[ATTENDED DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Years in Date",
"filter": {
"from": "2021-08-01",
"to": "2021-08-01"
},
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Years in Date",
"disabled": true
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"from": "2021-12-01"
},
"collapsed": true,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Discount",
"Comp",
"Combo",
"Administration"
]
}
},
"collapsed": false,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets"
}
}
}
]
}
]
},
"oid": "629d8da9edc0f31b0816f5bb",
"type": "chart/column",
"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": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0
},
"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,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"lineWidth": {
"width": "bold"
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "order_weeks_prior_to_performance",
"title": "Order Weeks Prior to Performance",
"singular": "Order Weeks Prior to Performance",
"plural": "Order Weeks Prior to Performance"
},
{
"id": "weeks",
"title": "weeks",
"singular": "weeks",
"plural": "weeks"
},
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
}
]
}
},
"instanceid": "C80EF-4DBA-47",
"queryStartTime": "2022-06-06T09:53:47",
"disableSelctor": 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
},
"widgetTimingLoged": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"continuousDates": false,
"nullAsZero": false,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"minDate": 1638365400000,
"maxDate": 1654093800000,
"tickInterval": 604800000,
"tickLevel": "week",
"drilledDashboardDisplay": {},
"drawing": true,
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 26
},
"selectorLocked": false,
"drillTarget": {
"oid": "5ea86ddd42ba532104076b38",
"caption": "_Constituents",
"folder": "5f919b510f6e292eb436be59"
}
},
"dashboardid": "629d8da9edc0f31b0816f5b3"
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"datasource": {
"title": "ADSO-Seats and Tickets",
"fullname": "APSE2JAPCUBE006.aws.tnhs.cloud/ADSO-Seats and Tickets",
"id": "aAPSE2JAPCUBE006LgAaAWSLgAaTNHSLgAaCLOUD_aADSOLQAaSEATSIAAaANDIAAaTICKETS",
"address": "APSE2JAPCUBE006.aws.tnhs.cloud",
"database": "aADSOLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-10T22:18:34"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "629d8da9edc0f31b0816f5bc",
"type": "richtexteditor",
"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": "Please note, all data includes comps and partially paid tickets unless otherwise stated.
For easy filtering, turn on \"Production\" filtering on the right panel, and then filter via series.
",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "97FAE-F0E6-72",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "629d8da9edc0f31b0816f5b3",
"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"
}
}
],
"hierarchies": []
}