{ "title": "Analytic Coffee Example", "oid": "5f5badeb6cab4f101c734c00", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "7ABF8-9014-60", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "5f5baf8f6cab4f101c734c2b" } ], "width": 50, "stretchable": false, "pxlWidth": 684, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f5baf936cab4f101c734c2f", "height": 384 } ], "width": 50 } ] } ], "pxlWidth": 100, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "MIOP-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aMIOPLQAaSeatsIAAaandIAAaTickets" }, "editing": true, "widgets": [ { "title": "", "subtype": "column/stackedcolumn", "oid": "5f5baf8f6cab4f101c734c2b", "desc": null, "source": null, "datasource": { "title": "MIOP-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aMIOPLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-09-10T22:07:26" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season" }, "field": { "id": "[SEASON.Season]", "index": 0 }, "format": { "members": { "16 Dummy Test Rollover": { "color": "#547A94", "title": "16 Dummy Test Rollover", "sortData": "16 Dummy Test Rollover" }, "2010/2011 Cafe": { "color": "#F48E06", "title": "2010/2011 Cafe", "sortData": "2010/2011 Cafe" }, "2010/2011 Dance": { "color": "#DB4935", "title": "2010/2011 Dance", "sortData": "2010/2011 Dance" }, "2010/2011 LATOH": { "color": "#333333", "title": "2010/2011 LATOH", "sortData": "2010/2011 LATOH" }, "2010/2011 Misc": { "color": "#008775", "title": "2010/2011 Misc", "sortData": "2010/2011 Misc" }, "2010/2011 Opera": { "color": "#618caa", "title": "2010/2011 Opera", "sortData": "2010/2011 Opera", "inResultset": true }, "2010/2011 Other": { "color": "#ff9b16", "title": "2010/2011 Other", "sortData": "2010/2011 Other" }, "2010/2011 Parking": { "color": "#fc543d", "title": "2010/2011 Parking", "sortData": "2010/2011 Parking" }, "2010/2011 Student/Senior": { "color": "#3b3b3b", "title": "2010/2011 Student/Senior", "sortData": "2010/2011 Student/Senior" }, "2011/2012 Cafe": { "color": "#009b87", "title": "2011/2012 Cafe", "sortData": "2011/2012 Cafe" }, "2011/2012 Dance": { "color": "#6897b7", "title": "2011/2012 Dance", "sortData": "2011/2012 Dance" }, "2011/2012 Misc": { "color": "#ffa022", "title": "2011/2012 Misc", "sortData": "2011/2012 Misc" }, "2011/2012 Opera": { "color": "#ff5d47", "title": "2011/2012 Opera", "sortData": "2011/2012 Opera", "inResultset": true }, "2011/2012 Other": { "color": "#3f3f3f", "title": "2011/2012 Other", "sortData": "2011/2012 Other" }, "2011/2012 Parking": { "color": "#00a790", "title": "2011/2012 Parking", "sortData": "2011/2012 Parking" }, "2011/2012 Student/Senior": { "color": "#6fa1c3", "title": "2011/2012 Student/Senior", "sortData": "2011/2012 Student/Senior" }, "2012/2013 Cafe": { "color": "#ffa62e", "title": "2012/2013 Cafe", "sortData": "2012/2013 Cafe" }, "2012/2013 Dance": { "color": "#ff6752", "title": "2012/2013 Dance", "sortData": "2012/2013 Dance" }, "2012/2013 LATOH": { "color": "#434343", "title": "2012/2013 LATOH", "sortData": "2012/2013 LATOH" }, "2012/2013 Misc": { "color": "#00b29a", "title": "2012/2013 Misc", "sortData": "2012/2013 Misc" }, "2012/2013 Opera": { "color": "#74a9cd", "title": "2012/2013 Opera", "sortData": "2012/2013 Opera", "inResultset": true }, "2012/2013 Other": { "color": "#ffaa38", "title": "2012/2013 Other", "sortData": "2012/2013 Other" }, "2012/2013 Parking": { "color": "#ff6f5b", "title": "2012/2013 Parking", "sortData": "2012/2013 Parking" }, "2012/2013 Student/Senior": { "color": "#474747", "title": "2012/2013 Student/Senior", "sortData": "2012/2013 Student/Senior" }, "2013/2014 Cafe": { "color": "#00bba2", "title": "2013/2014 Cafe", "sortData": "2013/2014 Cafe" }, "2013/2014 Dance": { "color": "#79afd5", "title": "2013/2014 Dance", "sortData": "2013/2014 Dance" }, "2013/2014 Latoh": { "color": "#ffad3f", "title": "2013/2014 Latoh", "sortData": "2013/2014 Latoh" }, "2013/2014 Misc": { "color": "#ff7461", "title": "2013/2014 Misc", "sortData": "2013/2014 Misc" }, "2013/2014 Opera": { "color": "#494949", "title": "2013/2014 Opera", "sortData": "2013/2014 Opera", "inResultset": true }, "2013/2014 Other": { "color": "#00c2a8", "title": "2013/2014 Other", "sortData": "2013/2014 Other" }, "2013/2014 Parking": { "color": "#7cb4db", "title": "2013/2014 Parking", "sortData": "2013/2014 Parking" }, "2013/2014 Student/Senior": { "color": "#ffaf45", "title": "2013/2014 Student/Senior", "sortData": "2013/2014 Student/Senior" }, "2014/2015 Dance": { "color": "#ff7966", "title": "2014/2015 Dance", "sortData": "2014/2015 Dance" }, "2014/2015 LATOH": { "color": "#4b4b4b", "title": "2014/2015 LATOH", "sortData": "2014/2015 LATOH" }, "2014/2015 Miscellaneous": { "color": "#00c7ad", "title": "2014/2015 Miscellaneous", "sortData": "2014/2015 Miscellaneous" }, "2014/2015 Opera": { "color": "#7fb8df", "title": "2014/2015 Opera", "sortData": "2014/2015 Opera", "inResultset": true }, "2014/2015 Other": { "color": "#ffb14a", "title": "2014/2015 Other", "sortData": "2014/2015 Other" }, "2014/2015 Parking": { "color": "#ff7d6b", "title": "2014/2015 Parking", "sortData": "2014/2015 Parking" }, "2014/2015 Student/Senior": { "color": "#4d4d4d", "title": "2014/2015 Student/Senior", "sortData": "2014/2015 Student/Senior" }, "2015/2016 Dance": { "color": "#00ccb1", "title": "2015/2016 Dance", "sortData": "2015/2016 Dance" }, "2015/2016 LATOH": { "color": "#81bce4", "title": "2015/2016 LATOH", "sortData": "2015/2016 LATOH" }, "2015/2016 Miscellaneous": { "color": "#ffb34e", "title": "2015/2016 Miscellaneous", "sortData": "2015/2016 Miscellaneous" }, "2015/2016 Opera": { "color": "#ff806f", "title": "2015/2016 Opera", "sortData": "2015/2016 Opera", "inResultset": true }, "2015/2016 Other": { "color": "#4e4e4e", "title": "2015/2016 Other", "sortData": "2015/2016 Other" }, "2015/2016 Parking": { "color": "#00d0b4", "title": "2015/2016 Parking", "sortData": "2015/2016 Parking" }, "2016/2017 Dance": { "color": "#83bfe7", "title": "2016/2017 Dance", "sortData": "2016/2017 Dance" }, "2016/2017 LATOH": { "color": "#ffb552", "title": "2016/2017 LATOH", "sortData": "2016/2017 LATOH" }, "2016/2017 Miscellaneous": { "color": "#ff8372", "title": "2016/2017 Miscellaneous", "sortData": "2016/2017 Miscellaneous" }, "2016/2017 Opera": { "color": "#505050", "title": "2016/2017 Opera", "sortData": "2016/2017 Opera", "inResultset": true }, "2016/2017 Other": { "color": "#00d3b7", "title": "2016/2017 Other", "sortData": "2016/2017 Other" }, "2016/2017 Parking": { "color": "#85c1eb", "title": "2016/2017 Parking", "sortData": "2016/2017 Parking" }, "2016/2017 Student Senior": { "color": "#ffb655", "title": "2016/2017 Student Senior", "sortData": "2016/2017 Student Senior" }, "2017/2018 Dance": { "color": "#ff8575", "title": "2017/2018 Dance", "sortData": "2017/2018 Dance" }, "2017/2018 LATOH": { "color": "#515151", "title": "2017/2018 LATOH", "sortData": "2017/2018 LATOH" }, "2017/2018 Miscellaneous": { "color": "#00d6ba", "title": "2017/2018 Miscellaneous", "sortData": "2017/2018 Miscellaneous" }, "2017/2018 Opera": { "color": "#ffb655", "title": "2017/2018 Opera", "sortData": "2017/2018 Opera", "inResultset": true }, "2017/2018 Other": { "color": "#ff8575", "title": "2017/2018 Other", "sortData": "2017/2018 Other" }, "2017/2018 Parking": { "color": "#515151", "title": "2017/2018 Parking", "sortData": "2017/2018 Parking" }, "2017/2018 Student Senior": { "color": "#00d6ba", "title": "2017/2018 Student Senior", "sortData": "2017/2018 Student Senior" }, "2018/2019 Dance": { "color": "#85c1eb", "title": "2018/2019 Dance", "sortData": "2018/2019 Dance" }, "2018/2019 LATOH": { "color": "#ffb655", "title": "2018/2019 LATOH", "sortData": "2018/2019 LATOH" }, "2018/2019 Miscellaneous": { "color": "#ff8575", "title": "2018/2019 Miscellaneous", "sortData": "2018/2019 Miscellaneous" }, "2018/2019 Opera": { "color": "#515151", "title": "2018/2019 Opera", "sortData": "2018/2019 Opera", "inResultset": true }, "2018/2019 Other": { "color": "#00d6ba", "title": "2018/2019 Other", "sortData": "2018/2019 Other" }, "2018/2019 Parking": { "color": "#85c1eb", "title": "2018/2019 Parking", "sortData": "2018/2019 Parking" }, "2018/2019 Student Senior": { "color": "#ffb655", "title": "2018/2019 Student Senior", "sortData": "2018/2019 Student Senior" }, "2019/2020 Dance": { "color": "#ff8575", "title": "2019/2020 Dance", "sortData": "2019/2020 Dance" }, "2019/2020 Miscellaneous": { "color": "#515151", "title": "2019/2020 Miscellaneous", "sortData": "2019/2020 Miscellaneous" }, "2019/2020 Opera": { "color": "#00d6ba", "title": "2019/2020 Opera", "sortData": "2019/2020 Opera", "inResultset": true }, "2019/2020 Other": { "color": "#85c1eb", "title": "2019/2020 Other", "sortData": "2019/2020 Other" }, "2019/2020 Parking": { "color": "#ffb655", "title": "2019/2020 Parking", "sortData": "2019/2020 Parking" }, "2019/2020 Student Senior": { "color": "#ff8575", "title": "2019/2020 Student Senior", "sortData": "2019/2020 Student Senior" }, "2020/2021 LATOH": { "color": "#515151", "title": "2020/2021 LATOH", "sortData": "2020/2021 LATOH" }, "2020/2021 Miscellaneous": { "color": "#00d6ba", "title": "2020/2021 Miscellaneous", "sortData": "2020/2021 Miscellaneous" }, "2020/2021 Opera": { "color": "#85c1eb", "title": "2020/2021 Opera", "sortData": "2020/2021 Opera", "inResultset": true }, "2020/2021 Parking": { "color": "#ffb655", "title": "2020/2021 Parking", "sortData": "2020/2021 Parking" } } } } ] }, { "name": "values", "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": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 2 } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "ORDER DETAILS", "column": "Channel", "dim": "[ORDER DETAILS.Channel]", "datatype": "text", "merged": true, "title": "Channel" }, "format": { "members": { "(none)": { "color": "#547A94", "title": "(none)", "sortData": "(none)", "inResultset": true }, "Default Channel": { "color": "#F48E06", "title": "Default Channel", "sortData": "Default Channel", "inResultset": true }, "Phone": { "color": "#DB4935", "title": "Phone", "sortData": "Phone", "inResultset": true }, "Website": { "color": "#333333", "title": "Website", "sortData": "Website", "inResultset": true }, "Mail": { "color": "#008775", "title": "Mail", "sortData": "Mail", "inResultset": true }, "E-mail": { "color": "#618caa", "title": "E-mail", "sortData": "E-mail", "inResultset": true }, "In Person": { "color": "#ff9b16", "title": "In Person", "sortData": "In Person", "inResultset": true }, "Fax": { "color": "#fc543d", "title": "Fax", "sortData": "Fax", "inResultset": true }, "Telemarketing": { "color": "#3b3b3b", "title": "Telemarketing", "sortData": "Telemarketing", "inResultset": true }, "OC Group Sales": { "color": "#009b87", "title": "OC Group Sales", "sortData": "OC Group Sales", "inResultset": true }, "1 Trg Mailing": { "color": "#6897b7", "title": "1 Trg Mailing", "sortData": "1 Trg Mailing", "inResultset": true }, "Board Comps": { "color": "#ffa022", "title": "Board Comps", "sortData": "Board Comps", "inResultset": true }, "MA Frida Mailed": { "color": "#ff5d47", "title": "MA Frida Mailed", "sortData": "MA Frida Mailed", "inResultset": true }, "Nutty Parents": { "color": "#3f3f3f", "title": "Nutty Parents", "sortData": "Nutty Parents" }, "BE Will Call": { "color": "#00a790", "title": "BE Will Call", "sortData": "BE Will Call", "inResultset": true }, "DIA Will Call": { "color": "#6fa1c3", "title": "DIA Will Call", "sortData": "DIA Will Call", "inResultset": true }, "Ma Will Call": { "color": "#ffa62e", "title": "Ma Will Call", "sortData": "Ma Will Call", "inResultset": true }, "50/50 Payment": { "color": "#ff6752", "title": "50/50 Payment", "sortData": "50/50 Payment", "inResultset": true }, "Extension": { "color": "#434343", "title": "Extension", "sortData": "Extension", "inResultset": true }, "TRBO": { "color": "#00b29a", "title": "TRBO", "sortData": "TRBO", "inResultset": true }, "UMS": { "color": "#74a9cd", "title": "UMS", "sortData": "UMS" }, "Groupmatics": { "color": "#ffaa38", "title": "Groupmatics", "sortData": "Groupmatics", "inResultset": true } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "filter": { "contains": "opera" }, "collapsed": true, "datasource": { "title": "MIOP-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aMIOPLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-09-10T22:07:26" } }, "title": "Season" } ] } ] }, "type": "chart/column", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": true, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "hideMinMax": false, "isIntervalEnabled": true }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "hideMinMax": false, "isIntervalEnabled": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "channel", "title": "Channel", "singular": "Channel", "plural": "Channel" } ] } }, "instanceid": "385AF-496A-8A", "queryStartTime": "2020-09-11T12:08:00", "drawing": true, "canEditFilters": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "dashboardid": "5f5badeb6cab4f101c734c00", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } } }, { "title": "", "subtype": "pivot", "oid": "5f5baf936cab4f101c734c2f", "desc": null, "source": null, "datasource": { "title": "MIOP-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aMIOPLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-09-10T22:07:26" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "sortDetails": { "field": 0, "dir": "desc", "sortingLastDimension": false, "measurePath": null, "initialized": true }, "sort": "desc" }, "field": { "id": "[SEASON.Season]", "index": 0 }, "format": { "members": { "16 Dummy Test Rollover": { "color": "#547A94", "title": "16 Dummy Test Rollover", "sortData": "16 Dummy Test Rollover" }, "2010/2011 Cafe": { "color": "#F48E06", "title": "2010/2011 Cafe", "sortData": "2010/2011 Cafe" }, "2010/2011 Dance": { "color": "#DB4935", "title": "2010/2011 Dance", "sortData": "2010/2011 Dance" }, "2010/2011 LATOH": { "color": "#333333", "title": "2010/2011 LATOH", "sortData": "2010/2011 LATOH" }, "2010/2011 Misc": { "color": "#008775", "title": "2010/2011 Misc", "sortData": "2010/2011 Misc" }, "2010/2011 Opera": { "color": "#618caa", "title": "2010/2011 Opera", "sortData": "2010/2011 Opera", "inResultset": true }, "2010/2011 Other": { "color": "#ff9b16", "title": "2010/2011 Other", "sortData": "2010/2011 Other" }, "2010/2011 Parking": { "color": "#fc543d", "title": "2010/2011 Parking", "sortData": "2010/2011 Parking" }, "2010/2011 Student/Senior": { "color": "#3b3b3b", "title": "2010/2011 Student/Senior", "sortData": "2010/2011 Student/Senior" }, "2011/2012 Cafe": { "color": "#009b87", "title": "2011/2012 Cafe", "sortData": "2011/2012 Cafe" }, "2011/2012 Dance": { "color": "#6897b7", "title": "2011/2012 Dance", "sortData": "2011/2012 Dance" }, "2011/2012 Misc": { "color": "#ffa022", "title": "2011/2012 Misc", "sortData": "2011/2012 Misc" }, "2011/2012 Opera": { "color": "#ff5d47", "title": "2011/2012 Opera", "sortData": "2011/2012 Opera", "inResultset": true }, "2011/2012 Other": { "color": "#3f3f3f", "title": "2011/2012 Other", "sortData": "2011/2012 Other" }, "2011/2012 Parking": { "color": "#00a790", "title": "2011/2012 Parking", "sortData": "2011/2012 Parking" }, "2011/2012 Student/Senior": { "color": "#6fa1c3", "title": "2011/2012 Student/Senior", "sortData": "2011/2012 Student/Senior" }, "2012/2013 Cafe": { "color": "#ffa62e", "title": "2012/2013 Cafe", "sortData": "2012/2013 Cafe" }, "2012/2013 Dance": { "color": "#ff6752", "title": "2012/2013 Dance", "sortData": "2012/2013 Dance" }, "2012/2013 LATOH": { "color": "#434343", "title": "2012/2013 LATOH", "sortData": "2012/2013 LATOH" }, "2012/2013 Misc": { "color": "#00b29a", "title": "2012/2013 Misc", "sortData": "2012/2013 Misc" }, "2012/2013 Opera": { "color": "#74a9cd", "title": "2012/2013 Opera", "sortData": "2012/2013 Opera", "inResultset": true }, "2012/2013 Other": { "color": "#ffaa38", "title": "2012/2013 Other", "sortData": "2012/2013 Other" }, "2012/2013 Parking": { "color": "#ff6f5b", "title": "2012/2013 Parking", "sortData": "2012/2013 Parking" }, "2012/2013 Student/Senior": { "color": "#474747", "title": "2012/2013 Student/Senior", "sortData": "2012/2013 Student/Senior" }, "2013/2014 Cafe": { "color": "#00bba2", "title": "2013/2014 Cafe", "sortData": "2013/2014 Cafe" }, "2013/2014 Dance": { "color": "#79afd5", "title": "2013/2014 Dance", "sortData": "2013/2014 Dance" }, "2013/2014 Latoh": { "color": "#ffad3f", "title": "2013/2014 Latoh", "sortData": "2013/2014 Latoh" }, "2013/2014 Misc": { "color": "#ff7461", "title": "2013/2014 Misc", "sortData": "2013/2014 Misc" }, "2013/2014 Opera": { "color": "#494949", "title": "2013/2014 Opera", "sortData": "2013/2014 Opera", "inResultset": true }, "2013/2014 Other": { "color": "#00c2a8", "title": "2013/2014 Other", "sortData": "2013/2014 Other" }, "2013/2014 Parking": { "color": "#7cb4db", "title": "2013/2014 Parking", "sortData": "2013/2014 Parking" }, "2013/2014 Student/Senior": { "color": "#ffaf45", "title": "2013/2014 Student/Senior", "sortData": "2013/2014 Student/Senior" }, "2014/2015 Dance": { "color": "#ff7966", "title": "2014/2015 Dance", "sortData": "2014/2015 Dance" }, "2014/2015 LATOH": { "color": "#4b4b4b", "title": "2014/2015 LATOH", "sortData": "2014/2015 LATOH" }, "2014/2015 Miscellaneous": { "color": "#00c7ad", "title": "2014/2015 Miscellaneous", "sortData": "2014/2015 Miscellaneous" }, "2014/2015 Opera": { "color": "#7fb8df", "title": "2014/2015 Opera", "sortData": "2014/2015 Opera", "inResultset": true }, "2014/2015 Other": { "color": "#ffb14a", "title": "2014/2015 Other", "sortData": "2014/2015 Other" }, "2014/2015 Parking": { "color": "#ff7d6b", "title": "2014/2015 Parking", "sortData": "2014/2015 Parking" }, "2014/2015 Student/Senior": { "color": "#4d4d4d", "title": "2014/2015 Student/Senior", "sortData": "2014/2015 Student/Senior" }, "2015/2016 Dance": { "color": "#00ccb1", "title": "2015/2016 Dance", "sortData": "2015/2016 Dance" }, "2015/2016 LATOH": { "color": "#81bce4", "title": "2015/2016 LATOH", "sortData": "2015/2016 LATOH" }, "2015/2016 Miscellaneous": { "color": "#ffb34e", "title": "2015/2016 Miscellaneous", "sortData": "2015/2016 Miscellaneous" }, "2015/2016 Opera": { "color": "#ff806f", "title": "2015/2016 Opera", "sortData": "2015/2016 Opera", "inResultset": true }, "2015/2016 Other": { "color": "#4e4e4e", "title": "2015/2016 Other", "sortData": "2015/2016 Other" }, "2015/2016 Parking": { "color": "#00d0b4", "title": "2015/2016 Parking", "sortData": "2015/2016 Parking" }, "2016/2017 Dance": { "color": "#83bfe7", "title": "2016/2017 Dance", "sortData": "2016/2017 Dance" }, "2016/2017 LATOH": { "color": "#ffb552", "title": "2016/2017 LATOH", "sortData": "2016/2017 LATOH" }, "2016/2017 Miscellaneous": { "color": "#ff8372", "title": "2016/2017 Miscellaneous", "sortData": "2016/2017 Miscellaneous" }, "2016/2017 Opera": { "color": "#505050", "title": "2016/2017 Opera", "sortData": "2016/2017 Opera", "inResultset": true }, "2016/2017 Other": { "color": "#00d3b7", "title": "2016/2017 Other", "sortData": "2016/2017 Other" }, "2016/2017 Parking": { "color": "#85c1eb", "title": "2016/2017 Parking", "sortData": "2016/2017 Parking" }, "2016/2017 Student Senior": { "color": "#ffb655", "title": "2016/2017 Student Senior", "sortData": "2016/2017 Student Senior" }, "2017/2018 Dance": { "color": "#ff8575", "title": "2017/2018 Dance", "sortData": "2017/2018 Dance" }, "2017/2018 LATOH": { "color": "#515151", "title": "2017/2018 LATOH", "sortData": "2017/2018 LATOH" }, "2017/2018 Miscellaneous": { "color": "#00d6ba", "title": "2017/2018 Miscellaneous", "sortData": "2017/2018 Miscellaneous" }, "2017/2018 Opera": { "color": "#ffb655", "title": "2017/2018 Opera", "sortData": "2017/2018 Opera", "inResultset": true }, "2017/2018 Other": { "color": "#ff8575", "title": "2017/2018 Other", "sortData": "2017/2018 Other" }, "2017/2018 Parking": { "color": "#515151", "title": "2017/2018 Parking", "sortData": "2017/2018 Parking" }, "2017/2018 Student Senior": { "color": "#00d6ba", "title": "2017/2018 Student Senior", "sortData": "2017/2018 Student Senior" }, "2018/2019 Dance": { "color": "#85c1eb", "title": "2018/2019 Dance", "sortData": "2018/2019 Dance" }, "2018/2019 LATOH": { "color": "#ffb655", "title": "2018/2019 LATOH", "sortData": "2018/2019 LATOH" }, "2018/2019 Miscellaneous": { "color": "#ff8575", "title": "2018/2019 Miscellaneous", "sortData": "2018/2019 Miscellaneous" }, "2018/2019 Opera": { "color": "#515151", "title": "2018/2019 Opera", "sortData": "2018/2019 Opera", "inResultset": true }, "2018/2019 Other": { "color": "#00d6ba", "title": "2018/2019 Other", "sortData": "2018/2019 Other" }, "2018/2019 Parking": { "color": "#85c1eb", "title": "2018/2019 Parking", "sortData": "2018/2019 Parking" }, "2018/2019 Student Senior": { "color": "#ffb655", "title": "2018/2019 Student Senior", "sortData": "2018/2019 Student Senior" }, "2019/2020 Dance": { "color": "#ff8575", "title": "2019/2020 Dance", "sortData": "2019/2020 Dance" }, "2019/2020 Miscellaneous": { "color": "#515151", "title": "2019/2020 Miscellaneous", "sortData": "2019/2020 Miscellaneous" }, "2019/2020 Opera": { "color": "#00d6ba", "title": "2019/2020 Opera", "sortData": "2019/2020 Opera", "inResultset": true }, "2019/2020 Other": { "color": "#85c1eb", "title": "2019/2020 Other", "sortData": "2019/2020 Other" }, "2019/2020 Parking": { "color": "#ffb655", "title": "2019/2020 Parking", "sortData": "2019/2020 Parking" }, "2019/2020 Student Senior": { "color": "#ff8575", "title": "2019/2020 Student Senior", "sortData": "2019/2020 Student Senior" }, "2020/2021 LATOH": { "color": "#515151", "title": "2020/2021 LATOH", "sortData": "2020/2021 LATOH" }, "2020/2021 Miscellaneous": { "color": "#00d6ba", "title": "2020/2021 Miscellaneous", "sortData": "2020/2021 Miscellaneous" }, "2020/2021 Opera": { "color": "#85c1eb", "title": "2020/2021 Opera", "sortData": "2020/2021 Opera", "inResultset": true }, "2020/2021 Parking": { "color": "#ffb655", "title": "2020/2021 Parking", "sortData": "2020/2021 Parking" } }, "subtotal": true } }, { "jaql": { "table": "ORDER DETAILS", "column": "Channel", "dim": "[ORDER DETAILS.Channel]", "datatype": "text", "merged": true, "title": "Channel" }, "format": { "members": { "(none)": { "color": "#547A94", "title": "(none)", "sortData": "(none)", "inResultset": true }, "Default Channel": { "color": "#F48E06", "title": "Default Channel", "sortData": "Default Channel", "inResultset": true }, "Phone": { "color": "#DB4935", "title": "Phone", "sortData": "Phone", "inResultset": true }, "Website": { "color": "#333333", "title": "Website", "sortData": "Website", "inResultset": true }, "Mail": { "color": "#008775", "title": "Mail", "sortData": "Mail", "inResultset": true }, "E-mail": { "color": "#618caa", "title": "E-mail", "sortData": "E-mail", "inResultset": true }, "In Person": { "color": "#ff9b16", "title": "In Person", "sortData": "In Person", "inResultset": true }, "Fax": { "color": "#fc543d", "title": "Fax", "sortData": "Fax", "inResultset": true }, "Telemarketing": { "color": "#3b3b3b", "title": "Telemarketing", "sortData": "Telemarketing", "inResultset": true }, "OC Group Sales": { "color": "#009b87", "title": "OC Group Sales", "sortData": "OC Group Sales", "inResultset": true }, "1 Trg Mailing": { "color": "#6897b7", "title": "1 Trg Mailing", "sortData": "1 Trg Mailing", "inResultset": true }, "Board Comps": { "color": "#ffa022", "title": "Board Comps", "sortData": "Board Comps", "inResultset": true }, "MA Frida Mailed": { "color": "#ff5d47", "title": "MA Frida Mailed", "sortData": "MA Frida Mailed", "inResultset": true }, "Nutty Parents": { "color": "#3f3f3f", "title": "Nutty Parents", "sortData": "Nutty Parents" }, "BE Will Call": { "color": "#00a790", "title": "BE Will Call", "sortData": "BE Will Call", "inResultset": true }, "DIA Will Call": { "color": "#6fa1c3", "title": "DIA Will Call", "sortData": "DIA Will Call", "inResultset": true }, "Ma Will Call": { "color": "#ffa62e", "title": "Ma Will Call", "sortData": "Ma Will Call", "inResultset": true }, "50/50 Payment": { "color": "#ff6752", "title": "50/50 Payment", "sortData": "50/50 Payment", "inResultset": true }, "Extension": { "color": "#434343", "title": "Extension", "sortData": "Extension", "inResultset": true }, "TRBO": { "color": "#00b29a", "title": "TRBO", "sortData": "TRBO", "inResultset": true }, "UMS": { "color": "#74a9cd", "title": "UMS", "sortData": "UMS" }, "Groupmatics": { "color": "#ffaa38", "title": "Groupmatics", "sortData": "Groupmatics", "inResultset": true } } }, "field": { "id": "[ORDER DETAILS.Channel]", "index": 1 } } ] }, { "name": "values", "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", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 2 } }, { "jaql": { "type": "measure", "formula": "( sum([DDE3D-B37]), All( [33238-9CD] ) )", "context": { "[DDE3D-B37]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "title": "Ticket Paid Count" }, "[33238-9CD]": { "table": "ORDER DETAILS", "column": "Channel", "dim": "[ORDER DETAILS.Channel]", "datatype": "text", "merged": true, "title": "Channel" } }, "title": "Ticket Paid Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( sum([DDE3D-B37]), All( [33238-9CD] ) )", "index": 3 } }, { "jaql": { "type": "measure", "formula": "sum([C523A-AF3]) / ( sum([C523A-AF3]), All( [F4DBB-16B] ) )", "context": { "[C523A-AF3]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "title": "Ticket Paid Count" }, "[F4DBB-16B]": { "table": "ORDER DETAILS", "column": "Channel", "dim": "[ORDER DETAILS.Channel]", "datatype": "text", "merged": true, "title": "Channel" } }, "title": "Ticket Paid Count (1)" }, "format": { "mask": { "decimals": "auto", "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([C523A-AF3]) / ( sum([C523A-AF3]), All( [F4DBB-16B] ) )", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "filter": { "contains": "opera" }, "collapsed": true, "datasource": { "title": "MIOP-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aMIOPLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-09-10T22:07:26" } }, "title": "Season" } ] } ] }, "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": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "channel", "title": "Channel", "singular": "Channel", "plural": "Channel" } ] }, "rowsGrandTotal": true }, "instanceid": "9933D-17B8-F3", "queryStartTime": "2020-09-11T12:24:44", "canEditFilters": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "dashboardid": "5f5badeb6cab4f101c734c00", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "drawing": true } ], "hierarchies": [] }