{
"title": "Box Office Data",
"oid": "5d95276d05de7d1d00712552",
"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": "1D920-B9B7-2A",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "84px",
"defaultWidth": 128,
"widgetid": "5e54354713e4180e24e57479"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1316,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 182,
"maxHeight": 1000,
"minWidth": 150,
"maxWidth": 1000,
"height": 640,
"defaultWidth": 512,
"widgetid": "5d95312d05de7d1d0071273d"
}
],
"width": 68.99696048632221,
"stretchable": false,
"pxlWidth": 908,
"index": 0
},
{
"elements": [
{
"minHeight": 182,
"maxHeight": 1000,
"minWidth": 150,
"maxWidth": 1000,
"defaultWidth": 512,
"widgetid": "5e542a4513e4180e24e570b8",
"height": 640
}
],
"width": 31.0030395136778,
"stretchable": false,
"pxlWidth": 408,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"height": 384,
"defaultWidth": 512,
"widgetid": "5d95336905de7d1d007127b2"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1316,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542aa913e4180e24e570f3",
"height": "352px"
}
],
"width": 33.333333333333336,
"stretchable": false,
"pxlWidth": 439,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542afc13e4180e24e57115",
"height": "352px"
}
],
"width": 33.333333333333336,
"stretchable": false,
"pxlWidth": 438,
"index": 1
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542af513e4180e24e5710d",
"height": "352px"
}
],
"width": 33.333333333333336,
"stretchable": false,
"pxlWidth": 439,
"index": 2
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542af813e4180e24e57111",
"height": "352px"
}
],
"width": 33.43465045592705,
"stretchable": false,
"pxlWidth": 440,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542b4c13e4180e24e5713e",
"height": "352px"
}
],
"width": 33.130699088145896,
"stretchable": false,
"pxlWidth": 436,
"index": 1
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e542b4f13e4180e24e57142",
"height": "352px"
}
],
"width": 33.43465045592706,
"stretchable": false,
"pxlWidth": 440,
"index": 2
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "100px",
"defaultWidth": 128,
"widgetid": "5e5434ea13e4180e24e57460"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1316,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"height": 384,
"defaultWidth": 512,
"widgetid": "5d953e5205de7d1d00712990"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1316,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"height": 384,
"defaultWidth": 512,
"widgetid": "5e5432be13e4180e24e573cd"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 658,
"index": 0
},
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e5432c713e4180e24e573d2",
"height": 384
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 658,
"index": 1
}
]
}
],
"pxlWidth": 1316,
"index": 0
}
],
"container": {
"sizzle-1582574940635": {
"parentNode": [
"23155 403",
13
]
}
}
},
"original": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
},
"editing": true,
"filters": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Year",
"dim": "[PERFORMANCE DATE.Fiscal Year]",
"datatype": "numeric",
"title": "Fiscal Year",
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"filter": {
"explicit": false,
"multiSelection": "true",
"exclude": {
"members": [
"2018"
]
}
}
},
"instanceid": "B4053-4F10-51",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"parentFolder": "5daa47bca1c86e1b9c37ff88",
"defaultFilters": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Year",
"dim": "[PERFORMANCE DATE.Fiscal Year]",
"datatype": "numeric",
"title": "Fiscal Year",
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"filter": {
"explicit": false,
"multiSelection": "true",
"exclude": {
"members": [
"2018"
]
}
}
},
"isCascading": false,
"disabled": false
}
],
"widgets": [
{
"title": "Order activity by date",
"subtype": "heatmap",
"oid": "5d95312d05de7d1d0071273d",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "date",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc"
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "longDate",
"minutes": "HH:mm"
}
},
"hierarchies": [
"calendar",
"calendar - weeks"
]
}
]
},
{
"name": "color",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Year",
"dim": "[PERFORMANCE DATE.Fiscal Year]",
"datatype": "numeric",
"title": "Fiscal Year",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"disabled": false
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
}
]
}
]
},
"type": "heatmap",
"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": {
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2020,
"month": -4
},
"view/monthly": true,
"view/weekly": 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": "fiscal_year",
"title": "Fiscal Year",
"singular": "Fiscal Year",
"plural": "Fiscal Year"
},
{
"id": "weeks",
"title": "weeks",
"singular": "weeks",
"plural": "weeks"
}
]
}
},
"instanceid": "FA066-8B55-87",
"queryStartTime": "2020-02-24T14:39:18",
"widgetTimingLoged": false,
"drawing": true,
"canEditFilters": true,
"viewState": {
"activeTab": "design"
},
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"forcedRedraw": false,
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"triggersDomready": true,
"selector": true,
"disallowSelector": false,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
}
},
{
"title": "Box Office Channel and DOW",
"subtype": "column/polar",
"oid": "5d95336905de7d1d007127b2",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
}
}
]
},
{
"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"
}
}
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#124c87",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#ff0000",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#395365",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Thursday": {
"color": "#00a808",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#ff9c17",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#808080",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
},
"Sunday": {
"color": "#808080",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Year",
"dim": "[PERFORMANCE DATE.Fiscal Year]",
"datatype": "numeric",
"title": "Fiscal Year",
"filter": {
"explicit": false,
"multiSelection": "true",
"all": "true"
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
}
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Donation Voucher",
"Voucher Performance",
"Our MISSION: PARTY!"
]
}
},
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
},
"collapsed": true
}
},
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"19-20 JALC ",
"19-20 Voucher ",
"Healing Arts 18-19",
"Independent Presenters 18-19",
"JALC 18-19",
"Resident Companies 18-19",
"Smuin Ballet 18-19",
"Studio 105 18-19",
"Voucher 18-19"
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
}
}
},
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Web",
"(none)",
"Default Channel",
"E-mail"
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets"
}
},
"title": "Channel"
}
]
}
]
},
"type": "chart/polar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"categories": {
"enabled": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"axis": {
"enabled": true,
"labels": {
"enabled": true,
"rotation": 0
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 200
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
},
{
"id": "fiscal_year",
"title": "Fiscal Year",
"singular": "Fiscal Year",
"plural": "Fiscal Year"
},
{
"id": "performance",
"title": "Performance",
"singular": "Performance",
"plural": "Performance"
},
{
"id": "season",
"title": "Season",
"singular": "Season",
"plural": "Season"
}
]
}
},
"instanceid": "B3838-F6E5-41",
"queryStartTime": "2020-02-24T14:39:18",
"drawing": true,
"canEditFilters": true,
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 4
}
}
},
{
"title": "Sold vs Unsold counts",
"subtype": "column/stackedcolumn",
"oid": "5d953e5205de7d1d00712990",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance"
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance]",
"index": 0
},
"disabled": false
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Unsold Count",
"dim": "[SEAT & TICKET VALUES.Seat Unsold Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Unsold Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "color",
"color": "#547a94"
},
"color": {
"type": "color",
"color": "#007162"
}
},
"disabled": false
},
{
"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": {
"type": "color",
"color": "#00b29a"
}
},
"disabled": false
},
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Reserved Count",
"dim": "[SEAT & TICKET VALUES.Ticket Reserved Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Reserved Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#F48E06",
"type": "color"
}
},
"disabled": false
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"title": "Date",
"level": "days",
"filter": {
"from": "2020-02-24"
},
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"collapsed": true
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"CANCELLEDRolling Stone Reports"
]
}
},
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"collapsed": true
}
},
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"19-20 JALC ",
"19-20 Voucher "
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"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": false,
"rotation": 0
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": true
},
"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": "performance",
"title": "Performance",
"singular": "Performance",
"plural": "Performance"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "season",
"title": "Season",
"singular": "Season",
"plural": "Season"
}
]
}
},
"instanceid": "18BBA-7D17-16",
"queryStartTime": "2020-02-24T14:39:18",
"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": "filters"
},
"minDate": 0,
"maxDate": 0,
"tickInterval": 31556952000,
"tickLevel": "year",
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 14
}
}
},
{
"title": "Order activity by date",
"subtype": "pie/classic",
"oid": "5e542a4513e4180e24e570b8",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Web"
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:04:16",
"widgetTimingLoged": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"forcedRedraw": false,
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true,
"disableSelctor": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
}
},
{
"title": "Monday",
"subtype": "pie/classic",
"oid": "5e542aa913e4180e24e570f3",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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"
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail"
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Monday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:02:12",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"canEditFilters": true,
"drawing": true,
"viewState": {
"activeTab": "filters"
}
},
{
"title": "Wednesday",
"subtype": "pie/classic",
"oid": "5e542af513e4180e24e5710d",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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)"
},
"Default Channel": {
"color": "#F48E06",
"title": "Default Channel",
"sortData": "Default Channel",
"inResultset": true
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail"
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Wednesday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:02:33",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true
},
{
"title": "Thursday",
"subtype": "pie/classic",
"oid": "5e542af813e4180e24e57111",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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)"
},
"Default Channel": {
"color": "#F48E06",
"title": "Default Channel",
"sortData": "Default Channel"
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Thursday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:02:42",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true
},
{
"title": "Tuesday",
"subtype": "pie/classic",
"oid": "5e542afc13e4180e24e57115",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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)"
},
"Default Channel": {
"color": "#F48E06",
"title": "Default Channel",
"sortData": "Default Channel"
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail"
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Tuesday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:02:22",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true
},
{
"title": "Friday",
"subtype": "pie/classic",
"oid": "5e542b4c13e4180e24e5713e",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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)"
},
"Default Channel": {
"color": "#F48E06",
"title": "Default Channel",
"sortData": "Default Channel"
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail"
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:02:49",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true
},
{
"title": "Saturday/Sunday",
"subtype": "pie/classic",
"oid": "5e542b4f13e4180e24e57142",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
},
"selection": null,
"metadata": {
"drillHistory": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Channel",
"dim": "[ORDER DETAILS.Channel]",
"datatype": "text",
"merged": true,
"title": "Channel"
},
"parent": {
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name"
},
"format": {
"members": {
"Friday": {
"color": "#547A94",
"title": "Friday",
"sortData": "Friday",
"inResultset": true
},
"Monday": {
"color": "#F48E06",
"title": "Monday",
"sortData": "Monday",
"inResultset": true
},
"Saturday": {
"color": "#DB4935",
"title": "Saturday",
"sortData": "Saturday",
"inResultset": true
},
"Sunday": {
"color": "#333333",
"title": "Sunday",
"sortData": "Sunday",
"inResultset": true
},
"Thursday": {
"color": "#008775",
"title": "Thursday",
"sortData": "Thursday",
"inResultset": true
},
"Tuesday": {
"color": "#618caa",
"title": "Tuesday",
"sortData": "Tuesday",
"inResultset": true
},
"Wednesday": {
"color": "#ff9b16",
"title": "Wednesday",
"sortData": "Wednesday",
"inResultset": true
}
}
}
},
"through": {
"jaql": {
"datatype": "text",
"dim": "[ORDER DATE.Day Of Week Name]",
"title": "Day Of Week Name",
"column": "Day Of Week Name",
"table": "ORDER DATE",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Friday"
]
}
}
},
"format": {
"members": {
"E-mail": {
"color": "#547A94",
"title": "E-mail",
"sortData": "E-mail",
"inResultset": true
},
"In Person": {
"color": "#F48E06",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#DB4935",
"title": "Mail",
"sortData": "Mail",
"inResultset": true
},
"Phone": {
"color": "#333333",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#008775",
"title": "Voucher",
"sortData": "Voucher",
"inResultset": true
},
"Web": {
"color": "#618caa",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
],
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"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)"
},
"Default Channel": {
"color": "#F48E06",
"title": "Default Channel",
"sortData": "Default Channel"
},
"E-mail": {
"color": "#DB4935",
"title": "E-mail",
"sortData": "E-mail"
},
"In Person": {
"color": "#333333",
"title": "In Person",
"sortData": "In Person",
"inResultset": true
},
"Mail": {
"color": "#008775",
"title": "Mail",
"sortData": "Mail"
},
"Phone": {
"color": "#618caa",
"title": "Phone",
"sortData": "Phone",
"inResultset": true
},
"Voucher": {
"color": "#ff9b16",
"title": "Voucher",
"sortData": "Voucher"
},
"Web": {
"color": "#a66104",
"title": "Web",
"sortData": "Web",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"field": {
"id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum",
"index": 3
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"type": "condition",
"conditions": [
{
"color": "#7be2fd",
"operator": "<",
"expression": "100"
},
{
"color": "#6fa1c3",
"operator": "<",
"expression": "500"
},
{
"color": "#618eac",
"operator": "<",
"expression": "1000"
},
{
"color": "#547a94",
"operator": "<",
"expression": "1500"
},
{
"color": "#47667c",
"operator": "<",
"expression": "2000"
},
{
"color": "#395365",
"operator": "<",
"expression": "3000"
},
{
"color": "#232323",
"operator": "<",
"expression": "4000"
},
{
"color": "#953224",
"operator": "<",
"expression": "5000"
},
{
"color": "#b83d2d",
"operator": "<",
"expression": "6000"
},
{
"color": "#db4935",
"operator": "<",
"expression": "7000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "8000"
},
{
"color": "#fe553d",
"operator": "<",
"expression": "9000"
},
{
"color": "#ff6752",
"operator": "<",
"expression": "10000"
},
{
"color": "#ffa62e",
"operator": "<",
"expression": "15000"
},
{
"color": "#ff9c17",
"operator": "<",
"expression": "20000"
},
{
"color": "#f48e06",
"operator": "<",
"expression": "25000"
},
{
"color": "#F48E06",
"operator": "<",
"expression": "50000"
},
{
"color": "#cd7705",
"operator": "<",
"expression": "75000"
},
{
"color": "#a66104",
"operator": "<",
"expression": "100000"
}
]
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"sort": "asc",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"firstday": "mon",
"collapsed": true,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"title": "Days in Date"
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Day Of Week Name",
"dim": "[ORDER DATE.Day Of Week Name]",
"datatype": "text",
"merged": true,
"title": "Day Of Week Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Sunday",
"Saturday"
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2019-10-01T22:16:25"
}
}
}
]
}
]
},
"type": "chart/pie",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "left"
},
"labels": {
"enabled": true,
"categories": true,
"value": false,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"domain/month": false,
"domain/quarter": false,
"domain/half-year": true,
"domain/year": false,
"week/sunday": true,
"week/monday": false,
"grayoutEnabled": false,
"orient/horizontal": true,
"orient/vertical": false,
"dayNumberEnabled": true,
"dayNameEnabled": true,
"startMonth": {
"year": 2019,
"month": 4
},
"view/monthly": true,
"view/weekly": false,
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "channel",
"title": "Channel",
"singular": "Channel",
"plural": "Channel"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "day_of_week_name",
"title": "Day Of Week Name",
"singular": "Day Of Week Name",
"plural": "Day Of Week Name"
}
]
}
},
"instanceid": "CD8B9-4852-F3",
"queryStartTime": "2020-02-24T14:03:05",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": -2208967200000,
"maxDate": 1582437600000,
"tickInterval": 86400000,
"tickLevel": "day",
"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
},
"realTimeRefreshing": false,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true
},
"drawing": true
},
{
"title": "Delivery Method A-K",
"subtype": "pivot",
"oid": "5e5432be13e4180e24e573cd",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance"
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Order ID",
"dim": "[ORDER DETAILS.Order ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "# of unique Order ID"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[ORDER DETAILS.Order ID]_count",
"index": 2
},
"disabled": false
}
]
},
{
"name": "columns",
"items": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Delivery Method",
"dim": "[ORDER DETAILS.Delivery Method]",
"datatype": "text",
"merged": true,
"title": "Delivery Method"
},
"field": {
"id": "[ORDER DETAILS.Delivery Method]",
"index": 1
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Last Name",
"dim": "[CONSTITUENT.Last Name]",
"datatype": "text",
"merged": true,
"title": "Last Name",
"filter": {
"or": [
{
"startsWith": "a"
},
{
"startsWith": "b"
},
{
"startsWith": "c"
},
{
"startsWith": "d"
},
{
"startsWith": "e"
},
{
"startsWith": "f"
},
{
"startsWith": "g"
},
{
"startsWith": "h"
},
{
"startsWith": "i"
},
{
"startsWith": "j"
},
{
"startsWith": "k"
}
]
},
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
},
"collapsed": false
}
},
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Delivery Method",
"dim": "[ORDER DETAILS.Delivery Method]",
"datatype": "text",
"merged": true,
"title": "Delivery Method",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)",
"N/A",
"Standard Mail ",
"Tickets in Hand "
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
}
}
}
]
}
]
},
"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": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "performance",
"title": "Performance",
"singular": "Performance",
"plural": "Performance"
},
{
"id": "delivery_method",
"title": "Delivery Method",
"singular": "Delivery Method",
"plural": "Delivery Method"
},
{
"id": "last_name",
"title": "Last Name",
"singular": "Last Name",
"plural": "Last Name"
}
]
}
},
"instanceid": "598F8-E6AA-C9",
"queryStartTime": "2020-02-24T14:39:58",
"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": 2,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true,
"drillTarget": {
"oid": "5e31b0c813e4180e24d28a6f",
"caption": "_Constituents",
"folder": "5c8f9653548e8411acd0b73b"
}
},
"drilledDashboardDisplay": {}
},
{
"title": "Delivery Method L-Z",
"subtype": "pivot",
"oid": "5e5432c713e4180e24e573d2",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance",
"dim": "[PERFORMANCE DETAIL.Performance]",
"datatype": "text",
"merged": true,
"title": "Performance"
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Order ID",
"dim": "[ORDER DETAILS.Order ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "# of unique Order ID"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[ORDER DETAILS.Order ID]_count",
"index": 2
},
"disabled": false
}
]
},
{
"name": "columns",
"items": [
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Delivery Method",
"dim": "[ORDER DETAILS.Delivery Method]",
"datatype": "text",
"merged": true,
"title": "Delivery Method"
},
"field": {
"id": "[ORDER DETAILS.Delivery Method]",
"index": 1
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Last Name",
"dim": "[CONSTITUENT.Last Name]",
"datatype": "text",
"merged": true,
"title": "Last Name",
"filter": {
"or": [
{
"startsWith": "l"
},
{
"startsWith": "m"
},
{
"startsWith": "n"
},
{
"startsWith": "o"
},
{
"startsWith": "p"
},
{
"startsWith": "q"
},
{
"startsWith": "r"
},
{
"startsWith": "s"
},
{
"startsWith": "t"
},
{
"startsWith": "u"
},
{
"startsWith": "v"
},
{
"startsWith": "w"
},
{
"startsWith": "x"
},
{
"startsWith": "y"
},
{
"startsWith": "z"
}
]
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
}
}
},
{
"jaql": {
"table": "ORDER DETAILS",
"column": "Delivery Method",
"dim": "[ORDER DETAILS.Delivery Method]",
"datatype": "text",
"merged": true,
"title": "Delivery Method",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)",
"N/A",
"Tickets in Hand ",
"Standard Mail "
]
}
},
"collapsed": false,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
}
},
"title": "Delivery Method"
}
]
}
]
},
"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": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "performance",
"title": "Performance",
"singular": "Performance",
"plural": "Performance"
},
{
"id": "delivery_method",
"title": "Delivery Method",
"singular": "Delivery Method",
"plural": "Delivery Method"
},
{
"id": "last_name",
"title": "Last Name",
"singular": "Last Name",
"plural": "Last Name"
}
]
}
},
"instanceid": "598F8-E6AA-C9",
"queryStartTime": "2020-02-24T14:40:33",
"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": 2,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true,
"drillTarget": {
"oid": "5e31b0c813e4180e24d28a6f",
"caption": "_Constituents",
"folder": "5c8f9653548e8411acd0b73b"
}
},
"drawing": true,
"drilledDashboardDisplay": {}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5e5434ea13e4180e24e57460",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"type": "richtexteditor",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"content": {
"html": "Performance scheduling metrics",
"vAlign": "valign-middle",
"bgColor": "#434343",
"textAlign": "center"
}
},
"instanceid": "7BC02-F694-3A",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5e54354713e4180e24e57479",
"desc": null,
"source": null,
"datasource": {
"title": "SUNS-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SUNS-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSUNSLQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSUNSLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-02-24T00:17:25"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"type": "richtexteditor",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"content": {
"html": "Day to Day scheduling metrics
",
"vAlign": "valign-middle",
"bgColor": "#434343",
"textAlign": "center"
}
},
"instanceid": "2424D-BFBC-51",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5d95276d05de7d1d00712552",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
}
],
"hierarchies": []
}