{
"title": "COVID-19 Return Impact Overview",
"desc": "",
"source": "5e693c8d448663025c974c3e",
"type": "dashboard",
"style": {
"name": "vivid",
"palette": {
"_id": "5c34f334bda9c409103dfb2e",
"colors": [
"#547A94",
"#F48E06",
"#DB4935",
"#333333",
"#008775"
],
"min": "#547A94",
"max": "#F48E06",
"name": "Tessitura",
"isDefault": true,
"sortOrder": 0
}
},
"layout": {
"instanceid": "39F9D-9ADB-23",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "92px",
"defaultWidth": 128,
"widgetid": "5e6fb8f7745c331d9ca795e4"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 798,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"height": 192,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "5e6fd002745c331d9ca79956"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 632,
"index": 0
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "5e6fd010745c331d9ca7995c",
"height": 192
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 632,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "5e70e6056ebcb4197cc8a918",
"height": "168px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 399,
"index": 0
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "5e70e59c6ebcb4197cc8a8fc",
"height": "168px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 399,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "96px",
"defaultWidth": 128,
"widgetid": "5e7145846ebcb4197cc8b477"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 798,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e6fb6f1745c331d9ca79592",
"height": "400px"
}
],
"width": 50.62656641604011,
"stretchable": false,
"pxlWidth": 404,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e6fb5b9745c331d9ca79567",
"height": "400px"
}
],
"width": 49.373433583959894,
"stretchable": false,
"pxlWidth": 394,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5e6fb5b9745c331d9ca79566",
"height": "544px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 798,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": 512,
"defaultWidth": 512,
"widgetid": "5e7266636df8da1594dfc794"
}
]
}
]
}
],
"pxlWidth": 798,
"index": 0
}
],
"container": {}
},
"original": null,
"oid": "5e6fb5b9745c331d9ca79564",
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
},
"editing": false,
"parentFolder": "5dfb9e0b7006141a940df030",
"isPublic": null,
"defaultFilters": null,
"filters": [
{
"instanceid": "A8FF3-93AF-97",
"isCascading": true,
"levels": [
{
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"collapsed": true,
"panel": "scope",
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2019/2020 Dance",
"2019/2020 Opera",
"2019/2020 Other",
"2019/2020 Student Senior"
]
}
},
{
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"collapsed": true,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"A Winter Fantasy",
"Don Giovanni",
"Gala w/ Michael Fabiano",
"Gianni Schicchi",
"Joffrey Ballet",
"Malandain Ballet Biarritz",
"The Nutcracker",
"Too Hot To Handel",
"Sweeney Todd"
]
}
},
"panel": "scope"
},
{
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE.Date1 (Calendar)]",
"datatype": "datetime",
"merged": true,
"title": "Months in Date",
"level": "months",
"collapsed": true,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"2019-11-01T00:00:00",
"2019-12-01T00:00:00",
"2020-02-01T00:00:00"
]
}
}
}
],
"model": {
"instanceid": "06D9F-4673-3E",
"__store": [
"[SEASON.Season]",
"[PERFORMANCE DETAIL.Production Season]",
"[PERFORMANCE.Date1 (Calendar)]"
]
},
"disabled": false
},
{
"jaql": {
"table": "TRANSACTION CREATE DATE",
"column": "Date",
"dim": "[TRANSACTION CREATE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"title": "Days in Date",
"level": "days",
"filter": {
"from": "2020-03-12",
"to": "2020-06-30"
},
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"collapsed": true
},
"instanceid": "BC7DB-34F4-EA",
"isCascading": false
},
{
"jaql": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"collapsed": true,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Change",
"Ticket Refund",
"Zero Adjustment"
]
}
},
"instanceid": "FF1DC-B81A-AA",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"subscription": {
"isDataChange": true,
"type": "onUpdate",
"schedule": "* * * * * *",
"timezone": 300,
"tzName": "America/Chicago",
"context": {
"dashboardid": "5e6fb5b9745c331d9ca79564"
},
"active": true,
"executionPerDay": 1,
"reportType": {
"inline": true,
"pdf": {
"includeTitle": true,
"includeFilters": false,
"includeDS": true,
"elasticubeBuiltValue": "",
"renderingInfo": {
"paperFormat": "LETTER",
"paperOrientation": "landscape",
"layout": "asis",
"showNarration": true
}
}
},
"emailSettings": {
"isEmail": true,
"isPdf": true
}
},
"previewLayout": [
{
"type": "previewLayout",
"format": "LETTER",
"orientation": "landscape",
"layout": "asis",
"headerSize": "compact",
"title": true,
"elasticubeBuilt": true,
"elasticubeName": false,
"filters": false,
"logo": false,
"pageNumbers": true,
"pages": [
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 143,
"widgetid": "5e6fb8f7745c331d9ca795e4"
}
],
"width": 100
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 234,
"widgetid": "5e6fd002745c331d9ca79956"
}
],
"width": 50
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 234,
"widgetid": "5e6fd010745c331d9ca7995c"
}
],
"width": 50
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 210,
"widgetid": "5e70e6056ebcb4197cc8a918"
}
],
"width": 50
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 210,
"widgetid": "5e70e59c6ebcb4197cc8a8fc"
}
],
"width": 50
}
]
}
]
}
]
},
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 147,
"widgetid": "5e7145846ebcb4197cc8b477"
}
],
"width": 100
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 1024,
"height": 442,
"widgetid": "5e6fb6f1745c331d9ca79592"
}
],
"width": 50.62656641604011
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 1024,
"height": 442,
"widgetid": "5e6fb5b9745c331d9ca79567"
}
],
"width": 49.373433583959894
}
]
}
]
}
]
},
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 1024,
"height": 586,
"widgetid": "5e6fb5b9745c331d9ca79566"
}
],
"width": 100
}
]
}
]
}
]
}
],
"savedByButton": "Save",
"openPath": "PDF Settings"
}
],
"widgets": [
{
"title": "Refunds by Production",
"subtype": "bar/classic",
"desc": null,
"source": "5e693c8d448663025c974c40",
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([E2DBA-F62]) ",
"context": {
"[E2DBA-F62]": {
"table": "FINANCE VALUES",
"column": "Ticket Paid Amount",
"dim": "[FINANCE VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
}
},
"title": "Ticket $"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"color_bkp": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "sum([E2DBA-F62]) ",
"index": 5
}
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"format": {
"members": {
"(none)": {
"color": "#547A94",
"title": "(none)",
"sortData": "(none)"
},
"Check": {
"color": "#F48E06",
"title": "Check",
"sortData": "Check",
"inResultset": true
},
"Credit Card": {
"color": "#DB4935",
"title": "Credit Card",
"sortData": "Credit Card",
"inResultset": true
},
"Gift Certificate": {
"color": "#333333",
"title": "Gift Certificate",
"sortData": "Gift Certificate",
"inResultset": true
},
"On Account": {
"color": "#008775",
"title": "On Account",
"sortData": "On Account",
"inResultset": true
},
"Change": {
"color": "#618caa",
"title": "Change",
"sortData": "Change",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
}
}
}
]
}
]
},
"oid": "5e6fb5b9745c331d9ca79566",
"type": "chart/bar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"navigator": {
"enabled": true
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "production",
"title": "Production",
"singular": "Production",
"plural": "Production"
},
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
}
]
}
},
"instanceid": "D659F-2FE9-75",
"queryStartTime": "2020-03-17T09:57:44",
"currentPage": 4,
"widgetTimingLoged": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"realTimeRefreshing": false,
"disableSelctor": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": 1581660000000,
"maxDate": 1591506000000,
"tickInterval": 86400000,
"tickLevel": "day",
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"canEditFilters": true,
"viewState": {
"activeTab": "design"
},
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 4
}
},
"drawing": true
},
{
"title": "Refunds Already Processed by Payment Method Type",
"subtype": "pie/classic",
"desc": null,
"source": "5e693c8d448663025c974c40",
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"format": {
"members": {
"(none)": {
"color": "#547A94",
"title": "(none)",
"sortData": "(none)"
},
"Check": {
"color": "#F48E06",
"title": "Check",
"sortData": "Check",
"inResultset": true
},
"Credit Card": {
"color": "#DB4935",
"title": "Credit Card",
"sortData": "Credit Card",
"inResultset": true
},
"Gift Certificate": {
"color": "#333333",
"title": "Gift Certificate",
"sortData": "Gift Certificate",
"inResultset": true
},
"On Account": {
"color": "#008775",
"title": "On Account",
"sortData": "On Account",
"inResultset": true
},
"Change": {
"color": "#618caa",
"title": "Change",
"sortData": "Change",
"inResultset": true
},
"Cash": {
"color": "#ff9b16",
"title": "Cash",
"sortData": "Cash"
},
"Invoice": {
"color": "#fc543d",
"title": "Invoice",
"sortData": "Invoice"
},
"Other": {
"color": "#3b3b3b",
"title": "Other",
"sortData": "Other"
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([E2DBA-F62]) ",
"context": {
"[E2DBA-F62]": {
"table": "FINANCE VALUES",
"column": "Ticket Paid Amount",
"dim": "[FINANCE VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
}
},
"title": "Ticket $"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
}
},
"field": {
"id": "sum([E2DBA-F62]) ",
"index": 5
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
}
}
}
]
}
]
},
"oid": "5e6fb5b9745c331d9ca79567",
"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": true,
"position": "bottom"
},
"labels": {
"enabled": true,
"categories": true,
"value": true,
"percent": true,
"decimals": false
},
"dataLimits": {
"seriesCapacity": 100000
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"navigator": {
"enabled": true
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
}
]
}
},
"instanceid": "4A029-E347-14",
"queryStartTime": "2020-03-18T13:20:21",
"currentPage": 4,
"widgetTimingLoged": true,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"realTimeRefreshing": false,
"disableSelctor": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": 1581660000000,
"maxDate": 1591506000000,
"tickInterval": 86400000,
"tickLevel": "day",
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "design"
},
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"selectorLocked": false
},
"drawing": true,
"canEditFilters": true
},
{
"title": "Accounts Already Refunded",
"subtype": "column/classic",
"oid": "5e6fb6f1745c331d9ca79592",
"desc": null,
"source": "5e693c8d448663025c974c40",
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"format": {
"members": {
"(none)": {
"color": "#547A94",
"title": "(none)",
"sortData": "(none)"
},
"Check": {
"color": "#F48E06",
"title": "Check",
"sortData": "Check",
"inResultset": true
},
"Credit Card": {
"color": "#DB4935",
"title": "Credit Card",
"sortData": "Credit Card",
"inResultset": true
},
"Gift Certificate": {
"color": "#333333",
"title": "Gift Certificate",
"sortData": "Gift Certificate",
"inResultset": true
},
"On Account": {
"color": "#008775",
"title": "On Account",
"sortData": "On Account",
"inResultset": true
},
"Change": {
"color": "#618caa",
"title": "Change",
"sortData": "Change",
"inResultset": true
}
}
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "# of unique Constituent ID"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"size": {
"min": 4,
"max": 24
},
"color": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance"
}
}
}
]
}
]
},
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": -45
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"lineWidth": {
"width": "bold"
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"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
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
}
]
}
},
"instanceid": "AD4D5-AFE9-18",
"queryStartTime": "2020-03-18T13:20:21",
"currentPage": 4,
"widgetTimingLoged": true,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"realTimeRefreshing": false,
"disableSelctor": false,
"continuousDates": false,
"nullAsZero": false,
"minDate": 1581660000000,
"maxDate": 1591506000000,
"tickInterval": 86400000,
"tickLevel": "day",
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "design"
},
"canEditFilters": true,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5e6fb8f7745c331d9ca795e4",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-15T21:58:27"
},
"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": "This dashboard tracks Ticket Exchanges and Refunds that happened on or after our COVID-19 cancelations.
Dance Theatre of Harlem and Champion announced 3/12/20.
ABT - Swan Lake, Pagliacci, and Very Last Green Thing announced 3/17/20.
As Of numbers are as of those dates.
Outstanding Sales do not include the Student/Senior shows or comps.",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "091FD-D593-81",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"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": "Outstanding Subscription Tickets in Canceled Shows",
"subtype": "indicator/numeric",
"oid": "5e6fd002745c331d9ca79956",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-16T22:21:10"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[PERFORMANCE.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "[CBCAA-B9C]",
"context": {
"[CBCAA-B9C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
}
},
"title": "Subscription Ticket Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"type": "measure",
"formula": "1600+791+1776+869",
"context": {},
"title": "Tickets As Of Announcement"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Champion",
"The Dance Theatre of Harlem"
]
},
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-16T22:21:10"
},
"collapsed": true
},
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Subscription"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-16T22:21:10"
}
}
}
]
}
]
},
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
},
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "C12CF-5CFE-84",
"queryStartTime": "2020-03-17T16:41:59",
"drawing": true,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"canEditFilters": true
},
{
"title": "Outstanding Subscriptions in Canceled Shows",
"subtype": "indicator/numeric",
"oid": "5e6fd010745c331d9ca7995c",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[PERFORMANCE.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "[F759D-06F]",
"context": {
"[F759D-06F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
}
},
"title": "Outstanding $$$"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"color": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"type": "measure",
"formula": "160754+44820.7+176843+73063.5",
"context": {},
"title": "Sales As Of Announcement"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Champion",
"The Dance Theatre of Harlem",
"The Dance Theatre of Harlem"
]
},
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
},
"collapsed": true
},
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Subscription"
]
},
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
}
}
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Layer Category",
"dim": "[PERFORMANCE PRICING.Price Layer Category]",
"datatype": "text",
"merged": true,
"title": "Price Layer Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Price"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
}
}
}
]
}
]
},
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
},
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
},
{
"id": "price_layer_category",
"title": "Price Layer Category",
"singular": "Price Layer Category",
"plural": "Price Layer Category"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "C12CF-5CFE-84",
"queryStartTime": "2020-03-17T16:37:44",
"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
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true,
"canEditFilters": true
},
{
"title": "Outstanding Single Tickets in Canceled Shows",
"subtype": "indicator/numeric",
"oid": "5e70e59c6ebcb4197cc8a8fc",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[PERFORMANCE.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "[F759D-06F]",
"context": {
"[F759D-06F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
}
},
"title": "Outstanding $$$"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"color": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"type": "measure",
"formula": "24449.69+124740.16+40013.27+251837+3035",
"context": {},
"title": "Sales As Of Announcement"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Champion",
"The Dance Theatre of Harlem",
"The Dance Theatre of Harlem"
]
},
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
},
"collapsed": true
},
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Standard",
"Discount",
"Student Senior"
]
},
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
}
}
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Layer Category",
"dim": "[PERFORMANCE PRICING.Price Layer Category]",
"datatype": "text",
"merged": true,
"title": "Price Layer Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Price"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-15T22:04:30"
}
}
}
]
}
]
},
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
},
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
},
{
"id": "price_layer_category",
"title": "Price Layer Category",
"singular": "Price Layer Category",
"plural": "Price Layer Category"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "C12CF-5CFE-84",
"queryStartTime": "2020-03-17T16:43:44",
"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
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true
},
{
"title": "Outstanding Single Tickets in Canceled Shows",
"subtype": "indicator/numeric",
"oid": "5e70e6056ebcb4197cc8a918",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-16T22:21:10"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[PERFORMANCE.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "[CBCAA-B9C]",
"context": {
"[CBCAA-B9C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
}
},
"title": "Single Ticket Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#547A94",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"type": "measure",
"formula": "315+2309+444+2523+89",
"context": {},
"title": "Tickets As Of Announcement"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Standard",
"Discount",
"Student Senior"
]
},
"collapsed": true,
"datasource": {
"title": "MIOP-Seats and Tickets",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Seats and Tickets",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaSEATSIAAaANDIAAaTICKETS",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaSeatsIAAaandIAAaTickets",
"lastBuildTime": "2020-03-16T22:21:10"
}
}
}
]
}
]
},
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "C12CF-5CFE-84",
"queryStartTime": "2020-03-17T16:43:13",
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5e7145846ebcb4197cc8b477",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-16T22:13:09"
},
"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": "Key
On Account = Donation
Change = Exchange
Credit Card = Refund
Check = Refund
Gift Certificate = Gift Certificate
",
"vAlign": "valign-top",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "724CE-5A1A-1A",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5e6fb5b9745c331d9ca79564",
"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": "Amounts by Payment Method Type",
"subtype": "bar/classic",
"oid": "5e7266636df8da1594dfc794",
"desc": null,
"source": null,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[FINANCE DETAILS.Transaction Type]",
"[TRANSACTION CREATE DATE.Date (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"field": {
"id": "[PAYMENT.Payment Method Type1]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(sum([F00DA-D5E]), [88C52-D95], [89642-C25])",
"context": {
"[F00DA-D5E]": {
"table": "FINANCE VALUES",
"column": "Ticket Paid Amount",
"dim": "[FINANCE VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[88C52-D95]": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Refund",
"Zero Adjustment",
"Ticket Change"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
},
"[89642-C25]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"from": "2020-03-11",
"to": "2020-06-30"
},
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
}
},
"title": "Ticket Refunds Issued"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"width": 115,
"color": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "(sum([F00DA-D5E]), [88C52-D95], [89642-C25])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([40913-E8A]), [EDA37-3BD], [5241C-6C3])",
"context": {
"[5241C-6C3]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANE.Price Type Category1]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Subscription"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
},
"[40913-E8A]": {
"table": "FINANCE VALUES",
"column": "Ticket Paid Amount",
"dim": "[FINANCE VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[9CCF5-3C4]": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Purchase",
"Ticket Refund",
"Ticket Change"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
},
"[EDA37-3BD]": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Purchase",
"Ticket Refund",
"Ticket Change",
"Zero Adjustment"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
}
},
"title": "Subscription Outstanding Amount"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"width": 114,
"color": {
"color": "#F48E06",
"type": "color"
}
},
"field": {
"id": "(sum([40913-E8A]), [EDA37-3BD], [5241C-6C3])",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B4E78-78C]), [B318B-AA2], [FA1F4-C51])",
"context": {
"[FA1F4-C51]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANE.Price Type Category1]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Standard",
"Discount"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
},
"[B4E78-78C]": {
"table": "FINANCE VALUES",
"column": "Ticket Paid Amount",
"dim": "[FINANCE VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[B318B-AA2]": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Purchase",
"Ticket Change",
"Ticket Refund",
"Zero Adjustment"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
},
"[B9CDB-B25]": {
"table": "FINANCE DETAILS",
"column": "Transaction Type",
"dim": "[FINANCE DETAILS.Transaction Type]",
"datatype": "text",
"merged": true,
"title": "Transaction Type",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Purchase"
]
},
"collapsed": false,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
}
},
"title": "Single Ticket Outstanding Amount"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"width": 111,
"color": {
"color": "#DB4935",
"type": "color"
}
},
"field": {
"id": "(sum([B4E78-78C]), [B318B-AA2], [FA1F4-C51])",
"index": 3
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Layer Category",
"dim": "[PERFORMANE.Price Layer Category1]",
"datatype": "text",
"merged": true,
"title": "Price Layer Category",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Ticket Price"
]
},
"collapsed": true,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
}
},
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"collapsed": true,
"datasource": {
"title": "MIOP-Finance",
"fullname": "NARCUBEBP010.KRIOSTESS.local/MIOP-Finance",
"id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aMIOPLQAaFINANCE",
"address": "NARCUBEBP010.KRIOSTESS.local",
"database": "aMIOPLQAaFinance",
"lastBuildTime": "2020-03-17T22:00:00"
}
}
}
]
}
]
},
"type": "chart/bar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"navigator": {
"enabled": true
},
"lineWidth": {
"width": "bold"
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
},
{
"id": "price_layer_category",
"title": "Price Layer Category",
"singular": "Price Layer Category",
"plural": "Price Layer Category"
}
]
}
},
"instanceid": "FC7F9-F78D-AC",
"widgetTimingLoged": true,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"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
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"drawing": true,
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"dashboardid": "5e6fb5b9745c331d9ca79564",
"queryStartTime": "2020-03-18T13:20:21"
}
],
"hierarchies": []
}