{ "title": "S2 Availability", "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": "C4162-7C82-AA", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": 128, "defaultWidth": 128, "widgetid": "5d07499dc85e3918f87a8e7c" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "128px", "defaultWidth": 512, "widgetid": "5d07499dc85e3918f87a8e7b" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "36px", "defaultWidth": 128, "widgetid": "5d7afda433f4cc11903b3a4c" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d0c8a2341b3881d68e17b6d", "height": "128px" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "72px", "defaultWidth": 128, "widgetid": "5d11d397e2a9371260fccd81" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "5d55e5b397d2ce1658125754" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "32px", "defaultWidth": 128, "widgetid": "5d07499dc85e3918f87a8e7a" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "452px", "defaultWidth": 512, "widgetid": "5d07499dc85e3918f87a8e7d" } ], "width": 100, "stretchable": false, "pxlWidth": 1439, "index": 0 } ] } ], "pxlWidth": 1439, "index": 0 } ], "container": { "sizzle-1568341343246": { "parentNode": [ "912 151", 7 ] } } }, "original": null, "oid": "5d07499dc85e3918f87a8e79", "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "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": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020" ], "filter": { "turnedOff": true, "exclude": { "members": [ "2020" ] } } } }, "instanceid": "6856D-3230-60", "isCascading": false, "disabled": false }, { "instanceid": "CD2C9-2572-8C", "isCascading": true, "disabled": false, "levels": [ { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "collapsed": true, "panel": "scope", "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Bonachela / Obarzanek" ] } }, { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance", "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Bonachela / Obarzanek" ] } } ], "model": { "instanceid": "9DD02-C52E-88", "__store": [ "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Performance]" ] } }, { "jaql": { "table": "SEATING", "column": "Screen", "dim": "[SEATING.Screen]", "datatype": "text", "merged": true, "title": "Section", "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "55C29-ADEA-B3", "isCascading": false, "disabled": false }, { "jaql": { "table": "ZONE", "column": "Zone Group", "dim": "[ZONE.Zone Group]", "datatype": "text", "merged": true, "title": "Zone Group", "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "AB9AD-1123-A9", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-18T01:14:12" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2019 Sydney" ] } }, "instanceid": "75FEC-CDFA-1B", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-18T01:14:12" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "(none)" ] } }, "instanceid": "D9003-F472-D2", "isCascading": false, "disabled": true } ], "filterToDatasourceMapping": {}, "parentFolder": "5cb68dd96350611884921440", "isPublic": null, "hierarchies": [], "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": -600, "tzName": "Australia/Sydney", "context": { "dashboardid": "5d07499dc85e3918f87a8e79" }, "active": false, "executionPerDay": 1, "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false } }, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "type": "richtexteditor", "oid": "5d07499dc85e3918f87a8e7a", "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": "Sales \"Heat map\" for sold seats


", "vAlign": "valign-middle", "bgColor": "#b7ab97", "textAlign": "center" } }, "instanceid": "0C87F-59EE-CE", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "dashboardid": "5d07499dc85e3918f87a8e79", "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": "More tha 80% sold", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 0 }, "format": { "width": 157 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Date and Code]", "index": 1 } }, { "jaql": { "table": "ZONE", "column": "Zone Group", "dim": "[ZONE.Zone Group]", "datatype": "text", "merged": true, "title": "Zone Group" }, "field": { "id": "[ZONE.Zone Group]", "index": 2 }, "disabled": false }, { "jaql": { "table": "SEATING", "column": "Section", "dim": "[SEATING.Section]", "datatype": "text", "merged": true, "title": "Section" }, "field": { "index": 3 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seats Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 99 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Capacity" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Seat Count]_sum", "index": 4 } }, { "jaql": { "type": "measure", "formula": "sum([75E26-1B2]-[C174F-2E9])", "context": { "[C174F-2E9]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[75E26-1B2]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" } }, "title": "Tickets Remaining" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([75E26-1B2]-[C174F-2E9])", "index": 5 } }, { "jaql": { "type": "measure", "formula": "sum([2B069-C1F] ) / ( [80E85-B13] , [A716E-BCD] )", "context": { "[2B069-C1F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[80E85-B13]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" }, "[A716E-BCD]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Percent sold", "sort": "asc", "sortDetails": { "field": 6, "dir": "asc", "sortingLastDimension": true, "initialized": true } }, "format": { "mask": { "decimals": 2, "percent": true }, "color": { "type": "condition", "conditions": [ { "color": "#ffa62e", "operator": "<", "expression": "0.9" }, { "color": "#ff6752", "operator": "≥", "expression": "0.9" } ] } }, "field": { "id": "sum([2B069-C1F] ) / ( [80E85-B13] , [A716E-BCD] )", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code", "filter": { "explicit": false, "multiSelection": true, "all": true }, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true } }, { "jaql": { "type": "measure", "formula": "sum([2B069-C1F] ) / ( [80E85-B13] , [A716E-BCD] )", "context": { "[2B069-C1F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[80E85-B13]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" }, "[A716E-BCD]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Percent sold", "sort": "asc", "sortDetails": { "field": 6, "dir": "asc", "sortingLastDimension": true, "initialized": true }, "filter": { "and": [ { "from": "0.8" }, { "to": ".99" } ] }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "type": "pivot", "oid": "5d07499dc85e3918f87a8e7b", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "performance_date_and_code", "title": "Performance Date and Code", "singular": "Performance Date and Code", "plural": "Performance Date and Code" }, { "id": "zone_group", "title": "Zone Group", "singular": "Zone Group", "plural": "Zone Group" }, { "id": "section", "title": "Section", "singular": "Section", "plural": "Section" } ] } }, "instanceid": "9A7DB-2F37-15", "queryStartTime": "2019-09-13T11:23:57", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "5d07499dc85e3918f87a8e79", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "type": "richtexteditor", "oid": "5d07499dc85e3918f87a8e7c", "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": "
This dashboard is set to look at percentages sold between 80% and 99.99%. Once a section hits the 80% threshold, it will stay in this report, until it goes over 99.99%. You can adjust Production or Production Season to look at different shows as well as fiscal year. You can also adjust Section or Zone Group to narrow down the data. There is also a section filter on the heat map so you can adjust that to a specific section if you'd like.

