{ "title": "KB Sales Report", "desc": "", "source": "5d2c497b4f2bf92914fda4c6", "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "C732F-721A-9A", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 1028, "height": 352, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5dddaecf1efbd10d144abd57" } ], "width": 50, "stretchable": false, "pxlWidth": 512, "index": 0 }, { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5dddafd41efbd10d144abd5c", "height": 352 } ], "width": 50, "stretchable": false, "pxlWidth": 511, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dddb2181efbd10d144abd81", "height": "292px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "768px", "defaultWidth": 512, "widgetid": "5dd2f00e1f40761a7cf5e0fb" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd5b0b0f5ce6726145a84d6", "height": "600px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd57156f5ce6726145a8288", "height": "680px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd5b133f5ce6726145a84ea", "height": "1796px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd5735cf5ce6726145a82f5", "height": "824px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd574f1f5ce6726145a8331", "height": "1796px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd5b89df5ce6726145a8539", "height": "1796px" } ], "width": 100, "stretchable": false, "pxlWidth": 1023, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dd5756df5ce6726145a8340", "height": "1796px" } ], "width": 100, "stretchable": false, "pxlWidth": 1255, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5dea7f4bf3f5b01ecc40d754", "height": "1796px" } ], "width": 100, "stretchable": false, "pxlWidth": 1110, "index": 0 } ] } ], "pxlWidth": 1023, "index": 0 } ], "container": {} }, "original": null, "oid": "5dd2f00e1f40761a7cf5e0f3", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets" }, "editing": false, "parentFolder": null, "filters": [ { "isCascading": true, "disabled": false, "instanceid": "F4D08-BB0B-AF", "levels": [ { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "panel": "scope" }, { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "2020 Artisan", "2020 Education", "2020 Miscellaneous", "2020 Parking", "2020 Cross Product " ] } } } ], "model": { "instanceid": "E814E-3939-54", "__store": [ "[SEASON.Season Fiscal Year]", "[SEASON.Season]" ] } }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "filter": { "doesntEqual": "-999999" } }, "isCascading": false, "locked": true, "instanceid": "405F4-343C-7A" } ], "filterToDatasourceMapping": {}, "settings": { "autoUpdateOnFiltersChange": true }, "isPublic": null, "defaultFilters": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false }, { "isCascading": true, "disabled": false, "levels": [ { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "panel": "scope", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Pops" ] } }, { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "collapsed": true, "panel": "scope", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Music of Motown" ] } }, { "table": "PERFORMANCE DETAIL", "column": "Type", "dim": "[PERFORMANCE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "filter": { "explicit": false, "multiSelection": true, "all": true } } ], "model": { "instanceid": "FE1A0-06BA-06", "__store": [ "[SEASON.Season Type]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Type]" ] } }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "filter": { "doesntEqual": "-999999" } }, "isCascading": false, "locked": true }, { "jaql": { "datatype": "datetime", "dim": "[ORDER DATE.Date (Calendar)]", "title": "Years in Date", "level": "days", "column": "Date", "table": "ORDER DATE", "collapsed": true, "merged": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-08T01:40:20" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false }, { "jaql": { "datatype": "text", "dim": "[PERFORMANCE PRICING.Price Type Category]", "title": "Price Type Category", "column": "Price Type Category", "table": "PERFORMANCE PRICING", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false }, { "jaql": { "datatype": "text", "dim": "[ZONE.Zone]", "title": "Zone", "column": "Zone", "table": "ZONE", "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-20T01:45:00" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "isCascading": false, "disabled": false } ], "previewLayout": [], "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": 360, "tzName": "America/Chicago", "context": { "dashboardid": "5dd2f00e1f40761a7cf5e0f3" }, "active": true, "executionPerDay": 1, "reportType": { "inline": true, "pdf": { "includeTitle": true, "includeFilters": false, "includeDS": true, "elasticubeBuiltValue": "", "renderingInfo": { "paperFormat": "LEGAL", "paperOrientation": "landscape", "layout": "asis" } } }, "emailSettings": { "isEmail": true, "isPdf": true } }, "widgets": [ { "title": "June 21 - September 2019", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([3ABB9-E47])/([B695B-302])", "context": { "[3ABB9-E47]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[B695B-302]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([3ABB9-E47])/([B695B-302])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2019-06-20", "to": "2019-09-29" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "oid": "5dd2f00e1f40761a7cf5e0fb", "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-26T16:56:05", "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 }, "realTimeRefreshing": false, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "viewState": { "activeTab": "filters" }, "canEditFilters": true }, { "title": "November 2019", "subtype": "pivot", "oid": "5dd57156f5ce6726145a8288", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([AEC46-890])/([358D7-F0A])", "context": { "[AEC46-890]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[358D7-F0A]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([AEC46-890])/([358D7-F0A])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2019-11-01", "to": "2019-11-30" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:23: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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "January-February 2020", "subtype": "pivot", "oid": "5dd5735cf5ce6726145a82f5", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([BE1A5-5BC])/([2E8DB-649])", "context": { "[BE1A5-5BC]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[2E8DB-649]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([BE1A5-5BC])/([2E8DB-649])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-01-03", "to": "2020-02-29" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:31:55", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "March 2020", "subtype": "pivot", "oid": "5dd574f1f5ce6726145a8331", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 79 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 89 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([9EB3E-0FA])/([3CA17-016])", "context": { "[9EB3E-0FA]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[3CA17-016]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 83 }, "field": { "id": "([9EB3E-0FA])/([3CA17-016])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 95 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-03-01", "to": "2020-03-31" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:33:10", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "May 2020", "subtype": "pivot", "oid": "5dd5756df5ce6726145a8340", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([1F2C8-EC0])/([2B9AB-952])", "context": { "[1F2C8-EC0]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[2B9AB-952]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([1F2C8-EC0])/([2B9AB-952])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-05-01", "to": "2020-05-31" }, "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-12-06T10:18:58", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "October 2019", "subtype": "pivot", "oid": "5dd5b0b0f5ce6726145a84d6", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([C2192-5BA])/([501D0-0EA])", "context": { "[C2192-5BA]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[501D0-0EA]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([C2192-5BA])/([501D0-0EA])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2019-10-04", "to": "2019-10-31" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:22:10", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "December 2019", "subtype": "pivot", "oid": "5dd5b133f5ce6726145a84ea", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([27562-571])/([D2602-555])", "context": { "[27562-571]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[D2602-555]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([27562-571])/([D2602-555])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2019-12-01", "to": "2019-12-31" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:30:48", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "April 2020", "subtype": "pivot", "oid": "5dd5b89df5ce6726145a8539", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 79 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 89 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([FEFD0-864])/([A9F0F-7B2])", "context": { "[FEFD0-864]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[A9F0F-7B2]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 83 }, "field": { "id": "([FEFD0-864])/([A9F0F-7B2])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 95 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-04-01", "to": "2020-04-30" }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-25T14:34:09", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "2019-2020 Paid Revenue", "subtype": "indicator/gauge", "oid": "5dddaecf1efbd10d144abd57", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-11-25T23:40:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "color": "#547A94", "type": "color" } } } ] }, { "name": "secondary", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "min", "items": [ { "jaql": { "formula": "0", "title": "0 (default)" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "max", "items": [ { "jaql": { "type": "measure", "formula": "11885468", "context": {}, "title": "11885468" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } } } } ] }, { "name": "filters", "items": [] } ] }, "type": "indicator", "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": { "subtype": "round", "skin": "1", "components": { "ticks": { "inactive": false, "enabled": true }, "labels": { "inactive": false, "enabled": true }, "title": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } }, "narration": { "labels": [] } }, "instanceid": "1B52B-C6E3-BE", "queryStartTime": "2019-11-26T16:59:06", "drawing": true, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false } }, { "title": "2019-2020 Unpaid Revenue", "subtype": "indicator/numeric", "oid": "5dddafd41efbd10d144abd5c", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-11-25T23:40:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "sum([A712C-4E6])", "context": { "[A712C-4E6]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Unpaid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Unpaid Amount" } }, "title": "Ticket Unpaid Amount" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "color": "#547A94", "type": "color" } } } ] }, { "name": "secondary", "items": [ { "jaql": { "type": "measure", "formula": "sum([C355A-1A0])", "context": { "[C355A-1A0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Reserved Count", "dim": "[SEAT & TICKET VALUES.Ticket Reserved Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Reserved Count" } }, "title": "Total Ticket Reserved Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "min", "items": [ { "jaql": { "formula": "0", "title": "0 (default)" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "max", "items": [ { "jaql": { "type": "measure", "formula": "11885468", "context": {}, "title": "11885468" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } } } } ] }, { "name": "filters", "items": [] } ] }, "type": "indicator", "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": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } } }, "instanceid": "1B52B-C6E3-BE", "queryStartTime": "2019-11-26T17:10:13", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "drawing": true }, { "title": "June 1 - 16", "subtype": "pivot", "oid": "5dddb2181efbd10d144abd81", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": true }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 65 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 75 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 68 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 5 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 6 } }, { "jaql": { "type": "measure", "formula": "([1F2C8-EC0])/([2B9AB-952])", "context": { "[1F2C8-EC0]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[2B9AB-952]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([1F2C8-EC0])/([2B9AB-952])", "index": 7 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 89 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 8 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 9 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 10 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2019-06-01", "to": "2019-06-17" }, "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } }, { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" } } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "filter": { "explicit": true, "multiSelection": true, "members": [ "Firebird & Feathered Friends", "DSO Hardship Relief Concert", "Star Trek and Beyond" ] }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" }, { "id": "season_fiscal_year", "title": "Season Fiscal Year", "singular": "Season Fiscal Year", "plural": "Season Fiscal Year" }, { "id": "production", "title": "Production", "singular": "Production", "plural": "Production" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-11-26T17:19:37", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "June 2020", "subtype": "pivot", "oid": "5dea7f4bf3f5b01ecc40d754", "desc": null, "source": null, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "EEE, MMM d", "minutes": "HH:mm" } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "field": { "id": "[PERFORMANCE DETAIL.Code]", "index": 2 }, "format": { "width": 107 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Tix Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 74 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 3 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "title": "Comps", "agg": "sum" }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Attended" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 88 }, "field": { "id": "[SEAT & TICKET VALUES.Attended Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([1F2C8-EC0])/([2B9AB-952])", "context": { "[1F2C8-EC0]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" }, "[2B9AB-952]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "% Attended" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 106 }, "field": { "id": "([1F2C8-EC0])/([2B9AB-952])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Tix Rev $" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 7 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Rev Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[PERFORMANCE DETAIL.Budget Amount]_sum", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([9B6F3-97C])-([26A56-8A5])", "context": { "[9B6F3-97C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[26A56-8A5]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "min", "title": "Min Budget Amount" } }, "title": "Rev to Goal" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 98 }, "field": { "id": "([9B6F3-97C])-([26A56-8A5])", "index": 9 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "091320SP", "091420SP", "091520SP", "1004ADD-ON", "1005ADD-ON", "1105ADD-ON", "WICM LUNCH", "110620WC", "110720WC", "1108ADD-ON", "110820WC", "011020SP", "011120SP", "011220SP", "021420SP", "021520SP", "021620SP", "032020SP", "032120SP", "032220SP", "042420SP", "042520SP", "042620SP", "20COMPVOU" ] } }, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" }, "collapsed": true } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-06-01", "to": "2020-06-30" }, "collapsed": true, "datasource": { "title": "DSYM-Seats and Tickets", "fullname": "NASCUBEBP012.KRIOSTESS.local/DSYM-Seats and Tickets", "id": "aNASCUBEBP012LgAaKRIOSTESSLgAaLOCAL_aDSYMLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP012.KRIOSTESS.local", "database": "aDSYMLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-08-30T01:49:50" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "A8A2B-DB27-BF", "queryStartTime": "2019-12-06T10:22:31", "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5dd2f00e1f40761a7cf5e0f3", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true } ], "hierarchies": [] }