{ "title": "Seat Map Base Seats", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "62864ba99e964b359c7e084a", "height": "364px" } ], "width": 100, "stretchable": false, "pxlWidth": 821, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "628655349e964b359c7e0a67", "height": "364px" } ], "width": 100, "stretchable": false, "pxlWidth": 1232, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "40px", "defaultWidth": 128, "widgetid": "62864fe29e964b359c7e0998" } ], "width": 100, "stretchable": false, "pxlWidth": 1537, "index": 0 } ] } ], "pxlWidth": 1537, "index": 0 } ], "instanceid": "5615B-8C80-2D", "type": "columnar", "container": { "sizzle-1652969171605": { "parentNode": [ "490 24", 3 ] } } }, "original": null, "oid": "62864ba99e964b359c7e0847", "dataExploration": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" }, "filters": [ { "instanceid": "2D125-EDF2-BA", "isCascading": true, "levels": [ { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-05-19T01:22:17" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Broadway" ] }, "panel": "scope" }, { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-05-19T01:22:17" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2022" ] } } ], "model": { "instanceid": "B4B8F-5892-2E", "__store": [ "[SEASON.Season Type]", "[SEASON.Season Fiscal Year]" ] }, "disabled": false } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "parentFolder": null, "migrated": true, "isPublic": null, "widgets": [ { "title": "Seatmap Main Floor Front", "subtype": "bubble/scatter", "desc": null, "source": null, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CONSTITUENT.Constituent ID]" ], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "agg": "min", "title": "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": { "type": "measure", "formula": "min([CF54A-E69])", "context": { "[CF54A-E69]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" } }, "title": "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": "( [1A740-BCE] , [150C5-3ED] )", "context": { "[1A740-BCE]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "agg": "count", "title": "# of unique Package Seat Key" }, "[150C5-3ED]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } } }, "title": "Packages" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "steps": 0, "min": "#ffa62e", "max": "#a66104", "minvalue": null, "midvalue": null, "maxvalue": null, "minValueValid": true, "midValueValid": true, "maxValueValid": true, "type": "range", "rangeMode": "both" } } } ] }, { "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": [ "Main Floor Front" ] }, "collapsed": true, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "type": "chart/scatter", "oid": "62864ba99e964b359c7e084a", "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": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "markerSize": { "isRange": false, "min": 13, "max": 13, "lowest": 10, "highest": 60, "step": 1, "defaultSize": 13 }, "xAxis": { "enabled": false, "ticks": true, "labels": { "enabled": false, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "hideMinMax": false, "isIntervalEnabled": true, "logarithmic": false }, "yAxis": { "enabled": false, "ticks": true, "labels": { "enabled": false, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "hideMinMax": false, "isIntervalEnabled": true, "logarithmic": 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": "51A07-2103-23", "queryStartTime": "2022-05-20T09:41:39", "disableSelctor": false, "widgetTimingLoged": 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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "design" }, "continuousDates": false, "nullAsZero": false, "script": "widget.on('ready', function(se, ev){ \n // Parameters\n var seriesIndex = 0;\n \n // Figure out the min/max\n var x_min = null,\n x_max = null,\n y_min = null,\n y_max = null;\n $.each(se.queryResult.series[seriesIndex].data, function() {\n if (!x_min || x_min > this.x) {\n x_min = this.x;\n }\n if (!x_max || x_max < this.x) {\n x_max = this.x;\n }\n if (!y_min || y_min > this.y) {\n y_min = this.y;\n }\n if (!y_max || y_max < this.y) {\n y_max = this.y;\n }\n })\n \n // adjust based on the delta\n x_max = x_max + 1\n x_min = x_min - 1\n y_max = y_max + 1\n y_min = y_min - 1\n \n // Set the min/max on the chart\n var e = element;\n var chart = e.data('hc');\n chart.alignTicks =false;\n chart.xAxis[0].update({max: x_max, min: x_min}, true);\n chart.yAxis[0].update({max: y_max, min: y_min}, true);\n})", "canEditFilters": true, "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 80 }, "selectorLocked": false }, "dashboardid": "62864ba99e964b359c7e0847", "drawing": true, "chart": { "0": {}, "context": {}, "length": 1 } }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "oid": "62864fe29e964b359c7e0998", "desc": null, "source": null, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-05-19T01:22:17" }, "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": "Screen selection filter inside widget", "vAlign": "valign-middle", "bgColor": "#FFFFFF", "textAlign": "center" } }, "instanceid": "94399-2AD0-FC", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "dashboardid": "62864ba99e964b359c7e0847", "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": "Seatmap Main Floor Front", "subtype": "bubble/scatter", "oid": "628655349e964b359c7e0a67", "desc": null, "source": null, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CONSTITUENT.Constituent ID]" ], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "agg": "min", "title": "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": { "type": "measure", "formula": "min([CF54A-E69])", "context": { "[CF54A-E69]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" } }, "title": "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 (\n ISNULL( ( [469E4-640] , [F65B7-827] ) )\n , SUM(0)\n , ( [469E4-640] , [F65B7-827] )\n )", "context": { "[469E4-640]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "agg": "count", "title": "# of unique Package Seat Key" }, "[F65B7-827]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } } }, "title": "Packages" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "condition", "conditions": [ { "color": "#bfbfbf", "operator": "=", "expression": "0" }, { "color": "#b83d2d", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "( [A59C1-308] , [FBF28-208] , ALL([9DDBE-707]), ALL([35EF3-B0F]), ALL([78359-B6C]), ALL([B6699-AD4]) ) * 0.8", "context": { "[A59C1-308]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE.Package ID1]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[FBF28-208]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } }, "[98C4D-7D2]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode" }, "[78359-B6C]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" }, "[35EF3-B0F]": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "title": "Seat Map X" }, "[9DDBE-707]": { "table": "SEAT & TICKET DETAILS", "column": "Seat Key", "dim": "[SEAT & TICKET.Seat Key]", "datatype": "numeric", "title": "Seat Key" }, "[B6699-AD4]": { "table": "SEATING", "column": "Screen", "dim": "[SEATING.Screen]", "datatype": "text", "merged": true, "title": "Screen" } }, "title": "Formula" } } }, { "color": "#ff6752", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "( [7ECCD-85E] , [04E8C-69E] , ALL([84C55-534]), ALL([53837-EE5]), ALL([2446D-742]), ALL([12911-FA4]) ) * 0.6", "context": { "[7ECCD-85E]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE.Package ID1]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[04E8C-69E]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } }, "[2446D-742]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" }, "[53837-EE5]": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "title": "Seat Map X" }, "[84C55-534]": { "table": "SEAT & TICKET DETAILS", "column": "Seat Key", "dim": "[SEAT & TICKET.Seat Key]", "datatype": "numeric", "title": "Seat Key" }, "[12911-FA4]": { "table": "SEATING", "column": "Screen", "dim": "[SEATING.Screen]", "datatype": "text", "merged": true, "title": "Screen" } }, "title": "Formula" } } }, { "color": "#ffa62e", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "( [D534B-F33] , [6B27C-802] , ALL([45C01-2AE]), ALL([A3962-109]), ALL([23AC3-275]), ALL([180D6-B98]) ) * 0.4", "context": { "[D534B-F33]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE.Package ID1]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[6B27C-802]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } }, "[23AC3-275]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" }, "[A3962-109]": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "title": "Seat Map X" }, "[45C01-2AE]": { "table": "SEAT & TICKET DETAILS", "column": "Seat Key", "dim": "[SEAT & TICKET.Seat Key]", "datatype": "numeric", "title": "Seat Key" }, "[180D6-B98]": { "table": "SEATING", "column": "Screen", "dim": "[SEATING.Screen]", "datatype": "text", "merged": true, "title": "Screen" } }, "title": "Formula" } } }, { "color": "#124c87", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "( [DA68D-664] , [E383D-D86] , ALL([23BDE-0AE]), ALL([F99C8-C8B]), ALL([1F142-24F]), ALL([75FDD-437]) ) * 0.2", "context": { "[DA68D-664]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE.Package ID1]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[E383D-D86]": { "table": "PACKAGE DETAIL", "column": "Package Mode", "dim": "[PACKAGE.Package Mode1]", "datatype": "text", "merged": true, "title": "Package Mode", "filter": { "explicit": true, "multiSelection": true, "members": [ "Fixed Seat Package", "Sub Package" ] }, "collapsed": false, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } }, "[1F142-24F]": { "table": "SEATING", "column": "Seat Map Y", "dim": "[SEATING.Seat Map Y]", "datatype": "numeric", "title": "Seat Map Y" }, "[F99C8-C8B]": { "table": "SEATING", "column": "Seat Map X", "dim": "[SEATING.Seat Map X]", "datatype": "numeric", "title": "Seat Map X" }, "[23BDE-0AE]": { "table": "SEAT & TICKET DETAILS", "column": "Seat Key", "dim": "[SEAT & TICKET.Seat Key]", "datatype": "numeric", "title": "Seat Key" }, "[75FDD-437]": { "table": "SEATING", "column": "Screen", "dim": "[SEATING.Screen]", "datatype": "text", "merged": true, "title": "Screen" } }, "title": "Formula" } } }, { "color": "#6fa1c3", "operator": "≥", "expression": "0" } ] } } } ] }, { "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": [ "Main Floor Front" ] }, "collapsed": true, "datasource": { "title": "SDNA-Seats and Tickets", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "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": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "markerSize": { "isRange": false, "min": 13, "max": 13, "lowest": 10, "highest": 60, "step": 1, "defaultSize": 13 }, "xAxis": { "enabled": false, "ticks": true, "labels": { "enabled": false, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "hideMinMax": false, "isIntervalEnabled": true, "logarithmic": false }, "yAxis": { "enabled": false, "ticks": true, "labels": { "enabled": false, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "hideMinMax": false, "isIntervalEnabled": true, "logarithmic": 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": "51A07-2103-23", "queryStartTime": "2022-05-20T09:43:48", "disableSelctor": false, "widgetTimingLoged": 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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "design" }, "continuousDates": false, "nullAsZero": false, "script": "widget.on('ready', function(se, ev){ \n // Parameters\n var seriesIndex = 0;\n \n // Figure out the min/max\n var x_min = null,\n x_max = null,\n y_min = null,\n y_max = null;\n $.each(se.queryResult.series[seriesIndex].data, function() {\n if (!x_min || x_min > this.x) {\n x_min = this.x;\n }\n if (!x_max || x_max < this.x) {\n x_max = this.x;\n }\n if (!y_min || y_min > this.y) {\n y_min = this.y;\n }\n if (!y_max || y_max < this.y) {\n y_max = this.y;\n }\n })\n \n // adjust based on the delta\n x_max = x_max + 1\n x_min = x_min - 1\n y_max = y_max + 1\n y_min = y_min - 1\n \n // Set the min/max on the chart\n var e = element;\n var chart = e.data('hc');\n chart.alignTicks =false;\n chart.xAxis[0].update({max: x_max, min: x_min}, true);\n chart.yAxis[0].update({max: y_max, min: y_min}, true);\n})", "canEditFilters": true, "chart": { "0": {}, "context": {}, "length": 1 }, "dashboardid": "62864ba99e964b359c7e0847", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 80 }, "selectorLocked": false }, "drawing": true } ], "hierarchies": [] }