{
"title": "Sales Velocity Curves - % of Zone Capacity Sold (in development)",
"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": "9FAA1-67B4-40",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": 128,
"defaultWidth": 128,
"widgetid": "6373a197d25ac60284e1796f"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1403,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "63739c50d25ac60284e178d3",
"height": "536px"
}
],
"width": 50.812763395544856,
"stretchable": false,
"pxlWidth": 713,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "63739c50d25ac60284e178d2",
"height": "536px"
}
],
"width": 49.18723660445515,
"stretchable": false,
"pxlWidth": 690,
"index": 1
}
]
}
],
"pxlWidth": 1403,
"index": 0
}
],
"container": {
"sizzle-1668519701694": {
"parentNode": [
"1310 117",
2
]
}
}
},
"original": null,
"oid": "63739c50d25ac60284e178cf",
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets"
},
"editing": true,
"filters": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Status",
"dim": "[PERFORMANCE DETAIL.Status]",
"datatype": "text",
"merged": true,
"title": "Status",
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-10-21T07:22:45"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Cancelled",
"Off Sale"
]
}
}
},
"instanceid": "28A75-DE9A-72",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Day Of Week Sort",
"dim": "[PERFORMANCE DATE.Day Of Week Sort]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Sort",
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
}
},
"instanceid": "B6C6C-F337-CA",
"isCascading": false,
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Time Slot",
"dim": "[PERFORMANCE DETAIL.Time Slot]",
"datatype": "text",
"merged": true,
"title": "Time Slot",
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"L"
]
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Afternoon",
"Eve",
"Matinee",
"Morning",
"Night"
]
}
}
},
"instanceid": "97DAA-48EB-6E",
"isCascading": false,
"disabled": true
}
],
"filterToDatasourceMapping": {},
"script": "/*\nWelcome to your Dashboard's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\n\nwidget.on(\"beforeviewloaded\",function(scope, args){\nargs.options.plotOptions.series.connectNulls = true;\n});\n \n//Turns off the markers\n \nwidget.on('render', function(sender,se){\nfor (var i = 0; i < sender.queryResult.series.length; i++ ) {\n for (var j = 0; j < sender.queryResult.series[i].data.length; j++) {\n sender.queryResult.series[i].data[j].marker.enabled = false;\n }\n }\n}\n)",
"parentFolder": "634f4e6bd81e3f06d81f98f2",
"isPublic": null,
"widgets": [
{
"title": "[Rroduction Season] - script connector",
"subtype": "line/basic",
"desc": "This widget looks at how quickly zones are filling by percentage sold (as opposed to number of tickets sold). Dates along the bottom can be calendar weeks in the year or weeks since onsale. These can be switched to days, but may overwhelm the widget if a show has been on sale for a long time. When switching between date types, make sure the values and X-axis fields match (on the left side of the widget editing screen). -GF",
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"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": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
},
"continuous": false
},
"hierarchies": [
"calendar",
"calendar - weeks"
],
"disabled": false
},
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Since OnSale",
"dim": "[SEAT & TICKET.Order Weeks Since OnSale]",
"datatype": "numeric",
"title": "Order Weeks Since OnSale"
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "RSUM ( [3EEBE-225] ) / ( [9B81D-6DA] , ALL ( [AB47C-57B]) )",
"context": {
"[3EEBE-225]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid/Reserved Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid/Reserved Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid/Reserved Count"
},
"[9B81D-6DA]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
},
"[AB47C-57B]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon"
},
"[8655F-CA0]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "WeeksinDate"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color_bkp": {
"color": "#547A94",
"type": "color"
}
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "RSUM ( [5ACE2-97B] ) / ([7793C-F4E] , all([44B5F-499]), all([DBD6C-91F]))",
"context": {
"[5ACE2-97B]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid/Reserved Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid/Reserved Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid/Reserved Count"
},
"[44B5F-499]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Since OnSale",
"dim": "[SEAT & TICKET.Order Weeks Since OnSale]",
"datatype": "numeric",
"title": "Order Weeks Since OnSale"
},
"[7793C-F4E]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
},
"[DBD6C-91F]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon"
}
},
"title": "WeeksFromOnsale"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
}
},
"disabled": true
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "ZONE",
"column": "Zone",
"dim": "[ZONE.Zone]",
"datatype": "text",
"merged": true,
"title": "Zone"
},
"format": {
"members": {
"Balcony zone M": {
"color": "#b83d2d",
"title": "Balcony zone M",
"sortData": "Balcony zone M",
"inResultset": true
},
"Box zone K": {
"color": "#ffa62e",
"title": "Box zone K",
"sortData": "Box zone K",
"inResultset": true
},
"Orchestra zone A": {
"color": "#e6e6e6",
"title": "Orchestra zone A",
"sortData": "Orchestra zone A",
"inResultset": true
},
"Orchestra zone B": {
"color": "#808080",
"title": "Orchestra zone B",
"sortData": "Orchestra zone B",
"inResultset": true
},
"Orchestra zone C": {
"color": "#000000",
"title": "Orchestra zone C",
"sortData": "Orchestra zone C",
"inResultset": true
},
"Orchestra zone D": {
"color": "#0e69c9",
"title": "Orchestra zone D",
"sortData": "Orchestra zone D",
"inResultset": true
},
"Orchestra zone F": {
"color": "#92d9f7",
"title": "Orchestra zone F",
"sortData": "Orchestra zone F"
},
"Orchestra zone G": {
"color": "#92d9f7",
"title": "Orchestra zone G",
"sortData": "Orchestra zone G",
"inResultset": true
},
"Orchestra zone J": {
"color": "#53f222",
"title": "Orchestra zone J",
"sortData": "Orchestra zone J",
"inResultset": true
},
"Balcony zone N": {
"color": "#ff6752",
"title": "Balcony zone N",
"sortData": "Balcony zone N",
"inResultset": true
},
"Orchestra zone E": {
"color": "#44b2f2",
"title": "Orchestra zone E",
"sortData": "Orchestra zone E",
"inResultset": true
},
"Orchestra zone H": {
"color": "#12c77b",
"title": "Orchestra zone H",
"sortData": "Orchestra zone H",
"inResultset": true
},
"Balcony zone O": {
"color": "#eac1f5",
"title": "Balcony zone O",
"sortData": "Balcony zone O",
"inResultset": true
},
"White House Box": {
"color": "#3f3f3f",
"title": "White House Box",
"sortData": "White House Box",
"inResultset": true
},
"Box zone L": {
"color": "#cd7705",
"title": "Box zone L",
"sortData": "Box zone L",
"inResultset": true
},
"-39": {
"color": "#6fa1c3",
"title": "-39",
"sortData": -39
},
"-38": {
"color": "#ffa62e",
"title": "-38",
"sortData": -38
},
"-37": {
"color": "#ff6752",
"title": "-37",
"sortData": -37
},
"-36": {
"color": "#434343",
"title": "-36",
"sortData": -36
},
"-35": {
"color": "#00b29a",
"title": "-35",
"sortData": -35
},
"-34": {
"color": "#74a9cd",
"title": "-34",
"sortData": -34
},
"-33": {
"color": "#ffaa38",
"title": "-33",
"sortData": -33
},
"-32": {
"color": "#ff6f5b",
"title": "-32",
"sortData": -32
},
"-31": {
"color": "#474747",
"title": "-31",
"sortData": -31
},
"-30": {
"color": "#00bba2",
"title": "-30",
"sortData": -30
},
"-29": {
"color": "#79afd5",
"title": "-29",
"sortData": -29
},
"-28": {
"color": "#ffad3f",
"title": "-28",
"sortData": -28
},
"-27": {
"color": "#ff7461",
"title": "-27",
"sortData": -27
},
"-26": {
"color": "#494949",
"title": "-26",
"sortData": -26
},
"-25": {
"color": "#00c2a8",
"title": "-25",
"sortData": -25
},
"-24": {
"color": "#7cb4db",
"title": "-24",
"sortData": -24
},
"-23": {
"color": "#ffaf45",
"title": "-23",
"sortData": -23
},
"-22": {
"color": "#ff7966",
"title": "-22",
"sortData": -22
},
"-21": {
"color": "#4b4b4b",
"title": "-21",
"sortData": -21
},
"-20": {
"color": "#00c7ad",
"title": "-20",
"sortData": -20
},
"-19": {
"color": "#7fb8df",
"title": "-19",
"sortData": -19
},
"-18": {
"color": "#ffb14a",
"title": "-18",
"sortData": -18
},
"-17": {
"color": "#ff7d6b",
"title": "-17",
"sortData": -17
},
"-16": {
"color": "#4d4d4d",
"title": "-16",
"sortData": -16
},
"-15": {
"color": "#00ccb1",
"title": "-15",
"sortData": -15
},
"-14": {
"color": "#81bce4",
"title": "-14",
"sortData": -14
},
"-13": {
"color": "#ffb34e",
"title": "-13",
"sortData": -13
},
"-12": {
"color": "#ff806f",
"title": "-12",
"sortData": -12
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Theater - 2023"
]
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-10-21T07:22:45"
},
"collapsed": true
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BCS: Kiss of the Spider Woman"
],
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BCS: Guys and Dolls",
"BCS: Bye Bye Birdie",
"BCS: Chess",
"BCS: Footloose",
"BCS: How to Succeed",
"BCS: In the Heights",
"BCS: Kiss of the Spider Woman",
"BCS: Little Shop of Horrors",
"BCS: Next to Normal",
"BCS: Sunset Boulevard\t\t\t\t\t\t\t\t\t",
"BCS: The Music Man",
"BCS: Tommy"
]
}
},
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-10-21T07:22:45"
}
}
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"1900-01-01T00:00:00"
]
},
"custom": true
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"collapsed": true
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
}
}
]
}
]
},
"oid": "63739c50d25ac60284e178d2",
"type": "chart/line",
"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": true
},
"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": "weeks",
"title": "weeks",
"singular": "weeks",
"plural": "weeks"
},
{
"id": "order_weeks_since_onsale",
"title": "Order Weeks Since OnSale",
"singular": "Order Weeks Since OnSale",
"plural": "Order Weeks Since OnSale"
},
{
"id": "zone",
"title": "Zone",
"singular": "Zone",
"plural": "Zone"
},
{
"id": "season",
"title": "Season",
"singular": "Season",
"plural": "Season"
},
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
}
]
}
},
"instanceid": "D7A28-33B6-85",
"queryStartTime": "2022-11-15T09:25:42",
"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
},
"minDate": 1652328000000,
"maxDate": 1668661200000,
"tickInterval": 604800000,
"tickLevel": "week",
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"showNulls": {
"Weeks in Date": false,
"Zone": false,
"WeeksinDate": false,
"Season": false,
"Production Season": false,
"Status": false,
"Time Slot": false
},
"dateLevel": "weeks",
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/widget.on(\"beforeviewloaded\",function(scope, args){ args.options.plotOptions.series.connectNulls = true; });",
"dashboardid": "63739c50d25ac60284e178cf",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "[Production Season] - unedited",
"subtype": "line/basic",
"desc": "This widget looks at how quickly zones are filling by percentage sold (as opposed to number of tickets sold). Dates along the bottom can be calendar weeks in the year or weeks since onsale. These can be switched to days, but may overwhelm the widget if a show has been on sale for a long time. When switching between date types, make sure the values and X-axis fields match (on the left side of the widget editing screen). -GF",
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"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": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"hierarchies": [
"calendar",
"calendar - weeks"
],
"disabled": false
},
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Since OnSale",
"dim": "[SEAT & TICKET.Order Weeks Since OnSale]",
"datatype": "numeric",
"title": "Order Weeks Since OnSale"
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "RSUM ( [3EEBE-225] ) / ( [9B81D-6DA] , ALL ( [AB47C-57B]) )",
"context": {
"[3EEBE-225]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid/Reserved Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid/Reserved Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid/Reserved Count"
},
"[9B81D-6DA]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
},
"[AB47C-57B]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon"
},
"[8655F-CA0]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "WeeksinDate"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color_bkp": {
"color": "#547A94",
"type": "color"
}
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "RSUM ( [3CB07-C3D] ) / ([D78D4-A33] , all([92251-540]), all([20FB5-A56]))",
"context": {
"[3CB07-C3D]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid/Reserved Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid/Reserved Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid/Reserved Count"
},
"[92251-540]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Since OnSale",
"dim": "[SEAT & TICKET.Order Weeks Since OnSale]",
"datatype": "numeric",
"title": "Order Weeks Since OnSale"
},
"[D78D4-A33]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
},
"[20FB5-A56]": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon"
}
},
"title": "WeeksFromOnsale"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
}
},
"disabled": true
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "ZONE",
"column": "Zone",
"dim": "[ZONE.Zone]",
"datatype": "text",
"merged": true,
"title": "Zone"
},
"format": {
"members": {
"Balcony zone M": {
"color": "#db4935",
"title": "Balcony zone M",
"sortData": "Balcony zone M",
"inResultset": true
},
"Box zone K": {
"color": "#ffa62e",
"title": "Box zone K",
"sortData": "Box zone K",
"inResultset": true
},
"Orchestra zone A": {
"color": "#e6e6e6",
"title": "Orchestra zone A",
"sortData": "Orchestra zone A",
"inResultset": true
},
"Orchestra zone B": {
"color": "#808080",
"title": "Orchestra zone B",
"sortData": "Orchestra zone B",
"inResultset": true
},
"Orchestra zone C": {
"color": "#000000",
"title": "Orchestra zone C",
"sortData": "Orchestra zone C",
"inResultset": true
},
"Orchestra zone D": {
"color": "#0e69c9",
"title": "Orchestra zone D",
"sortData": "Orchestra zone D",
"inResultset": true
},
"Orchestra zone F": {
"color": "#92d9f7",
"title": "Orchestra zone F",
"sortData": "Orchestra zone F"
},
"Orchestra zone G": {
"color": "#0eb0ab",
"title": "Orchestra zone G",
"sortData": "Orchestra zone G",
"inResultset": true
},
"Orchestra zone J": {
"color": "#53f222",
"title": "Orchestra zone J",
"sortData": "Orchestra zone J",
"inResultset": true
},
"Balcony zone N": {
"color": "#ff6752",
"title": "Balcony zone N",
"sortData": "Balcony zone N",
"inResultset": true
},
"Orchestra zone E": {
"color": "#44b2f2",
"title": "Orchestra zone E",
"sortData": "Orchestra zone E",
"inResultset": true
},
"Orchestra zone H": {
"color": "#12c77b",
"title": "Orchestra zone H",
"sortData": "Orchestra zone H",
"inResultset": true
},
"Balcony zone O": {
"color": "#eac1f5",
"title": "Balcony zone O",
"sortData": "Balcony zone O",
"inResultset": true
},
"White House Box": {
"color": "#3f3f3f",
"title": "White House Box",
"sortData": "White House Box",
"inResultset": true
},
"Box zone L": {
"color": "#cd7705",
"title": "Box zone L",
"sortData": "Box zone L",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Theater - 2023"
]
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-10-21T07:22:45"
},
"collapsed": true
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BCS: Kiss of the Spider Woman"
],
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BCS: Guys and Dolls",
"BCS: Bye Bye Birdie",
"BCS: Chess",
"BCS: Footloose",
"BCS: How to Succeed",
"BCS: In the Heights",
"BCS: Kiss of the Spider Woman",
"BCS: Little Shop of Horrors",
"BCS: Next to Normal",
"BCS: Sunset Boulevard\t\t\t\t\t\t\t\t\t",
"BCS: The Music Man",
"BCS: Tommy"
]
}
},
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
}
}
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "weeks",
"title": "Weeks in Date",
"firstday": "mon",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"1900-01-01T00:00:00"
]
},
"custom": true
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-01T07:16:43"
},
"collapsed": true
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
}
}
]
}
]
},
"oid": "63739c50d25ac60284e178d3",
"type": "chart/line",
"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": true
},
"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": "weeks",
"title": "weeks",
"singular": "weeks",
"plural": "weeks"
},
{
"id": "order_weeks_since_onsale",
"title": "Order Weeks Since OnSale",
"singular": "Order Weeks Since OnSale",
"plural": "Order Weeks Since OnSale"
},
{
"id": "zone",
"title": "Zone",
"singular": "Zone",
"plural": "Zone"
},
{
"id": "season",
"title": "Season",
"singular": "Season",
"plural": "Season"
},
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
}
]
}
},
"instanceid": "D7A28-33B6-85",
"queryStartTime": "2022-11-15T09:23:34",
"disableSelctor": false,
"widgetTimingLoged": true,
"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
},
"minDate": 1652328000000,
"maxDate": 1668661200000,
"tickInterval": 604800000,
"tickLevel": "week",
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "63739c50d25ac60284e178cf",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "6373a197d25ac60284e1796f",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "TKPANALYSIS01.kennedy-center.org/Seats and Tickets",
"id": "aTKPANALYSIS01LgAaKENNEDYLQAaCENTERLgAaORG_aSEATSIAAaANDIAAaTICKETS",
"address": "TKPANALYSIS01.kennedy-center.org",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-11-15T07:03:23"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"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": "Speed of Sales by Percentage of Zone Capacity
Notes: the charts below have the same value formulas, but the chart at right has an added code snippet (from forums) to connect broken lines and may paint an inaccurate picture of sales.
Shared by Gabrielle Frasco, Kennedy Center, 11.15.2022
Thread in forums",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "1A066-DDCB-49",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "63739c50d25ac60284e178cf",
"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": []
}