{
"title": "Sales Heat Map",
"oid": "5dc58900ca865e29a8f037a7",
"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": "A30B5-283B-2F",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "80px",
"defaultWidth": 128,
"widgetid": "5dd3082443c0052da8b34338"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1352,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dc58b0aca865e29a8f0384f",
"height": "512px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 676,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5de68c00fc951b1d5cac09be",
"height": "512px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 676,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": 128,
"defaultWidth": 128,
"widgetid": "5dcf0f6801b682287c4328dd"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 676,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dcedde8f703d81d98c1796f",
"height": "512px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 676,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5defc788074cd71fbc19f23f",
"height": "512px"
}
],
"width": 50
}
]
}
],
"pxlWidth": 1352,
"index": 0
}
],
"container": {}
},
"original": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
},
"editing": true,
"filters": [
{
"jaql": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-07T22:00:52"
},
"filter": {
"explicit": false,
"multiSelection": "true",
"all": true
}
},
"instanceid": "2D9A7-DFDC-3F",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type",
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-14T22:05:07"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Dance",
"Opera"
]
}
},
"instanceid": "50308-584B-57",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "SEATING",
"column": "Screen",
"dim": "[SEATING.Screen]",
"datatype": "text",
"merged": true,
"title": "Screen",
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-07T22:00:52"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Orchestra Front"
]
}
},
"instanceid": "E2FCF-2A7E-56",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-07T22:00:52"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Contribution",
"Parking",
"Revenue",
"Student Senior",
"Comp"
]
}
}
},
"instanceid": "FA581-EB4D-F8",
"isCascading": false,
"disabled": false,
"locked": true
}
],
"filterToDatasourceMapping": {},
"settings": {
"autoUpdateOnFiltersChange": true
},
"subscription": {
"isDataChange": true,
"type": "onUpdate",
"schedule": "* * * * * *",
"timezone": 360,
"tzName": "America/Chicago",
"context": {
"dashboardid": "5dc58900ca865e29a8f037a7"
},
"active": false,
"executionPerDay": 1,
"reportType": {
"inline": true
},
"emailSettings": {
"isEmail": true,
"isPdf": false
}
},
"isPublic": null,
"widgets": [
{
"title": "Heat Map by Sold Count",
"subtype": "bubble/scatter",
"oid": "5dc58b0aca865e29a8f0384f",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map X",
"dim": "[SEATING.Seat Map X]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map X"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "y-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map Y",
"dim": "[SEATING.Seat Map Y]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map Y"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "point",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
}
]
},
{
"name": "Break By / Color",
"items": [
{
"jaql": {
"type": "measure",
"formula": "IF([329F8-474]>0,([329F8-474]),-999999)",
"context": {
"[329F8-474]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
}
},
"title": "Sold Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "condition",
"conditions": [
{
"color": "#e6e6e6",
"operator": "=",
"expression": "-999999"
},
{
"color": "#ff0000",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([DA870-B09],[24A03-CF5]))*0.75",
"context": {
"[24A03-CF5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[DA870-B09]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "(max([Seat Key],[Total Ticket Count]))*0.75"
}
}
},
{
"color": "#ffab03",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([3C07C-72E],[AAFD9-DDC]))*0.5",
"context": {
"[AAFD9-DDC]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[3C07C-72E]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "(max([Seat Key],[Total Ticket Count]))*0.5"
}
}
},
{
"color": "#00a808",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([5805C-C80],[C5504-10C]))*0.25",
"context": {
"[C5504-10C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[5805C-C80]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "(max([Seat Key],[Total Ticket Count]))*0.25"
}
}
},
{
"color": "#124c87",
"operator": "<",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([5805C-C80],[C5504-10C]))*0.25",
"context": {
"[C5504-10C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"[5805C-C80]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "(max([Seat Key],[Total Ticket Count]))*0.25"
}
}
}
]
}
}
}
]
},
{
"name": "size",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Screen",
"dim": "[SEATING.Screen]",
"datatype": "text",
"merged": true,
"title": "Screen",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Orchestra Rear"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
}
},
"disabled": true
}
]
}
]
},
"type": "chart/scatter",
"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": false,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markerSize": {
"isRange": false,
"min": 10,
"max": 10,
"lowest": 10,
"highest": 60,
"step": 1,
"defaultSize": 10
},
"xAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"logarithmicOld": false,
"hideMinMax": false
},
"yAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"categoriesCapacityX": 500,
"categoriesCapacityY": 500,
"seriesCapacity": 50
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "seat_key",
"title": "Seat Key",
"singular": "Seat Key",
"plural": "Seat Key"
},
{
"id": "screen",
"title": "Screen",
"singular": "Screen",
"plural": "Screen"
}
]
}
},
"instanceid": "319EB-63D4-E2",
"queryStartTime": "2019-12-10T10:36:44",
"widgetTimingLoged": false,
"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
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"dashboardid": "5dc58900ca865e29a8f037a7",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 10,
"max": 80
},
"selectorLocked": false
},
"drawing": true
},
{
"title": "Heat Map by Average Days since Onsale",
"subtype": "bubble/scatter",
"oid": "5dcedde8f703d81d98c1796f",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map X",
"dim": "[SEATING.Seat Map X]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map X"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "y-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map Y",
"dim": "[SEATING.Seat Map Y]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map Y"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "point",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
}
]
},
{
"name": "Break By / Color",
"items": [
{
"jaql": {
"type": "measure",
"formula": "IF([54B3F-42A]>0,[54B3F-42A],-999999)",
"context": {
"[54B3F-42A]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Order Days Since OnSale"
},
"[D1BFB-EBD]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Order Days Since OnSale"
}
},
"title": "Average Days Since Onsale"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"number": {
"separated": true
}
},
"color": {
"type": "condition",
"conditions": [
{
"color": "#e6e6e6",
"operator": "=",
"expression": "-999999"
},
{
"color": "#124c87",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([57737-827],[C744D-34A]))*0.75",
"context": {
"[C744D-34A]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Order Days Since OnSale"
},
"[66CCB-8B2]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Order Days Since OnSale"
},
"[57737-827]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#00a808",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([3FDA7-6E2],[62975-35A]))*0.5",
"context": {
"[62975-35A]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Order Days Since OnSale"
},
"[62A24-8A5]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Order Days Since OnSale"
},
"[3FDA7-6E2]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#ffab03",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([4822A-989],[FE9DD-6B2]))*0.25",
"context": {
"[FE9DD-6B2]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Order Days Since OnSale"
},
"[670D6-CCB]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Order Days Since OnSale"
},
"[4822A-989]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#ff0000",
"operator": "<",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([0CF6F-C8A],[F12F6-972]))*0.25",
"context": {
"[F12F6-972]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Order Days Since OnSale"
},
"[56C7D-4A6]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Days Since OnSale",
"dim": "[SEAT & TICKET.Order Days Since OnSale]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Order Days Since OnSale"
},
"[0CF6F-C8A]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
}
]
}
}
}
]
},
{
"name": "size",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Screen",
"dim": "[SEATING.Screen]",
"datatype": "text",
"merged": true,
"title": "Screen",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Orchestra Rear"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
}
},
"disabled": true
}
]
}
]
},
"type": "chart/scatter",
"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": false,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markerSize": {
"isRange": false,
"min": 10,
"max": 10,
"lowest": 10,
"highest": 60,
"step": 1,
"defaultSize": 10
},
"xAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"logarithmicOld": false,
"hideMinMax": false
},
"yAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"categoriesCapacityX": 500,
"categoriesCapacityY": 500,
"seriesCapacity": 50
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "seat_key",
"title": "Seat Key",
"singular": "Seat Key",
"plural": "Seat Key"
},
{
"id": "screen",
"title": "Screen",
"singular": "Screen",
"plural": "Screen"
}
]
}
},
"instanceid": "319EB-63D4-E2",
"queryStartTime": "2019-12-10T10:41:17",
"widgetTimingLoged": true,
"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
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"viewState": {
"activeTab": "design"
},
"canEditFilters": true,
"dashboardid": "5dc58900ca865e29a8f037a7",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 10,
"max": 80
},
"selectorLocked": false
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5dcf0f6801b682287c4328dd",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-14T22:05:07"
},
"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": "Red = 75%
Yellow = 50%-69%
Green = 25%-49%
Blue = 0-24%
",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "56412-115F-1B",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5dc58900ca865e29a8f037a7",
"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": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5dd3082443c0052da8b34338",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-11-17T22:02:43"
},
"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": " Select the fiscal years you'd like to compile in \"Season Fiscal Year\".
Select the season type you'd like to view in \"Season Type\".
Select the section of the house you'd like to view in the \"Screen\".
",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "43F42-5F90-C6",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5dc58900ca865e29a8f037a7",
"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": "Heat Map by Average Paid Amount",
"subtype": "bubble/scatter",
"oid": "5de68c00fc951b1d5cac09be",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map X",
"dim": "[SEATING.Seat Map X]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map X"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "y-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map Y",
"dim": "[SEATING.Seat Map Y]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map Y"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "point",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
}
]
},
{
"name": "Break By / Color",
"items": [
{
"jaql": {
"type": "measure",
"formula": "IF([C929A-33B]>0,[C929A-33B],-999999)",
"context": {
"[C929A-33B]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Ticket Paid Amount"
},
"[818FC-D0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
}
},
"title": "Sold Amount"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"number": {
"separated": true
}
},
"color": {
"type": "condition",
"conditions": [
{
"color": "#e6e6e6",
"operator": "=",
"expression": "-999999"
},
{
"color": "#ff0000",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([1A85A-E7F],[55CBE-61F]))*0.75",
"context": {
"[55CBE-61F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Ticket Paid Amount"
},
"[1B644-555]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[1A85A-E7F]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#ffab03",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([EE470-C29],[D8253-8CD]))*0.5",
"context": {
"[D8253-8CD]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Ticket Paid Amount"
},
"[E9710-3CF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[EE470-C29]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#00a808",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([63712-E68],[B2C52-3B3]))*0.25",
"context": {
"[B2C52-3B3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Ticket Paid Amount"
},
"[70C47-524]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[63712-E68]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#124c87",
"operator": "<",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([03758-AA7],[B4E15-2BA]))*0.25",
"context": {
"[B4E15-2BA]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "avg",
"title": "Average Ticket Paid Amount"
},
"[59B87-786]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[03758-AA7]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
}
]
}
}
}
]
},
{
"name": "size",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Screen",
"dim": "[SEATING.Screen]",
"datatype": "text",
"merged": true,
"title": "Screen",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Orchestra Rear"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
}
},
"disabled": true
}
]
}
]
},
"type": "chart/scatter",
"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": false,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markerSize": {
"isRange": false,
"min": 10,
"max": 10,
"lowest": 10,
"highest": 60,
"step": 1,
"defaultSize": 10
},
"xAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"logarithmicOld": false,
"hideMinMax": false
},
"yAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"categoriesCapacityX": 500,
"categoriesCapacityY": 500,
"seriesCapacity": 50
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "seat_key",
"title": "Seat Key",
"singular": "Seat Key",
"plural": "Seat Key"
},
{
"id": "screen",
"title": "Screen",
"singular": "Screen",
"plural": "Screen"
}
]
}
},
"instanceid": "319EB-63D4-E2",
"queryStartTime": "2019-12-10T10:36:44",
"widgetTimingLoged": false,
"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
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"viewState": {
"activeTab": "design"
},
"canEditFilters": true,
"dashboardid": "5dc58900ca865e29a8f037a7",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 10,
"max": 80
},
"selectorLocked": false
},
"drawing": true
},
{
"title": "Heat Map by Total Paid Amount",
"subtype": "bubble/scatter",
"oid": "5defc788074cd71fbc19f23f",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map X",
"dim": "[SEATING.Seat Map X]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map X"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "y-axis",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Seat Map Y",
"dim": "[SEATING.Seat Map Y]",
"datatype": "numeric",
"agg": "min",
"title": "Min Seat Map Y"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "point",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
}
]
},
{
"name": "Break By / Color",
"items": [
{
"jaql": {
"type": "measure",
"formula": "IF([8671D-CA1]>0,[8671D-CA1],-999999)",
"context": {
"[8671D-CA1]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
}
},
"title": "Sold Amount"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"number": {
"separated": true
}
},
"color": {
"type": "condition",
"conditions": [
{
"color": "#e6e6e6",
"operator": "=",
"expression": "-999999"
},
{
"color": "#ff0000",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([2C37C-498],[243D2-776]))*0.75",
"context": {
"[243D2-776]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[2C37C-498]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#ffab03",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([F995C-496],[DB1B8-547]))*0.5",
"context": {
"[DB1B8-547]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[F995C-496]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "(max([Seat Key],[Total Ticket Paid Amount]))*0.5"
}
}
},
{
"color": "#00a808",
"operator": "≥",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([B5570-53F],[7F8A0-DE4]))*0.25",
"context": {
"[7F8A0-DE4]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[B5570-53F]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
},
{
"color": "#124c87",
"operator": "<",
"expression": {
"jaql": {
"type": "measure",
"formula": "(max([25E85-64D],[77AFB-743]))*0.25",
"context": {
"[77AFB-743]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[25E85-64D]": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Key",
"dim": "[SEAT & TICKET.Seat Key]",
"datatype": "numeric",
"title": "Seat Key"
}
},
"title": "Formula"
}
}
}
]
}
}
}
]
},
{
"name": "size",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEATING",
"column": "Screen",
"dim": "[SEATING.Screen]",
"datatype": "text",
"merged": true,
"title": "Screen",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Orchestra Rear"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets"
}
},
"disabled": true
}
]
}
]
},
"type": "chart/scatter",
"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": false,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markerSize": {
"isRange": false,
"min": 10,
"max": 10,
"lowest": 10,
"highest": 60,
"step": 1,
"defaultSize": 10
},
"xAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"logarithmicOld": false,
"hideMinMax": false
},
"yAxis": {
"enabled": false,
"ticks": true,
"labels": {
"enabled": false,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"categoriesCapacityX": 500,
"categoriesCapacityY": 500,
"seriesCapacity": 50
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "seat_key",
"title": "Seat Key",
"singular": "Seat Key",
"plural": "Seat Key"
},
{
"id": "screen",
"title": "Screen",
"singular": "Screen",
"plural": "Screen"
}
]
}
},
"instanceid": "319EB-63D4-E2",
"queryStartTime": "2019-12-10T10:36:44",
"widgetTimingLoged": false,
"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
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"viewState": {
"activeTab": "design"
},
"canEditFilters": true,
"dashboardid": "5dc58900ca865e29a8f037a7",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 10,
"max": 80
},
"selectorLocked": false
},
"drawing": true
}
],
"hierarchies": []
}