The Bar graph triggers an alert via email in pulse
", "vAlign": "valign-middle", "bgColor": "#8b8e09", "textAlign": "center" } }, "instanceid": "56F3A-D9CD-9D", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "dashboardid": "5d07499dc85e3918f87a8e79", "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 Section", "subtype": "bubble/scatter", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "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": [ "Stalls" ] }, "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "type": "chart/scatter", "oid": "5d07499dc85e3918f87a8e7d", "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-09-13T12:38:49", "widgetTimingLoged": false, "drawing": 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, "dashboardid": "5d07499dc85e3918f87a8e79", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 20, "max": 57.5 } }, "viewState": { "activeTab": "design" }, "canEditFilters": true }, { "title": "Barchart eg: for Pulse Alerts", "subtype": "bar/classic", "oid": "5d0c8a2341b3881d68e17b6d", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 0 }, "disabled": false }, { "jaql": { "table": "ZONE", "column": "Zone Group", "dim": "[ZONE.Zone Group]", "datatype": "text", "merged": true, "title": "Zone Group" }, "field": { "id": "[ZONE.Zone Group]", "index": 2 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "sum([C4907-DFF]/[4594F-398])", "context": { "[C4907-DFF]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[4594F-398]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" } }, "sortDetails": { "field": 3, "dir": "asc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "title": "Percent sold" }, "format": { "mask": { "decimals": 0, "percent": true, "percentMultiplier": 100 }, "color_bkp": { "type": "condition", "conditions": [ { "color": "#ffa62e", "operator": "<", "expression": "0.9" }, { "color": "#ff6752", "operator": "≥", "expression": "0.9" } ] } }, "field": { "id": "sum([C4907-DFF]/[4594F-398])", "index": 3 } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Date and Code]", "index": 1 }, "format": { "members": { "2019-11-09 Sat(E)-SS191109E": { "color": "#547A94", "title": "2019-11-09 Sat(E)-SS191109E", "sortData": "2019-11-09 Sat(E)-SS191109E" }, "2017-10-06 Fri(E)-2OA1006": { "color": "#F48E06", "title": "2017-10-06 Fri(E)-2OA1006", "sortData": "2017-10-06 Fri(E)-2OA1006" }, "2017-10-07 Sat(E)-2OA1007": { "color": "#DB4935", "title": "2017-10-07 Sat(E)-2OA1007", "sortData": "2017-10-07 Sat(E)-2OA1007" }, "2017-10-10 Tue(E)-2OA1010": { "color": "#333333", "title": "2017-10-10 Tue(E)-2OA1010", "sortData": "2017-10-10 Tue(E)-2OA1010" }, "2017-10-11 Wed(E)-2OA1011": { "color": "#008775", "title": "2017-10-11 Wed(E)-2OA1011", "sortData": "2017-10-11 Wed(E)-2OA1011" }, "2017-10-12 Thu(E)-2OA1012": { "color": "#618caa", "title": "2017-10-12 Thu(E)-2OA1012", "sortData": "2017-10-12 Thu(E)-2OA1012" }, "2017-10-13 Fri(M)-2OA1013S": { "color": "#ff9b16", "title": "2017-10-13 Fri(M)-2OA1013S", "sortData": "2017-10-13 Fri(M)-2OA1013S" }, "2017-10-14 Sat(E)-2OA1014": { "color": "#fc543d", "title": "2017-10-14 Sat(E)-2OA1014", "sortData": "2017-10-14 Sat(E)-2OA1014" }, "2017-10-13 Fri(E)-2OA1013": { "color": "#3b3b3b", "title": "2017-10-13 Fri(E)-2OA1013", "sortData": "2017-10-13 Fri(E)-2OA1013" }, "2012-03-12 Mon(M)-2OA120312S": { "color": "#009b87", "title": "2012-03-12 Mon(M)-2OA120312S", "sortData": "2012-03-12 Mon(M)-2OA120312S" }, "2018-05-22 Tue(E)-SS180522E": { "color": "#6897b7", "title": "2018-05-22 Tue(E)-SS180522E", "sortData": "2018-05-22 Tue(E)-SS180522E" }, "2018-05-23 Wed(E)-SS180523E": { "color": "#ffa022", "title": "2018-05-23 Wed(E)-SS180523E", "sortData": "2018-05-23 Wed(E)-SS180523E" }, "2018-05-24 Thu(E)-SS180524C": { "color": "#ff5d47", "title": "2018-05-24 Thu(E)-SS180524C", "sortData": "2018-05-24 Thu(E)-SS180524C" }, "2018-05-26 Sat(E)-SS180526E": { "color": "#3f3f3f", "title": "2018-05-26 Sat(E)-SS180526E", "sortData": "2018-05-26 Sat(E)-SS180526E" }, "2018-05-17 Thu(E)-SS180517C": { "color": "#00a790", "title": "2018-05-17 Thu(E)-SS180517C", "sortData": "2018-05-17 Thu(E)-SS180517C" }, "2018-05-18 Fri(E)-SS180518E": { "color": "#6fa1c3", "title": "2018-05-18 Fri(E)-SS180518E", "sortData": "2018-05-18 Fri(E)-SS180518E" }, "2018-05-19 Sat(E)-SS180519E": { "color": "#ffa62e", "title": "2018-05-19 Sat(E)-SS180519E", "sortData": "2018-05-19 Sat(E)-SS180519E" }, "2018-05-25 Fri(E)-SS180525E": { "color": "#ff6752", "title": "2018-05-25 Fri(E)-SS180525E", "sortData": "2018-05-25 Fri(E)-SS180525E" }, "2018-05-31 Thu(E)-MS180531C": { "color": "#434343", "title": "2018-05-31 Thu(E)-MS180531C", "sortData": "2018-05-31 Thu(E)-MS180531C" }, "2018-06-01 Fri(E)-MS180601E": { "color": "#00b29a", "title": "2018-06-01 Fri(E)-MS180601E", "sortData": "2018-06-01 Fri(E)-MS180601E" }, "2018-05-26 Sat(M)-SS180526M": { "color": "#74a9cd", "title": "2018-05-26 Sat(M)-SS180526M", "sortData": "2018-05-26 Sat(M)-SS180526M" }, "2018-06-02 Sat(M)-MS180602M": { "color": "#ffaa38", "title": "2018-06-02 Sat(M)-MS180602M", "sortData": "2018-06-02 Sat(M)-MS180602M" }, "2018-05-15 Tue(E)-SS180515O": { "color": "#ff6f5b", "title": "2018-05-15 Tue(E)-SS180515O", "sortData": "2018-05-15 Tue(E)-SS180515O" }, "2018-05-30 Wed(E)-MS180530": { "color": "#474747", "title": "2018-05-30 Wed(E)-MS180530", "sortData": "2018-05-30 Wed(E)-MS180530" }, "2018-05-22 Tue(M)-SS180522S": { "color": "#00bba2", "title": "2018-05-22 Tue(M)-SS180522S", "sortData": "2018-05-22 Tue(M)-SS180522S" }, "2019-05-08 Wed(E)-MS190508O": { "color": "#79afd5", "title": "2019-05-08 Wed(E)-MS190508O", "sortData": "2019-05-08 Wed(E)-MS190508O" }, "2019-05-11 Sat(E)-MS190511E": { "color": "#ffad3f", "title": "2019-05-11 Sat(E)-MS190511E", "sortData": "2019-05-11 Sat(E)-MS190511E" }, "2019-03-26 Tue(E)-SS190326P": { "color": "#ff7461", "title": "2019-03-26 Tue(E)-SS190326P", "sortData": "2019-03-26 Tue(E)-SS190326P" }, "2019-03-27 Wed(E)-SS190327O": { "color": "#494949", "title": "2019-03-27 Wed(E)-SS190327O", "sortData": "2019-03-27 Wed(E)-SS190327O" }, "2019-04-09 Tue(M)-SS190409S": { "color": "#00c2a8", "title": "2019-04-09 Tue(M)-SS190409S", "sortData": "2019-04-09 Tue(M)-SS190409S" }, "2019-03-28 Thu(E)-SS190328E": { "color": "#7cb4db", "title": "2019-03-28 Thu(E)-SS190328E", "sortData": "2019-03-28 Thu(E)-SS190328E" }, "2019-03-30 Sat(E)-SS190330E": { "color": "#ffaf45", "title": "2019-03-30 Sat(E)-SS190330E", "sortData": "2019-03-30 Sat(E)-SS190330E" }, "2019-04-02 Tue(M)-SS190402S": { "color": "#ff7966", "title": "2019-04-02 Tue(M)-SS190402S", "sortData": "2019-04-02 Tue(M)-SS190402S" }, "2019-04-04 Thu(E)-SS190404E": { "color": "#4b4b4b", "title": "2019-04-04 Thu(E)-SS190404E", "sortData": "2019-04-04 Thu(E)-SS190404E" }, "2019-04-13 Sat(E)-SS190413E": { "color": "#00c7ad", "title": "2019-04-13 Sat(E)-SS190413E", "sortData": "2019-04-13 Sat(E)-SS190413E" }, "2019-05-11 Sat(M)-MS190511M": { "color": "#7fb8df", "title": "2019-05-11 Sat(M)-MS190511M", "sortData": "2019-05-11 Sat(M)-MS190511M" }, "2016-05-25 Wed(E)-CMMEL0525": { "color": "#ffb14a", "title": "2016-05-25 Wed(E)-CMMEL0525", "sortData": "2016-05-25 Wed(E)-CMMEL0525" }, "2016-05-28 Sat(E)-CMMEL0528": { "color": "#ff7d6b", "title": "2016-05-28 Sat(E)-CMMEL0528", "sortData": "2016-05-28 Sat(E)-CMMEL0528" }, "2016-06-03 Fri(E)-CMMEL0603": { "color": "#4d4d4d", "title": "2016-06-03 Fri(E)-CMMEL0603", "sortData": "2016-06-03 Fri(E)-CMMEL0603" }, "2016-06-04 Sat(E)-CMMEL0604": { "color": "#00ccb1", "title": "2016-06-04 Sat(E)-CMMEL0604", "sortData": "2016-06-04 Sat(E)-CMMEL0604" }, "2016-03-03 Thu(M)-CMSYD0303S": { "color": "#81bce4", "title": "2016-03-03 Thu(M)-CMSYD0303S", "sortData": "2016-03-03 Thu(M)-CMSYD0303S" }, "2016-03-09 Wed(E)-CMSYD0309": { "color": "#ffb34e", "title": "2016-03-09 Wed(E)-CMSYD0309", "sortData": "2016-03-09 Wed(E)-CMSYD0309" }, "2016-03-10 Thu(E)-CMSYD0310": { "color": "#ff806f", "title": "2016-03-10 Thu(E)-CMSYD0310", "sortData": "2016-03-10 Thu(E)-CMSYD0310" }, "2016-03-11 Fri(E)-CMSYD0311": { "color": "#4e4e4e", "title": "2016-03-11 Fri(E)-CMSYD0311", "sortData": "2016-03-11 Fri(E)-CMSYD0311" }, "2016-03-12 Sat(E)-CMSYD0312": { "color": "#00d0b4", "title": "2016-03-12 Sat(E)-CMSYD0312", "sortData": "2016-03-12 Sat(E)-CMSYD0312" }, "2016-03-12 Sat(M)-CMSYD0312M": { "color": "#83bfe7", "title": "2016-03-12 Sat(M)-CMSYD0312M", "sortData": "2016-03-12 Sat(M)-CMSYD0312M" }, "2016-02-29 Mon(E)-CMSYD0229": { "color": "#ffb552", "title": "2016-02-29 Mon(E)-CMSYD0229", "sortData": "2016-02-29 Mon(E)-CMSYD0229" }, "2016-03-10 Thu(M)-CMSYD0310S": { "color": "#ff8372", "title": "2016-03-10 Thu(M)-CMSYD0310S", "sortData": "2016-03-10 Thu(M)-CMSYD0310S" }, "2016-02-26 Fri(E)-CMSYD0226": { "color": "#505050", "title": "2016-02-26 Fri(E)-CMSYD0226", "sortData": "2016-02-26 Fri(E)-CMSYD0226" }, "2016-02-27 Sat(E)-CMSYD0227": { "color": "#00d3b7", "title": "2016-02-27 Sat(E)-CMSYD0227", "sortData": "2016-02-27 Sat(E)-CMSYD0227" }, "2013-03-12 Tue(M)-DNO130312S": { "color": "#85c1eb", "title": "2013-03-12 Tue(M)-DNO130312S", "sortData": "2013-03-12 Tue(M)-DNO130312S" }, "2018-10-25 Thu(E)-SS181025C": { "color": "#ffb655", "title": "2018-10-25 Thu(E)-SS181025C", "sortData": "2018-10-25 Thu(E)-SS181025C" }, "2018-10-20 Sat(E)-SS181020E": { "color": "#ff8575", "title": "2018-10-20 Sat(E)-SS181020E", "sortData": "2018-10-20 Sat(E)-SS181020E" }, "2018-10-23 Tue(E)-SS181023E": { "color": "#515151", "title": "2018-10-23 Tue(E)-SS181023E", "sortData": "2018-10-23 Tue(E)-SS181023E" }, "2018-10-26 Fri(E)-SS181026E": { "color": "#00d6ba", "title": "2018-10-26 Fri(E)-SS181026E", "sortData": "2018-10-26 Fri(E)-SS181026E" }, "2018-10-27 Sat(E)-SS181027E": { "color": "#ffb655", "title": "2018-10-27 Sat(E)-SS181027E", "sortData": "2018-10-27 Sat(E)-SS181027E" }, "2018-10-27 Sat(M)-SS181027M": { "color": "#ff8575", "title": "2018-10-27 Sat(M)-SS181027M", "sortData": "2018-10-27 Sat(M)-SS181027M" }, "2018-10-17 Wed(E)-SS181017O": { "color": "#515151", "title": "2018-10-17 Wed(E)-SS181017O", "sortData": "2018-10-17 Wed(E)-SS181017O" }, "2018-10-16 Tue(E)-SS181016P": { "color": "#00d6ba", "title": "2018-10-16 Tue(E)-SS181016P", "sortData": "2018-10-16 Tue(E)-SS181016P" }, "2018-10-25 Thu(M)-SS181025S": { "color": "#85c1eb", "title": "2018-10-25 Thu(M)-SS181025S", "sortData": "2018-10-25 Thu(M)-SS181025S" }, "2018-10-23 Tue(M)-SS181023S": { "color": "#ffb655", "title": "2018-10-23 Tue(M)-SS181023S", "sortData": "2018-10-23 Tue(M)-SS181023S" }, "2015-03-19 Thu(E)-FOMSYD193E": { "color": "#ff8575", "title": "2015-03-19 Thu(E)-FOMSYD193E", "sortData": "2015-03-19 Thu(E)-FOMSYD193E" }, "2015-03-20 Fri(E)-FOMSYD203": { "color": "#515151", "title": "2015-03-20 Fri(E)-FOMSYD203", "sortData": "2015-03-20 Fri(E)-FOMSYD203" }, "2015-05-07 Thu(E)-FOMML0507": { "color": "#00d6ba", "title": "2015-05-07 Thu(E)-FOMML0507", "sortData": "2015-05-07 Thu(E)-FOMML0507" }, "2015-05-15 Fri(E)-FOMML0515": { "color": "#85c1eb", "title": "2015-05-15 Fri(E)-FOMML0515", "sortData": "2015-05-15 Fri(E)-FOMML0515" }, "2015-05-16 Sat(E)-FOMML0516": { "color": "#ffb655", "title": "2015-05-16 Sat(E)-FOMML0516", "sortData": "2015-05-16 Sat(E)-FOMML0516" }, "2015-03-11 Wed(M)-FOMSYD113S": { "color": "#ff8575", "title": "2015-03-11 Wed(M)-FOMSYD113S", "sortData": "2015-03-11 Wed(M)-FOMSYD113S" }, "2015-05-12 Tue(M)-FOMML0512": { "color": "#515151", "title": "2015-05-12 Tue(M)-FOMML0512", "sortData": "2015-05-12 Tue(M)-FOMML0512" }, "2015-10-25 Sun(E)-ILLMEL1025": { "color": "#00d6ba", "title": "2015-10-25 Sun(E)-ILLMEL1025", "sortData": "2015-10-25 Sun(E)-ILLMEL1025" }, "2011-10-25 Tue(M)-YES111025S": { "color": "#85c1eb", "title": "2011-10-25 Tue(M)-YES111025S", "sortData": "2011-10-25 Tue(M)-YES111025S" }, "2011-04-06 Wed(M)-LF110406S": { "color": "#ffb655", "title": "2011-04-06 Wed(M)-LF110406S", "sortData": "2011-04-06 Wed(M)-LF110406S" }, "2014-10-16 Thu(M)-LTW141016S": { "color": "#ff8575", "title": "2014-10-16 Thu(M)-LTW141016S", "sortData": "2014-10-16 Thu(M)-LTW141016S" }, "2015-12-08 Tue(E)-NBR151208": { "color": "#515151", "title": "2015-12-08 Tue(E)-NBR151208", "sortData": "2015-12-08 Tue(E)-NBR151208" }, "2015-12-09 Wed(E)-NBR151209": { "color": "#00d6ba", "title": "2015-12-09 Wed(E)-NBR151209", "sortData": "2015-12-09 Wed(E)-NBR151209" }, "2015-12-10 Thu(E)-NBR151210": { "color": "#85c1eb", "title": "2015-12-10 Thu(E)-NBR151210", "sortData": "2015-12-10 Thu(E)-NBR151210" }, "2015-12-13 Sun(M)-NBR151213": { "color": "#ffb655", "title": "2015-12-13 Sun(M)-NBR151213", "sortData": "2015-12-13 Sun(M)-NBR151213" }, "2016-11-29 Tue(E)-NB161129": { "color": "#ff8575", "title": "2016-11-29 Tue(E)-NB161129", "sortData": "2016-11-29 Tue(E)-NB161129" }, "2016-11-30 Wed(E)-NB161130": { "color": "#515151", "title": "2016-11-30 Wed(E)-NB161130", "sortData": "2016-11-30 Wed(E)-NB161130" }, "2016-12-01 Thu(E)-NB161201": { "color": "#00d6ba", "title": "2016-12-01 Thu(E)-NB161201", "sortData": "2016-12-01 Thu(E)-NB161201" }, "2016-12-02 Fri(E)-NB161202": { "color": "#85c1eb", "title": "2016-12-02 Fri(E)-NB161202", "sortData": "2016-12-02 Fri(E)-NB161202" }, "2016-12-03 Sat(E)-NB161203": { "color": "#ffb655", "title": "2016-12-03 Sat(E)-NB161203", "sortData": "2016-12-03 Sat(E)-NB161203" }, "2016-12-10 Sat(E)-NB161210": { "color": "#ff8575", "title": "2016-12-10 Sat(E)-NB161210", "sortData": "2016-12-10 Sat(E)-NB161210" }, "2017-12-01 Fri(E)-NB171201": { "color": "#515151", "title": "2017-12-01 Fri(E)-NB171201", "sortData": "2017-12-01 Fri(E)-NB171201" }, "2017-12-02 Sat(E)-NB171202": { "color": "#00d6ba", "title": "2017-12-02 Sat(E)-NB171202", "sortData": "2017-12-02 Sat(E)-NB171202" }, "2017-12-05 Tue(E)-NB171205": { "color": "#85c1eb", "title": "2017-12-05 Tue(E)-NB171205", "sortData": "2017-12-05 Tue(E)-NB171205" }, "2017-12-06 Wed(E)-NB171206": { "color": "#ffb655", "title": "2017-12-06 Wed(E)-NB171206", "sortData": "2017-12-06 Wed(E)-NB171206" }, "2017-12-07 Thu(E)-NB171207": { "color": "#ff8575", "title": "2017-12-07 Thu(E)-NB171207", "sortData": "2017-12-07 Thu(E)-NB171207" }, "2017-12-09 Sat(E)-NB171209": { "color": "#515151", "title": "2017-12-09 Sat(E)-NB171209", "sortData": "2017-12-09 Sat(E)-NB171209" }, "2017-12-09 Sat(M)-NB171209M": { "color": "#00d6ba", "title": "2017-12-09 Sat(M)-NB171209M", "sortData": "2017-12-09 Sat(M)-NB171209M" }, "2018-12-04 Tue(E)-NB181204E": { "color": "#85c1eb", "title": "2018-12-04 Tue(E)-NB181204E", "sortData": "2018-12-04 Tue(E)-NB181204E" }, "2018-12-06 Thu(E)-NB181206E": { "color": "#ffb655", "title": "2018-12-06 Thu(E)-NB181206E", "sortData": "2018-12-06 Thu(E)-NB181206E" }, "2018-12-07 Fri(E)-NB181207E": { "color": "#ff8575", "title": "2018-12-07 Fri(E)-NB181207E", "sortData": "2018-12-07 Fri(E)-NB181207E" }, "2017-05-20 Sat(E)-ORBMEL0520": { "color": "#515151", "title": "2017-05-20 Sat(E)-ORBMEL0520", "sortData": "2017-05-20 Sat(E)-ORBMEL0520" }, "2017-05-05 Fri(E)-ORB0505": { "color": "#00d6ba", "title": "2017-05-05 Fri(E)-ORB0505", "sortData": "2017-05-05 Fri(E)-ORB0505" }, "2017-05-06 Sat(E)-ORB0506": { "color": "#85c1eb", "title": "2017-05-06 Sat(E)-ORB0506", "sortData": "2017-05-06 Sat(E)-ORB0506" }, "2017-04-29 Sat(E)-ORB0429": { "color": "#ffb655", "title": "2017-04-29 Sat(E)-ORB0429", "sortData": "2017-04-29 Sat(E)-ORB0429" }, "2017-05-02 Tue(E)-ORB0502": { "color": "#ff8575", "title": "2017-05-02 Tue(E)-ORB0502", "sortData": "2017-05-02 Tue(E)-ORB0502" }, "2017-05-12 Fri(E)-ORB0512": { "color": "#515151", "title": "2017-05-12 Fri(E)-ORB0512", "sortData": "2017-05-12 Fri(E)-ORB0512" }, "2017-05-13 Sat(E)-ORB0513": { "color": "#00d6ba", "title": "2017-05-13 Sat(E)-ORB0513", "sortData": "2017-05-13 Sat(E)-ORB0513" }, "2017-05-13 Sat(M)-ORB0513M": { "color": "#85c1eb", "title": "2017-05-13 Sat(M)-ORB0513M", "sortData": "2017-05-13 Sat(M)-ORB0513M" }, "2017-05-19 Fri(M)-ORBMEL519M": { "color": "#ffb655", "title": "2017-05-19 Fri(M)-ORBMEL519M", "sortData": "2017-05-19 Fri(M)-ORBMEL519M" }, "2017-05-12 Fri(M)-ORB0512S": { "color": "#ff8575", "title": "2017-05-12 Fri(M)-ORB0512S", "sortData": "2017-05-12 Fri(M)-ORB0512S" }, "2016-12-06 Tue(E)-PPY161206": { "color": "#515151", "title": "2016-12-06 Tue(E)-PPY161206", "sortData": "2016-12-06 Tue(E)-PPY161206" }, "2018-12-13 Thu(E)-PPY181213E": { "color": "#00d6ba", "title": "2018-12-13 Thu(E)-PPY181213E", "sortData": "2018-12-13 Thu(E)-PPY181213E" }, "2015-09-25 Fri(E)-TRIPSYD259": { "color": "#85c1eb", "title": "2015-09-25 Fri(E)-TRIPSYD259", "sortData": "2015-09-25 Fri(E)-TRIPSYD259" }, "2015-09-26 Sat(E)-TRIPSYD269": { "color": "#ffb655", "title": "2015-09-26 Sat(E)-TRIPSYD269", "sortData": "2015-09-26 Sat(E)-TRIPSYD269" }, "2015-09-29 Tue(E)-TRIPSYD29": { "color": "#ff8575", "title": "2015-09-29 Tue(E)-TRIPSYD29", "sortData": "2015-09-29 Tue(E)-TRIPSYD29" }, "2015-10-10 Sat(E)-TRIPSYD10E": { "color": "#515151", "title": "2015-10-10 Sat(E)-TRIPSYD10E", "sortData": "2015-10-10 Sat(E)-TRIPSYD10E" }, "2016-10-18 Tue(E)-UTSYD1018": { "color": "#00d6ba", "title": "2016-10-18 Tue(E)-UTSYD1018", "sortData": "2016-10-18 Tue(E)-UTSYD1018" }, "2016-10-19 Wed(E)-UTSYD1019": { "color": "#85c1eb", "title": "2016-10-19 Wed(E)-UTSYD1019", "sortData": "2016-10-19 Wed(E)-UTSYD1019" }, "2016-10-22 Sat(E)-UTSYD1022": { "color": "#ffb655", "title": "2016-10-22 Sat(E)-UTSYD1022", "sortData": "2016-10-22 Sat(E)-UTSYD1022" }, "2016-10-26 Wed(E)-UTSYD1026": { "color": "#ff8575", "title": "2016-10-26 Wed(E)-UTSYD1026", "sortData": "2016-10-26 Wed(E)-UTSYD1026" }, "2016-10-25 Tue(M)-UTSYD1025S": { "color": "#515151", "title": "2016-10-25 Tue(M)-UTSYD1025S", "sortData": "2016-10-25 Tue(M)-UTSYD1025S" }, "2019-11-04 Mon(M)-SS191104S": { "color": "#515151", "title": "2019-11-04 Mon(M)-SS191104S", "sortData": "2019-11-04 Mon(M)-SS191104S", "inResultset": true }, "2019-11-01 Fri(E)-SS191101P": { "color": "#00d6ba", "title": "2019-11-01 Fri(E)-SS191101P", "sortData": "2019-11-01 Fri(E)-SS191101P" }, "2019-11-07 Thu(E)-SS191107E": { "color": "#85c1eb", "title": "2019-11-07 Thu(E)-SS191107E", "sortData": "2019-11-07 Thu(E)-SS191107E" } } } } ] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "sum([C4907-DFF]/[4594F-398])", "context": { "[C4907-DFF]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[4594F-398]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" } }, "title": "Percent sold", "filter": { "from": ".80", "to": ".99" }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-21T08:18:18" } }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } }, "title": "Percent sold" } ] } ] }, "type": "chart/bar", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "zone_group", "title": "Zone Group", "singular": "Zone Group", "plural": "Zone Group" }, { "id": "performance_date_and_code", "title": "Performance Date and Code", "singular": "Performance Date and Code", "plural": "Performance Date and Code" } ] } }, "instanceid": "07045-7F96-0A", "queryStartTime": "2019-09-13T12:39:03", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "canEditFilters": true, "dashboardid": "5d07499dc85e3918f87a8e79", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "drawing": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 } }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "oid": "5d11d397e2a9371260fccd81", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-25T00:34:58" }, "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": "Total Salable and amount remaining open.
NB/ Total Salable includes STC & TM seats but not Book, Dev, Corp, Companion Technical holds and other seats
Remaining Inv amount = Total Salable - Total Paid
Total Capacity of RPT is 845 (no upper boxes.  No AA BB Stalls)", "vAlign": "valign-middle", "bgColor": "#434343", "textAlign": "center" } }, "instanceid": "8DC49-3776-9F", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "dashboardid": "5d07499dc85e3918f87a8e79", "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": "Seats Sold and remaining", "subtype": "pivot", "oid": "5d55e5b397d2ce1658125754", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-22T00:30:51" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEATING.Seat Hold Code]" ], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "format": { "width": 201 }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Date and Code]", "index": 1 }, "format": { "subtotal": true } }, { "jaql": { "table": "ZONE", "column": "Zone Group", "dim": "[ZONE.Zone Group]", "datatype": "text", "merged": true, "title": "Zone Group" }, "field": { "id": "[ZONE.Zone Group]", "index": 2 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seats Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 99 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 3 } }, { "jaql": { "type": "measure", "formula": "(sum([5BBED-AB9]) , [EE8FC-FFA] )", "context": { "[EE8FC-FFA]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "[5BBED-AB9]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "title": "Seat Count" } }, "title": "Seat Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 87 }, "field": { "id": "(sum([5BBED-AB9]) , [EE8FC-FFA] )", "index": 4 } }, { "jaql": { "type": "measure", "formula": "( sum( [DF8C1-2ED] ), [C5060-244] ) - [FDE85-BA5] ", "context": { "[FDE85-BA5]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[DF8C1-2ED]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" }, "[0C329-2C1]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "[C5060-244]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Open Seats" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 71 }, "field": { "id": "( sum( [DF8C1-2ED] ), [C5060-244] ) - [FDE85-BA5] ", "index": 5 } }, { "jaql": { "type": "measure", "formula": "sum([E8243-8D5] ) / ( [8ECA6-D30] , [1440E-201] )", "context": { "[E8243-8D5]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[8ECA6-D30]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" }, "[0FEE0-F15]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "[1440E-201]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } }, "sort": null, "title": "Percent sold" }, "format": { "mask": { "decimals": 2, "percent": true }, "color": { "type": "condition", "conditions": [ { "color": "#ffffff", "operator": "<", "expression": "0.8" }, { "color": "#ffa62e", "operator": "<", "expression": "0.9" }, { "color": "#ff6752", "operator": "≥", "expression": "0.9" } ] }, "width": 83 }, "field": { "id": "sum([E8243-8D5] ) / ( [8ECA6-D30] , [1440E-201] )", "index": 6 } }, { "jaql": { "type": "measure", "formula": "(sum([5C687-7FF]) , [A1F63-26D] ) * [F0F41-960]", "context": { "[F0F41-960]": { "table": "SEAT & TICKET VALUES", "column": "Seat Current Base Value", "dim": "[SEAT & TICKET VALUES.Seat Current Base Value]", "datatype": "numeric", "agg": "max", "title": "Max Seat Current Base Value" }, "[92F98-BFA]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "[A1F63-26D]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } }, "[5C687-7FF]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "title": "Seat Count" } }, "sortDetails": { "field": 7, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc", "title": "Total Salable Revenue" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 111 }, "field": { "id": "(sum([5C687-7FF]) , [A1F63-26D] ) * [F0F41-960]", "index": 7 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Tkt Pd Amt" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 112 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "IF\t(\n[08677-38E] > 0 ,\n\n( [6F58C-F12] , [CD485-AC1] ) * [E9A81-7A5] / [08677-38E] , ( [2C5AE-F58] , [19C13-D62] )\n\n)", "context": { "[08677-38E]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid/Reserved Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid/Reserved Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid/Reserved Count" }, "[2C5AE-F58]": { "table": "SEAT & TICKET VALUES", "column": "Seat Current Base Value", "dim": "[SEAT & TICKET VALUES.Seat Current Base Value]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Current Base Value" }, "[E9A81-7A5]": { "table": "SEAT & TICKET VALUES", "column": "Seat Current Base Value", "dim": "[SEAT & TICKET VALUES.Seat Current Base Value]", "datatype": "numeric", "agg": "max", "title": "Max Seat Current Base Value" }, "[6F58C-F12]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" }, "[19C13-D62]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-22T00:30:51" } }, "[CD485-AC1]": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Salable Hold", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Artistic", "Book", "Companion", "Corporate Holds", "Development", "House", "Not Available", "Technical" ] } }, "collapsed": false, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Remaining Inv" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 98, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF\t(\n[08677-38E] > 0 ,\n\n( [6F58C-F12] , [CD485-AC1] ) * [E9A81-7A5] / [08677-38E] , ( [2C5AE-F58] , [19C13-D62] )\n\n)", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "sum([C4907-DFF]/[4594F-398])", "context": { "[C4907-DFF]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[4594F-398]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" } }, "title": "Percent sold", "filter": { "from": ".80", "to": ".99" }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-21T08:18:18" } }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "title": "Percent sold", "disabled": true }, { "jaql": { "table": "SEATING", "column": "Seat Hold Code", "dim": "[SEATING.Seat Hold Code]", "datatype": "text", "merged": true, "title": "Seat Hold Code", "filter": { "explicit": true, "multiSelection": true, "members": [ "(none)", "Box Office", "Education", "Group", "Ticketmaster", "Venue Holds 1", "Venue Holds 2", "Venue Holds 3", "Wheelchair", "Wheelchair - Venue", "Not Available" ] }, "collapsed": true, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": "50", "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "performance_date_and_code", "title": "Performance Date and Code", "singular": "Performance Date and Code", "plural": "Performance Date and Code" }, { "id": "zone_group", "title": "Zone Group", "singular": "Zone Group", "plural": "Zone Group" }, { "id": "seat_hold_code", "title": "Seat Hold Code", "singular": "Seat Hold Code", "plural": "Seat Hold Code" } ] }, "rowsGrandTotal": true }, "instanceid": "9A7DB-2F37-15", "queryStartTime": "2019-09-13T12:56:28", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "canEditFilters": true, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "dashboardid": "5d07499dc85e3918f87a8e79", "drawing": true, "currentPage": 1 }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "oid": "5d7afda433f4cc11903b3a4c", "desc": null, "source": null, "datasource": { "title": "SYDN-Seats and Tickets", "fullname": "APKCUBEBP002.APRAMP.local/SYDN-Seats and Tickets", "id": "aAPKCUBEBP002LgAaAPRAMPLgAaLOCAL_aSYDNLQAaSEATSIAAaANDIAAaTICKETS", "address": "APKCUBEBP002.APRAMP.local", "database": "aSYDNLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-09-13T00:31:02" }, "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": "Just a quick Barchart example that can be used for Pulse alerts
https://www.tessituranetwork.com/Tessitura_Analytics/Tessitura_Analytics.htm#Pulse/Data%20Alerts.htm%3FTocPath%3DPulse%7CAlerts%7C_____1
", "vAlign": "valign-middle", "bgColor": "#434343", "textAlign": "center" } }, "instanceid": "4B393-0918-1B", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "dashboardid": "5d07499dc85e3918f87a8e79", "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" } } ] }