{
"title": "Running Sum as Percent to Total Example Widgets",
"desc": "",
"source": null,
"type": "dashboard",
"style": {
"name": "vivid",
"palette": {
"_id": "5c48cf847365e6a748f9182c",
"colors": [
"#60C2BB",
"#94A1A8",
"#6E798D",
"#FA7240",
"#E2BA50"
],
"name": "Urban",
"isDefault": false,
"sortOrder": 70,
"isSystem": true
}
},
"layout": {
"instanceid": "DCA8D-B4D7-3A",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "112px",
"defaultWidth": 128,
"widgetid": "620ead282df9e61f384395e5"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "620ead282df9e61f384395f5",
"height": "40px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "620ead282df9e61f384395f7",
"height": 512
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "620eadcc2df9e61f38439654",
"height": "40px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "620eadd22df9e61f38439659",
"height": 512
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 959,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "620fb90313cfd63b843675db",
"height": 512
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "620eaf132df9e61f384396a3",
"height": "40px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "620ebe912df9e61f38439a1d",
"height": 384
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "620fb09513cfd63b84367402",
"height": "40px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "620fa65413cfd63b84367237",
"height": 384
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "620fb76013cfd63b8436754a",
"height": "40px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"height": "432px",
"defaultWidth": 512,
"widgetid": "620fb85613cfd63b8436758a"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1439,
"index": 0
}
]
}
],
"pxlWidth": 1439,
"index": 0
}
],
"container": {}
},
"original": null,
"oid": "620ead282df9e61f384395e4",
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"editing": true,
"parentFolder": "61eeb3aa9bf20b125cc0a653",
"filters": [
{
"instanceid": "A9F6F-6367-FA",
"isCascading": true,
"disabled": false,
"levels": [
{
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"collapsed": true,
"panel": "scope",
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"filter": {
"explicit": false,
"multiSelection": true,
"all": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2018",
"2019",
"2020",
"2022"
]
}
}
},
{
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season",
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BT18 Ballet Season",
"BT19 Ballet Season",
"BT20 Ballet Season",
"BT22 Ballet Season"
]
}
}
],
"model": {
"instanceid": "C16BD-BCB1-32",
"__store": [
"[SEASON.Season Fiscal Year]",
"[SEASON.Season]"
]
}
},
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Calendar Month",
"dim": "[PERFORMANCE DATE.Calendar Month]",
"datatype": "numeric",
"title": "Calendar Month",
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"9",
"10",
"11",
"12"
]
}
},
"instanceid": "D2430-75DA-C3",
"isCascading": false,
"locked": true
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent -999999",
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-01-24T04:44:48"
},
"collapsed": true,
"filter": {
"doesntEqual": "-999999"
}
},
"instanceid": "3CA0D-789A-D0",
"isCascading": false,
"disabled": false,
"locked": true
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Status",
"dim": "[PERFORMANCE DETAIL.Status]",
"datatype": "text",
"merged": true,
"title": "Status",
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Cancelled"
]
}
}
},
"instanceid": "ED156-42D4-3B",
"isCascading": false,
"locked": true
}
],
"filterToDatasourceMapping": {},
"settings": {
"autoUpdateOnFiltersChange": false
},
"widgets": [
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-01-24T04:44:48"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "620ead282df9e61f384395e5",
"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": "Running Sum as Percent to Total
Example widgets.
",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "CB8CC-914D-93",
"widgetTimingLoged": true,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "620ead282df9e61f384395e4",
"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"
},
"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
}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "620ead282df9e61f384395f5",
"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": "Order Weeks Prior to Performance
Pandemic vs. Pre-pandemic | Seats and Tickets
",
"vAlign": "valign-middle",
"bgColor": "#656d72",
"textAlign": "center"
}
},
"instanceid": "C1700-D789-A4",
"widgetTimingLoged": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"realTimeRefreshing": false,
"dashboardid": "620ead282df9e61f384395e4",
"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": "Tickets by Order Weeks Prior to Performance",
"subtype": "line/basic",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"format": {
"members": {
"0": {
"color": "#ffe398",
"title": "0",
"sortData": 0,
"inResultset": true
},
"1": {
"color": "#9efff8",
"title": "1",
"sortData": 1
},
"2": {
"color": "#e7f7ff",
"title": "2",
"sortData": 2
},
"3": {
"color": "#aec0e0",
"title": "3",
"sortData": 3
},
"4": {
"color": "#aec0e0",
"title": "4",
"sortData": 4
},
"9": {
"color": "#9efff8",
"title": "9",
"sortData": 9
},
"16": {
"color": "#e7f7ff",
"title": "16",
"sortData": 16
},
"22": {
"color": "#ffb296",
"title": "22",
"sortData": 22
},
"28": {
"color": "#ffe398",
"title": "28",
"sortData": 28
},
"-132": {
"color": "#60C2BB",
"title": "-132",
"sortData": -132
},
"-131": {
"color": "#94A1A8",
"title": "-131",
"sortData": -131
},
"-130": {
"color": "#6E798D",
"title": "-130",
"sortData": -130
},
"-129": {
"color": "#FA7240",
"title": "-129",
"sortData": -129
},
"-128": {
"color": "#E2BA50",
"title": "-128",
"sortData": -128
},
"-127": {
"color": "#6edfd7",
"title": "-127",
"sortData": -127
},
"-126": {
"color": "#aab9c1",
"title": "-126",
"sortData": -126
},
"-125": {
"color": "#7f8ba2",
"title": "-125",
"sortData": -125
},
"-124": {
"color": "#ff8255",
"title": "-124",
"sortData": -124
},
"-123": {
"color": "#ffd35d",
"title": "-123",
"sortData": -123
},
"-122": {
"color": "#77f0e7",
"title": "-122",
"sortData": -122
},
"-121": {
"color": "#b7c7cf",
"title": "-121",
"sortData": -121
},
"-118": {
"color": "#8895ae",
"title": "-118",
"sortData": -118
},
"-117": {
"color": "#ff8c61",
"title": "-117",
"sortData": -117
},
"-116": {
"color": "#ffd669",
"title": "-116",
"sortData": -116
},
"-114": {
"color": "#7ffff6",
"title": "-114",
"sortData": -114
},
"-113": {
"color": "#c3d5de",
"title": "-113",
"sortData": -113
},
"-112": {
"color": "#91a0ba",
"title": "-112",
"sortData": -112
},
"-110": {
"color": "#ff956e",
"title": "-110",
"sortData": -110
},
"-109": {
"color": "#ffd974",
"title": "-109",
"sortData": -109
},
"-108": {
"color": "#87fff6",
"title": "-108",
"sortData": -108
},
"-107": {
"color": "#cddfe9",
"title": "-107",
"sortData": -107
},
"-106": {
"color": "#99a8c4",
"title": "-106",
"sortData": -106
},
"-105": {
"color": "#ff9c78",
"title": "-105",
"sortData": -105
},
"-104": {
"color": "#ffdb7d",
"title": "-104",
"sortData": -104
},
"-103": {
"color": "#8cfff7",
"title": "-103",
"sortData": -103
},
"-102": {
"color": "#d5e7f1",
"title": "-102",
"sortData": -102
},
"-101": {
"color": "#9eaecb",
"title": "-101",
"sortData": -101
},
"-100": {
"color": "#ffa27f",
"title": "-100",
"sortData": -100
},
"-99": {
"color": "#ffdd84",
"title": "-99",
"sortData": -99
},
"-98": {
"color": "#91fff7",
"title": "-98",
"sortData": -98
},
"-97": {
"color": "#dbeef8",
"title": "-97",
"sortData": -97
},
"-96": {
"color": "#a2b3d0",
"title": "-96",
"sortData": -96
},
"-95": {
"color": "#ffa685",
"title": "-95",
"sortData": -95
},
"-94": {
"color": "#ffdf89",
"title": "-94",
"sortData": -94
},
"-93": {
"color": "#95fff7",
"title": "-93",
"sortData": -93
},
"-92": {
"color": "#dff3fe",
"title": "-92",
"sortData": -92
},
"-91": {
"color": "#a6b7d5",
"title": "-91",
"sortData": -91
},
"-90": {
"color": "#ffaa8a",
"title": "-90",
"sortData": -90
},
"-89": {
"color": "#ffe08e",
"title": "-89",
"sortData": -89
},
"-88": {
"color": "#98fff8",
"title": "-88",
"sortData": -88
},
"-87": {
"color": "#e3f5ff",
"title": "-87",
"sortData": -87
},
"-86": {
"color": "#a9bad9",
"title": "-86",
"sortData": -86
},
"-85": {
"color": "#ffad8f",
"title": "-85",
"sortData": -85
},
"-84": {
"color": "#ffe192",
"title": "-84",
"sortData": -84
},
"-83": {
"color": "#9bfff8",
"title": "-83",
"sortData": -83
},
"-82": {
"color": "#e5f6ff",
"title": "-82",
"sortData": -82
},
"-81": {
"color": "#acbddc",
"title": "-81",
"sortData": -81
},
"-80": {
"color": "#ffb092",
"title": "-80",
"sortData": -80
},
"-79": {
"color": "#ffe295",
"title": "-79",
"sortData": -79
},
"-78": {
"color": "#9efff8",
"title": "-78",
"sortData": -78
},
"-77": {
"color": "#e7f7ff",
"title": "-77",
"sortData": -77
},
"-76": {
"color": "#aec0e0",
"title": "-76",
"sortData": -76
},
"-75": {
"color": "#ffb296",
"title": "-75",
"sortData": -75
},
"-74": {
"color": "#ffe398",
"title": "-74",
"sortData": -74
},
"-73": {
"color": "#e7f7ff",
"title": "-73",
"sortData": -73
},
"-72": {
"color": "#aec0e0",
"title": "-72",
"sortData": -72
},
"-71": {
"color": "#ffb296",
"title": "-71",
"sortData": -71
},
"-70": {
"color": "#ffe398",
"title": "-70",
"sortData": -70
},
"-69": {
"color": "#9efff8",
"title": "-69",
"sortData": -69
},
"-68": {
"color": "#e7f7ff",
"title": "-68",
"sortData": -68
},
"-67": {
"color": "#aec0e0",
"title": "-67",
"sortData": -67
},
"-66": {
"color": "#ffb296",
"title": "-66",
"sortData": -66
},
"-65": {
"color": "#ffe398",
"title": "-65",
"sortData": -65
},
"-64": {
"color": "#9efff8",
"title": "-64",
"sortData": -64
},
"-63": {
"color": "#e7f7ff",
"title": "-63",
"sortData": -63
},
"-62": {
"color": "#aec0e0",
"title": "-62",
"sortData": -62
},
"-61": {
"color": "#ffb296",
"title": "-61",
"sortData": -61
},
"-60": {
"color": "#ffe398",
"title": "-60",
"sortData": -60
},
"-59": {
"color": "#9efff8",
"title": "-59",
"sortData": -59
},
"-58": {
"color": "#e7f7ff",
"title": "-58",
"sortData": -58
},
"-57": {
"color": "#aec0e0",
"title": "-57",
"sortData": -57
},
"-56": {
"color": "#ffb296",
"title": "-56",
"sortData": -56
},
"-55": {
"color": "#ffe398",
"title": "-55",
"sortData": -55
},
"-54": {
"color": "#9efff8",
"title": "-54",
"sortData": -54
},
"-53": {
"color": "#e7f7ff",
"title": "-53",
"sortData": -53
},
"-52": {
"color": "#aec0e0",
"title": "-52",
"sortData": -52
},
"-51": {
"color": "#ffb296",
"title": "-51",
"sortData": -51
},
"-50": {
"color": "#ffe398",
"title": "-50",
"sortData": -50
},
"-49": {
"color": "#9efff8",
"title": "-49",
"sortData": -49
},
"-48": {
"color": "#e7f7ff",
"title": "-48",
"sortData": -48
},
"-47": {
"color": "#aec0e0",
"title": "-47",
"sortData": -47
},
"-46": {
"color": "#ffb296",
"title": "-46",
"sortData": -46
},
"-45": {
"color": "#ffe398",
"title": "-45",
"sortData": -45
},
"-44": {
"color": "#9efff8",
"title": "-44",
"sortData": -44
},
"-43": {
"color": "#e7f7ff",
"title": "-43",
"sortData": -43,
"inResultset": true
},
"-42": {
"color": "#aec0e0",
"title": "-42",
"sortData": -42,
"inResultset": true
},
"-41": {
"color": "#ffb296",
"title": "-41",
"sortData": -41,
"inResultset": true
},
"-40": {
"color": "#ffe398",
"title": "-40",
"sortData": -40,
"inResultset": true
},
"-39": {
"color": "#9efff8",
"title": "-39",
"sortData": -39,
"inResultset": true
},
"-38": {
"color": "#e7f7ff",
"title": "-38",
"sortData": -38,
"inResultset": true
},
"-37": {
"color": "#aec0e0",
"title": "-37",
"sortData": -37,
"inResultset": true
},
"-36": {
"color": "#ffb296",
"title": "-36",
"sortData": -36,
"inResultset": true
},
"-35": {
"color": "#ffe398",
"title": "-35",
"sortData": -35,
"inResultset": true
},
"-34": {
"color": "#9efff8",
"title": "-34",
"sortData": -34,
"inResultset": true
},
"-33": {
"color": "#e7f7ff",
"title": "-33",
"sortData": -33,
"inResultset": true
},
"-32": {
"color": "#aec0e0",
"title": "-32",
"sortData": -32,
"inResultset": true
},
"-31": {
"color": "#ffb296",
"title": "-31",
"sortData": -31,
"inResultset": true
},
"-30": {
"color": "#ffe398",
"title": "-30",
"sortData": -30,
"inResultset": true
},
"-29": {
"color": "#9efff8",
"title": "-29",
"sortData": -29,
"inResultset": true
},
"-28": {
"color": "#e7f7ff",
"title": "-28",
"sortData": -28,
"inResultset": true
},
"-27": {
"color": "#aec0e0",
"title": "-27",
"sortData": -27,
"inResultset": true
},
"-26": {
"color": "#ffb296",
"title": "-26",
"sortData": -26,
"inResultset": true
},
"-25": {
"color": "#ffe398",
"title": "-25",
"sortData": -25,
"inResultset": true
},
"-24": {
"color": "#9efff8",
"title": "-24",
"sortData": -24,
"inResultset": true
},
"-23": {
"color": "#e7f7ff",
"title": "-23",
"sortData": -23,
"inResultset": true
},
"-22": {
"color": "#aec0e0",
"title": "-22",
"sortData": -22,
"inResultset": true
},
"-21": {
"color": "#ffb296",
"title": "-21",
"sortData": -21,
"inResultset": true
},
"-20": {
"color": "#ffe398",
"title": "-20",
"sortData": -20,
"inResultset": true
},
"-19": {
"color": "#9efff8",
"title": "-19",
"sortData": -19,
"inResultset": true
},
"-18": {
"color": "#e7f7ff",
"title": "-18",
"sortData": -18,
"inResultset": true
},
"-17": {
"color": "#aec0e0",
"title": "-17",
"sortData": -17,
"inResultset": true
},
"-16": {
"color": "#ffb296",
"title": "-16",
"sortData": -16,
"inResultset": true
},
"-15": {
"color": "#ffe398",
"title": "-15",
"sortData": -15,
"inResultset": true
},
"-14": {
"color": "#9efff8",
"title": "-14",
"sortData": -14,
"inResultset": true
},
"-13": {
"color": "#e7f7ff",
"title": "-13",
"sortData": -13,
"inResultset": true
},
"-12": {
"color": "#aec0e0",
"title": "-12",
"sortData": -12,
"inResultset": true
},
"-11": {
"color": "#ffb296",
"title": "-11",
"sortData": -11,
"inResultset": true
},
"-10": {
"color": "#ffe398",
"title": "-10",
"sortData": -10,
"inResultset": true
},
"-9": {
"color": "#9efff8",
"title": "-9",
"sortData": -9,
"inResultset": true
},
"-8": {
"color": "#e7f7ff",
"title": "-8",
"sortData": -8,
"inResultset": true
},
"-7": {
"color": "#aec0e0",
"title": "-7",
"sortData": -7,
"inResultset": true
},
"-6": {
"color": "#ffb296",
"title": "-6",
"sortData": -6,
"inResultset": true
},
"-5": {
"color": "#ffe398",
"title": "-5",
"sortData": -5,
"inResultset": true
},
"-4": {
"color": "#9efff8",
"title": "-4",
"sortData": -4,
"inResultset": true
},
"-3": {
"color": "#e7f7ff",
"title": "-3",
"sortData": -3,
"inResultset": true
},
"-2": {
"color": "#aec0e0",
"title": "-2",
"sortData": -2,
"inResultset": true
},
"-1": {
"color": "#ffb296",
"title": "-1",
"sortData": -1,
"inResultset": true
}
}
},
"field": {
"id": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"context": {
"[4FB6E-8F7]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[82A87-9F3]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[5EADC-394]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[742BE-3CB]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "FY 2022",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"type": "color",
"color": "#fa7240"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(rsum(([19D74-CE0],[BFEC1-619]))/3) /( ( [19D74-CE0], all([345F3-8BC]), [BFEC1-619])/3)",
"context": {
"[345F3-8BC]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[19D74-CE0]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[BFEC1-619]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2018",
"2019",
"2020"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Pre-pandemic"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"type": "color",
"color": "#60c2bb"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([19D74-CE0],[BFEC1-619]))/3) /( ( [19D74-CE0], all([345F3-8BC]), [BFEC1-619])/3)",
"index": 2
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance (1)",
"filter": {
"toNotEqual": "1"
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"disabled": false
}
]
}
]
},
"oid": "620ead282df9e61f384395f7",
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "order_weeks_prior_to_performance",
"title": "Order Weeks Prior to Performance",
"singular": "Order Weeks Prior to Performance",
"plural": "Order Weeks Prior to Performance"
},
{
"id": "order_weeks_prior_to_performance_(1)",
"title": "Order Weeks Prior to Performance (1)",
"singular": "Order Weeks Prior to Performance (1)",
"plural": "Order Weeks Prior to Performance (1)"
}
]
}
},
"instanceid": "4DB4D-EA38-51",
"queryStartTime": "2022-02-17T15:20:13",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\nwidget.on('render', function(scope, args) {\n args.widget.options.previousScrollerLocation.min = 0;\n args.widget.options.previousScrollerLocation.max = 25;\n});",
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "620eadcc2df9e61f38439654",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"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": "Order Weeks Prior to Performance
Subscription vs. Single vs. Group Tickets | Seats and Tickets
",
"vAlign": "valign-middle",
"bgColor": "#656d72",
"textAlign": "center"
}
},
"instanceid": "C1700-D789-A4",
"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,
"dashboardid": "620ead282df9e61f384395e4",
"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": "Tickets by Order Weeks Prior to Performance (filters within formulas)",
"subtype": "line/basic",
"oid": "620eadd22df9e61f38439659",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"format": {
"members": {
"0": {
"color": "#ffe398",
"title": "0",
"sortData": 0,
"inResultset": true
},
"1": {
"color": "#9efff8",
"title": "1",
"sortData": 1
},
"2": {
"color": "#e7f7ff",
"title": "2",
"sortData": 2
},
"3": {
"color": "#aec0e0",
"title": "3",
"sortData": 3
},
"4": {
"color": "#aec0e0",
"title": "4",
"sortData": 4
},
"9": {
"color": "#9efff8",
"title": "9",
"sortData": 9
},
"16": {
"color": "#e7f7ff",
"title": "16",
"sortData": 16
},
"22": {
"color": "#ffb296",
"title": "22",
"sortData": 22
},
"28": {
"color": "#ffe398",
"title": "28",
"sortData": 28
},
"-132": {
"color": "#60C2BB",
"title": "-132",
"sortData": -132
},
"-131": {
"color": "#94A1A8",
"title": "-131",
"sortData": -131
},
"-130": {
"color": "#6E798D",
"title": "-130",
"sortData": -130
},
"-129": {
"color": "#FA7240",
"title": "-129",
"sortData": -129
},
"-128": {
"color": "#E2BA50",
"title": "-128",
"sortData": -128
},
"-127": {
"color": "#6edfd7",
"title": "-127",
"sortData": -127
},
"-126": {
"color": "#aab9c1",
"title": "-126",
"sortData": -126
},
"-125": {
"color": "#7f8ba2",
"title": "-125",
"sortData": -125
},
"-124": {
"color": "#ff8255",
"title": "-124",
"sortData": -124
},
"-123": {
"color": "#ffd35d",
"title": "-123",
"sortData": -123
},
"-122": {
"color": "#77f0e7",
"title": "-122",
"sortData": -122
},
"-121": {
"color": "#b7c7cf",
"title": "-121",
"sortData": -121
},
"-118": {
"color": "#8895ae",
"title": "-118",
"sortData": -118
},
"-117": {
"color": "#ff8c61",
"title": "-117",
"sortData": -117
},
"-116": {
"color": "#ffd669",
"title": "-116",
"sortData": -116
},
"-114": {
"color": "#7ffff6",
"title": "-114",
"sortData": -114
},
"-113": {
"color": "#c3d5de",
"title": "-113",
"sortData": -113
},
"-112": {
"color": "#91a0ba",
"title": "-112",
"sortData": -112
},
"-110": {
"color": "#ff956e",
"title": "-110",
"sortData": -110
},
"-109": {
"color": "#ffd974",
"title": "-109",
"sortData": -109
},
"-108": {
"color": "#87fff6",
"title": "-108",
"sortData": -108
},
"-107": {
"color": "#cddfe9",
"title": "-107",
"sortData": -107
},
"-106": {
"color": "#99a8c4",
"title": "-106",
"sortData": -106
},
"-105": {
"color": "#ff9c78",
"title": "-105",
"sortData": -105
},
"-104": {
"color": "#ffdb7d",
"title": "-104",
"sortData": -104
},
"-103": {
"color": "#8cfff7",
"title": "-103",
"sortData": -103
},
"-102": {
"color": "#d5e7f1",
"title": "-102",
"sortData": -102
},
"-101": {
"color": "#9eaecb",
"title": "-101",
"sortData": -101
},
"-100": {
"color": "#ffa27f",
"title": "-100",
"sortData": -100
},
"-99": {
"color": "#ffdd84",
"title": "-99",
"sortData": -99
},
"-98": {
"color": "#91fff7",
"title": "-98",
"sortData": -98
},
"-97": {
"color": "#dbeef8",
"title": "-97",
"sortData": -97
},
"-96": {
"color": "#a2b3d0",
"title": "-96",
"sortData": -96
},
"-95": {
"color": "#ffa685",
"title": "-95",
"sortData": -95
},
"-94": {
"color": "#ffdf89",
"title": "-94",
"sortData": -94
},
"-93": {
"color": "#95fff7",
"title": "-93",
"sortData": -93
},
"-92": {
"color": "#dff3fe",
"title": "-92",
"sortData": -92
},
"-91": {
"color": "#a6b7d5",
"title": "-91",
"sortData": -91
},
"-90": {
"color": "#ffaa8a",
"title": "-90",
"sortData": -90
},
"-89": {
"color": "#ffe08e",
"title": "-89",
"sortData": -89
},
"-88": {
"color": "#98fff8",
"title": "-88",
"sortData": -88
},
"-87": {
"color": "#e3f5ff",
"title": "-87",
"sortData": -87
},
"-86": {
"color": "#a9bad9",
"title": "-86",
"sortData": -86
},
"-85": {
"color": "#ffad8f",
"title": "-85",
"sortData": -85
},
"-84": {
"color": "#ffe192",
"title": "-84",
"sortData": -84
},
"-83": {
"color": "#9bfff8",
"title": "-83",
"sortData": -83
},
"-82": {
"color": "#e5f6ff",
"title": "-82",
"sortData": -82
},
"-81": {
"color": "#acbddc",
"title": "-81",
"sortData": -81
},
"-80": {
"color": "#ffb092",
"title": "-80",
"sortData": -80
},
"-79": {
"color": "#ffe295",
"title": "-79",
"sortData": -79
},
"-78": {
"color": "#9efff8",
"title": "-78",
"sortData": -78
},
"-77": {
"color": "#e7f7ff",
"title": "-77",
"sortData": -77
},
"-76": {
"color": "#aec0e0",
"title": "-76",
"sortData": -76
},
"-75": {
"color": "#ffb296",
"title": "-75",
"sortData": -75
},
"-74": {
"color": "#ffe398",
"title": "-74",
"sortData": -74
},
"-73": {
"color": "#e7f7ff",
"title": "-73",
"sortData": -73
},
"-72": {
"color": "#aec0e0",
"title": "-72",
"sortData": -72
},
"-71": {
"color": "#ffb296",
"title": "-71",
"sortData": -71
},
"-70": {
"color": "#ffe398",
"title": "-70",
"sortData": -70
},
"-69": {
"color": "#9efff8",
"title": "-69",
"sortData": -69
},
"-68": {
"color": "#e7f7ff",
"title": "-68",
"sortData": -68
},
"-67": {
"color": "#aec0e0",
"title": "-67",
"sortData": -67
},
"-66": {
"color": "#ffb296",
"title": "-66",
"sortData": -66
},
"-65": {
"color": "#ffe398",
"title": "-65",
"sortData": -65
},
"-64": {
"color": "#9efff8",
"title": "-64",
"sortData": -64
},
"-63": {
"color": "#e7f7ff",
"title": "-63",
"sortData": -63
},
"-62": {
"color": "#aec0e0",
"title": "-62",
"sortData": -62
},
"-61": {
"color": "#ffb296",
"title": "-61",
"sortData": -61
},
"-60": {
"color": "#ffe398",
"title": "-60",
"sortData": -60
},
"-59": {
"color": "#9efff8",
"title": "-59",
"sortData": -59
},
"-58": {
"color": "#e7f7ff",
"title": "-58",
"sortData": -58
},
"-57": {
"color": "#aec0e0",
"title": "-57",
"sortData": -57
},
"-56": {
"color": "#ffb296",
"title": "-56",
"sortData": -56
},
"-55": {
"color": "#ffe398",
"title": "-55",
"sortData": -55
},
"-54": {
"color": "#9efff8",
"title": "-54",
"sortData": -54
},
"-53": {
"color": "#e7f7ff",
"title": "-53",
"sortData": -53
},
"-52": {
"color": "#aec0e0",
"title": "-52",
"sortData": -52
},
"-51": {
"color": "#ffb296",
"title": "-51",
"sortData": -51
},
"-50": {
"color": "#ffe398",
"title": "-50",
"sortData": -50
},
"-49": {
"color": "#9efff8",
"title": "-49",
"sortData": -49
},
"-48": {
"color": "#e7f7ff",
"title": "-48",
"sortData": -48
},
"-47": {
"color": "#aec0e0",
"title": "-47",
"sortData": -47
},
"-46": {
"color": "#ffb296",
"title": "-46",
"sortData": -46
},
"-45": {
"color": "#ffe398",
"title": "-45",
"sortData": -45
},
"-44": {
"color": "#9efff8",
"title": "-44",
"sortData": -44
},
"-43": {
"color": "#e7f7ff",
"title": "-43",
"sortData": -43,
"inResultset": true
},
"-42": {
"color": "#aec0e0",
"title": "-42",
"sortData": -42,
"inResultset": true
},
"-41": {
"color": "#ffb296",
"title": "-41",
"sortData": -41,
"inResultset": true
},
"-40": {
"color": "#ffe398",
"title": "-40",
"sortData": -40,
"inResultset": true
},
"-39": {
"color": "#9efff8",
"title": "-39",
"sortData": -39,
"inResultset": true
},
"-38": {
"color": "#e7f7ff",
"title": "-38",
"sortData": -38,
"inResultset": true
},
"-37": {
"color": "#aec0e0",
"title": "-37",
"sortData": -37,
"inResultset": true
},
"-36": {
"color": "#ffb296",
"title": "-36",
"sortData": -36,
"inResultset": true
},
"-35": {
"color": "#ffe398",
"title": "-35",
"sortData": -35,
"inResultset": true
},
"-34": {
"color": "#9efff8",
"title": "-34",
"sortData": -34,
"inResultset": true
},
"-33": {
"color": "#e7f7ff",
"title": "-33",
"sortData": -33,
"inResultset": true
},
"-32": {
"color": "#aec0e0",
"title": "-32",
"sortData": -32,
"inResultset": true
},
"-31": {
"color": "#ffb296",
"title": "-31",
"sortData": -31,
"inResultset": true
},
"-30": {
"color": "#ffe398",
"title": "-30",
"sortData": -30,
"inResultset": true
},
"-29": {
"color": "#9efff8",
"title": "-29",
"sortData": -29,
"inResultset": true
},
"-28": {
"color": "#e7f7ff",
"title": "-28",
"sortData": -28,
"inResultset": true
},
"-27": {
"color": "#aec0e0",
"title": "-27",
"sortData": -27,
"inResultset": true
},
"-26": {
"color": "#ffb296",
"title": "-26",
"sortData": -26,
"inResultset": true
},
"-25": {
"color": "#ffe398",
"title": "-25",
"sortData": -25,
"inResultset": true
},
"-24": {
"color": "#9efff8",
"title": "-24",
"sortData": -24,
"inResultset": true
},
"-23": {
"color": "#e7f7ff",
"title": "-23",
"sortData": -23,
"inResultset": true
},
"-22": {
"color": "#aec0e0",
"title": "-22",
"sortData": -22,
"inResultset": true
},
"-21": {
"color": "#ffb296",
"title": "-21",
"sortData": -21,
"inResultset": true
},
"-20": {
"color": "#ffe398",
"title": "-20",
"sortData": -20,
"inResultset": true
},
"-19": {
"color": "#9efff8",
"title": "-19",
"sortData": -19,
"inResultset": true
},
"-18": {
"color": "#e7f7ff",
"title": "-18",
"sortData": -18,
"inResultset": true
},
"-17": {
"color": "#aec0e0",
"title": "-17",
"sortData": -17,
"inResultset": true
},
"-16": {
"color": "#ffb296",
"title": "-16",
"sortData": -16,
"inResultset": true
},
"-15": {
"color": "#ffe398",
"title": "-15",
"sortData": -15,
"inResultset": true
},
"-14": {
"color": "#9efff8",
"title": "-14",
"sortData": -14,
"inResultset": true
},
"-13": {
"color": "#e7f7ff",
"title": "-13",
"sortData": -13,
"inResultset": true
},
"-12": {
"color": "#aec0e0",
"title": "-12",
"sortData": -12,
"inResultset": true
},
"-11": {
"color": "#ffb296",
"title": "-11",
"sortData": -11,
"inResultset": true
},
"-10": {
"color": "#ffe398",
"title": "-10",
"sortData": -10,
"inResultset": true
},
"-9": {
"color": "#9efff8",
"title": "-9",
"sortData": -9,
"inResultset": true
},
"-8": {
"color": "#e7f7ff",
"title": "-8",
"sortData": -8,
"inResultset": true
},
"-7": {
"color": "#aec0e0",
"title": "-7",
"sortData": -7,
"inResultset": true
},
"-6": {
"color": "#ffb296",
"title": "-6",
"sortData": -6,
"inResultset": true
},
"-5": {
"color": "#ffe398",
"title": "-5",
"sortData": -5,
"inResultset": true
},
"-4": {
"color": "#9efff8",
"title": "-4",
"sortData": -4,
"inResultset": true
},
"-3": {
"color": "#e7f7ff",
"title": "-3",
"sortData": -3,
"inResultset": true
},
"-2": {
"color": "#aec0e0",
"title": "-2",
"sortData": -2,
"inResultset": true
},
"-1": {
"color": "#ffb296",
"title": "-1",
"sortData": -1,
"inResultset": true
}
}
},
"field": {
"id": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(rsum(([15F27-876],[7773E-4A5]))) / ( [15F27-876], all([071E4-6E1]), [7773E-4A5])",
"context": {
"[071E4-6E1]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[15F27-876]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[2647D-FF3]": {
"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": [
"Single"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[7773E-4A5]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "FilterSingleTickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Single"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Single Tickets"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"type": "color",
"color": "#fa7240"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(rsum(([FA5F9-997],[949DF-C0C]))) / ( [FA5F9-997], all([F726F-A14]), [949DF-C0C])",
"context": {
"[F726F-A14]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[FA5F9-997]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[949DF-C0C]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "FilterSubscriptionTickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Subscription"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[DFAAB-382]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Subscription Tickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Subscription"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Subscription Tickets"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"type": "color",
"color": "#60c2bb"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(rsum(([918F5-123],[C3338-05D]))) / ( [918F5-123], all([C46CC-1CB]), [C3338-05D])",
"context": {
"[C46CC-1CB]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[918F5-123]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[C3338-05D]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "FilterGroupTickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Group"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[86B1B-375]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "GroupTickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Group"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Group Tickets"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#6E798D",
"type": "color"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"index": 1
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance (1)",
"filter": {
"toNotEqual": "1"
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"disabled": false
}
]
}
]
},
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "order_weeks_prior_to_performance",
"title": "Order Weeks Prior to Performance",
"singular": "Order Weeks Prior to Performance",
"plural": "Order Weeks Prior to Performance"
},
{
"id": "order_weeks_prior_to_performance_(1)",
"title": "Order Weeks Prior to Performance (1)",
"singular": "Order Weeks Prior to Performance (1)",
"plural": "Order Weeks Prior to Performance (1)"
}
]
}
},
"instanceid": "4DB4D-EA38-51",
"queryStartTime": "2022-02-18T10:17:43",
"disableSelctor": false,
"widgetTimingLoged": true,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\nwidget.on('render', function(scope, args) {\n args.widget.options.previousScrollerLocation.min = 0;\n args.widget.options.previousScrollerLocation.max = 25;\n});",
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "620eaf132df9e61f384396a3",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"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": "Days Since Campaign Start
New vs. Renew vs. Reinstate | Contributions
",
"vAlign": "valign-middle",
"bgColor": "#656d72",
"textAlign": "center"
}
},
"instanceid": "C1700-D789-A4",
"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,
"dashboardid": "620ead282df9e61f384395e4",
"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": "Contributions by Days Since Campaign Start",
"subtype": "line/basic",
"oid": "620ebe912df9e61f38439a1d",
"desc": null,
"source": null,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "CONTRIBUTION DETAILS",
"column": "Weeks Since Campaign Start",
"dim": "[CONTRIBUTION.Weeks Since Campaign Start]",
"datatype": "numeric",
"title": "Weeks Since Campaign Start",
"sortDetails": {
"field": 0,
"dir": "asc",
"sortingLastDimension": true,
"measurePath": null,
"initialized": true
}
},
"field": {
"id": "[CONTRIBUTION.Weeks Since Campaign Start]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "rsum( ( [DC766-0AC], [237E5-E2B]), true) / ( [DC766-0AC], all ( [6FA81-A2E]), [237E5-E2B])",
"context": {
"[237E5-E2B]": {
"table": "MEMBERSHIP",
"column": "Membership New/Renew/Reinstate Status",
"dim": "[MEMBERSHIP.Membership New/Renew/Reinstate Status]",
"datatype": "text",
"merged": true,
"title": "Membership New/Renew/Reinstate Status",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"NE"
]
},
"collapsed": false,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"[A62F5-224]": {
"table": "MEMBERSHIP",
"column": "Membership New/Renew/Reinstate Status",
"dim": "[MEMBERSHIP.Membership New/Renew/Reinstate Status]",
"datatype": "text",
"merged": true,
"title": "Membership New/Renew/Reinstate Status",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"RN"
]
},
"collapsed": false,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"[6FA81-A2E]": {
"table": "CONTRIBUTION DETAILS",
"column": "Weeks Since Campaign Start",
"dim": "[CONTRIBUTION.Weeks Since Campaign Start]",
"datatype": "numeric",
"title": "Weeks Since Campaign Start"
},
"[DC766-0AC]": {
"table": "CONTRIBUTION VALUES",
"column": "Contribution Count",
"dim": "[CONTRIBUTION VALUES.Contribution Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Contribution Count"
}
},
"title": "New Acquisitions"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
},
"field": {
"id": "rsum( ( [DC766-0AC], [237E5-E2B]), true) / ( [DC766-0AC], all ( [6FA81-A2E]), [237E5-E2B])",
"index": 1
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "rsum( ( [8A242-463], [795ED-722]), true) / ( [8A242-463], all ( [B6055-5F7]), [795ED-722])",
"context": {
"[8C0C8-6F3]": {
"table": "MEMBERSHIP",
"column": "Membership New/Renew/Reinstate Status",
"dim": "[MEMBERSHIP.Membership New/Renew/Reinstate Status]",
"datatype": "text",
"merged": true,
"title": "Membership New/Renew/Reinstate Status",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"RI"
]
},
"collapsed": false,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"[795ED-722]": {
"table": "MEMBERSHIP",
"column": "Membership New/Renew/Reinstate Status",
"dim": "[MEMBERSHIP.Membership New/Renew/Reinstate Status]",
"datatype": "text",
"merged": true,
"title": "Membership New/Renew/Reinstate Status",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"RI",
"RN"
]
},
"collapsed": false,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"[B6055-5F7]": {
"table": "CONTRIBUTION DETAILS",
"column": "Weeks Since Campaign Start",
"dim": "[CONTRIBUTION.Weeks Since Campaign Start]",
"datatype": "numeric",
"title": "Weeks Since Campaign Start"
},
"[8A242-463]": {
"table": "CONTRIBUTION VALUES",
"column": "Contribution Count",
"dim": "[CONTRIBUTION VALUES.Contribution Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Contribution Count"
}
},
"title": "Renewal or Reinstated"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "#fa7240"
}
},
"field": {
"id": "rsum( ( [8A242-463], [795ED-722]), true) / ( [8A242-463], all ( [B6055-5F7]), [795ED-722])",
"index": 2
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SOURCE",
"column": "Appeal",
"dim": "[SOURCE.Appeal1]",
"datatype": "text",
"merged": true,
"title": "Appeal",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BTd22 Holiday Giving"
]
},
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions"
},
"collapsed": true
},
"disabled": true
},
{
"jaql": {
"table": "CAMPAIGN",
"column": "Campaign",
"dim": "[CAMPAIGN.Campaign1]",
"datatype": "text",
"merged": true,
"title": "Campaign",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BTd21 Individual"
]
},
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions"
},
"collapsed": true
},
"disabled": false
}
]
}
]
},
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "weeks_since_campaign_start",
"title": "Weeks Since Campaign Start",
"singular": "Weeks Since Campaign Start",
"plural": "Weeks Since Campaign Start"
},
{
"id": "appeal",
"title": "Appeal",
"singular": "Appeal",
"plural": "Appeal"
},
{
"id": "campaign",
"title": "Campaign",
"singular": "Campaign",
"plural": "Campaign"
}
]
}
},
"instanceid": "74AB0-02C5-9D",
"queryStartTime": "2022-02-18T09:17:57",
"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,
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "design"
},
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "Contributions by Date for Holiday Appeal",
"subtype": "line/basic",
"oid": "620fa65413cfd63b84367237",
"desc": null,
"source": null,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "CONTRIBUTION DATE",
"column": "Date",
"dim": "[CONTRIBUTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
},
"format": {
"mask": {
"years": "yyyy",
"quarters": "yyyy Q",
"months": "MM/yyyy",
"weeks": "ww yyyy",
"days": "shortDate",
"minutes": "HH:mm",
"isdefault": true
}
},
"hierarchies": [
"calendar",
"calendar - weeks"
],
"disabled": false
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "rsum( ( [B84F3-A2A], [EF54B-21F]), true) / ( [B84F3-A2A], all ( [0E87F-CA7]), [EF54B-21F])",
"context": {
"[B84F3-A2A]": {
"table": "CONTRIBUTION VALUES",
"column": "Contribution Count",
"dim": "[CONTRIBUTION VALUES.Contribution Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Contribution Count"
},
"[0E87F-CA7]": {
"table": "CONTRIBUTION DATE",
"column": "Date",
"dim": "[CONTRIBUTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
},
"[EF54B-21F]": {
"table": "SOURCE",
"column": "Source Group",
"dim": "[SOURCE.Source Group1]",
"datatype": "text",
"merged": true,
"title": "Source Group"
}
},
"title": "Proportion to Date"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
}
},
"field": {
"id": "rsum( ( [DC766-0AC], [237E5-E2B]), true) / ( [DC766-0AC], all ( [6FA81-A2E]), [237E5-E2B])",
"index": 1
},
"disabled": false
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "SOURCE",
"column": "Source Group",
"dim": "[SOURCE.Source Group1]",
"datatype": "text",
"merged": true,
"title": "Source Group"
},
"format": {
"members": {
"Lapsed Donors": {
"color": "#60C2BB",
"title": "Lapsed Donors",
"sortData": "Lapsed Donors",
"inResultset": true
},
"Current Donors": {
"color": "#94A1A8",
"title": "Current Donors",
"sortData": "Current Donors"
},
"New Acquisition": {
"color": "#6E798D",
"title": "New Acquisition",
"sortData": "New Acquisition",
"inResultset": true
},
"Renewal Notices": {
"color": "#FA7240",
"title": "Renewal Notices",
"sortData": "Renewal Notices",
"inResultset": true
},
"Mixed": {
"color": "#E2BA50",
"title": "Mixed",
"sortData": "Mixed"
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SOURCE",
"column": "Appeal",
"dim": "[SOURCE.Appeal1]",
"datatype": "text",
"merged": true,
"title": "Appeal",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BTd21 Holiday Giving"
]
},
"collapsed": true,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"disabled": false
},
{
"jaql": {
"table": "SOURCE",
"column": "Source Group",
"dim": "[SOURCE.Source Group1]",
"datatype": "text",
"merged": true,
"title": "Source Group",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"New Acquisition",
"Lapsed Donors",
"Renewal Notices"
]
},
"collapsed": true,
"datasource": {
"title": "Contributions",
"fullname": "hestia.tessitura.cd.local/Contributions",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aCONTRIBUTIONS",
"address": "hestia.tessitura.cd.local",
"database": "aContributions",
"lastBuildTime": "2022-02-17T04:22:33"
}
},
"title": "Source Group"
}
]
}
]
},
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "source_group",
"title": "Source Group",
"singular": "Source Group",
"plural": "Source Group"
},
{
"id": "appeal",
"title": "Appeal",
"singular": "Appeal",
"plural": "Appeal"
}
]
}
},
"instanceid": "74AB0-02C5-9D",
"queryStartTime": "2022-02-18T10:10:38",
"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,
"forcedRedraw": false,
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true,
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\nwidget.on(\"beforeviewloaded\",function(scope, args){args.options.plotOptions.series.connectNulls = true;});",
"canEditFilters": true,
"minDate": 1607922000000,
"maxDate": 1609822800000,
"tickInterval": 86400000,
"tickLevel": "day"
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "620fb09513cfd63b84367402",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"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": "Contribution Date for Limited-Time Appeal
Source Group | Contributions
",
"vAlign": "valign-middle",
"bgColor": "#656d72",
"textAlign": "center"
}
},
"instanceid": "C1700-D789-A4",
"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,
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "620fb76013cfd63b8436754a",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets",
"lastBuildTime": "2022-02-01T04:49:35"
},
"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": "Days Since Campaign Start by Membership NRR Status
New, Renew, Reinstate | Memberships
",
"vAlign": "valign-middle",
"bgColor": "#656d72",
"textAlign": "center"
}
},
"instanceid": "C1700-D789-A4",
"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,
"dashboardid": "620ead282df9e61f384395e4",
"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": "Days Since Campaign Start for Memberships",
"subtype": "line/basic",
"oid": "620fb85613cfd63b8436758a",
"desc": null,
"source": null,
"datasource": {
"title": "Memberships",
"fullname": "hestia.tessitura.cd.local/Memberships",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aMEMBERSHIPS",
"address": "hestia.tessitura.cd.local",
"database": "aMemberships",
"lastBuildTime": "2022-02-18T04:06:31"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "MEMBERSHIP DETAILS",
"column": "Days Since Campaign Start",
"dim": "[MEMBERSHIP DETAILS.Days Since Campaign Start]",
"datatype": "numeric",
"title": "Days Since Campaign Start"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "rsum([9E2E4-147], true) / ([9E2E4-147], all([05AE7-E36]))",
"context": {
"[05AE7-E36]": {
"table": "MEMBERSHIP DETAILS",
"column": "Days Since Campaign Start",
"dim": "[MEMBERSHIP DETAILS.Days Since Campaign Start]",
"datatype": "numeric",
"title": "Days Since Campaign Start"
},
"[9E2E4-147]": {
"table": "MEMBERSHIP VALUES",
"column": "Membership Count",
"dim": "[MEMBERSHIP VALUES.Membership Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Membership Count"
}
},
"title": "Formula"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "MEMBERSHIP DETAILS",
"column": "New/Renew/Reinstate Status",
"dim": "[MEMBERSHIP DETAILS.New/Renew/Reinstate Status]",
"datatype": "text",
"merged": true,
"title": "New/Renew/Reinstate Status"
},
"format": {
"members": {
"New": {
"color": "#60C2BB",
"title": "New",
"sortData": "New",
"inResultset": true
},
"Reinstated": {
"color": "#94A1A8",
"title": "Reinstated",
"sortData": "Reinstated",
"inResultset": true
},
"Renewed": {
"color": "#6E798D",
"title": "Renewed",
"sortData": "Renewed",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CAMPAIGN",
"column": "Campaign",
"dim": "[CAMPAIGN.Campaign1]",
"datatype": "text",
"merged": true,
"title": "Campaign",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BTd21 Individual"
]
},
"collapsed": true,
"datasource": {
"title": "Memberships",
"fullname": "hestia.tessitura.cd.local/Memberships",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aMEMBERSHIPS",
"address": "hestia.tessitura.cd.local",
"database": "aMemberships"
}
}
}
]
}
]
},
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "days_since_campaign_start",
"title": "Days Since Campaign Start",
"singular": "Days Since Campaign Start",
"plural": "Days Since Campaign Start"
},
{
"id": "new/renew/reinstate_status",
"title": "New/Renew/Reinstate Status",
"singular": "New/Renew/Reinstate Status",
"plural": "New/Renew/Reinstate Status"
},
{
"id": "campaign",
"title": "Campaign",
"singular": "Campaign",
"plural": "Campaign"
}
]
}
},
"instanceid": "B746F-3A1B-81",
"queryStartTime": "2022-02-18T10:17:43",
"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
},
"widgetTimingLoged": false,
"drawing": true,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"viewState": {
"activeTab": "design"
},
"realTimeRefreshing": false,
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 164
}
},
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/widget.on(\"beforeviewloaded\",function(scope, args){\nargs.options.plotOptions.series.connectNulls = true;\n});",
"canEditFilters": true
},
{
"title": "Tickets by Order Weeks Prior to Performance (using break by)",
"subtype": "line/basic",
"oid": "620fb90313cfd63b843675db",
"desc": null,
"source": null,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "x-axis",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"format": {
"members": {
"0": {
"color": "#ffe398",
"title": "0",
"sortData": 0,
"inResultset": true
},
"1": {
"color": "#9efff8",
"title": "1",
"sortData": 1
},
"2": {
"color": "#e7f7ff",
"title": "2",
"sortData": 2
},
"3": {
"color": "#aec0e0",
"title": "3",
"sortData": 3
},
"4": {
"color": "#aec0e0",
"title": "4",
"sortData": 4
},
"9": {
"color": "#9efff8",
"title": "9",
"sortData": 9
},
"16": {
"color": "#e7f7ff",
"title": "16",
"sortData": 16
},
"22": {
"color": "#ffb296",
"title": "22",
"sortData": 22
},
"28": {
"color": "#ffe398",
"title": "28",
"sortData": 28
},
"-132": {
"color": "#60C2BB",
"title": "-132",
"sortData": -132
},
"-131": {
"color": "#94A1A8",
"title": "-131",
"sortData": -131
},
"-130": {
"color": "#6E798D",
"title": "-130",
"sortData": -130
},
"-129": {
"color": "#FA7240",
"title": "-129",
"sortData": -129
},
"-128": {
"color": "#E2BA50",
"title": "-128",
"sortData": -128
},
"-127": {
"color": "#6edfd7",
"title": "-127",
"sortData": -127
},
"-126": {
"color": "#aab9c1",
"title": "-126",
"sortData": -126
},
"-125": {
"color": "#7f8ba2",
"title": "-125",
"sortData": -125
},
"-124": {
"color": "#ff8255",
"title": "-124",
"sortData": -124
},
"-123": {
"color": "#ffd35d",
"title": "-123",
"sortData": -123
},
"-122": {
"color": "#77f0e7",
"title": "-122",
"sortData": -122
},
"-121": {
"color": "#b7c7cf",
"title": "-121",
"sortData": -121
},
"-118": {
"color": "#8895ae",
"title": "-118",
"sortData": -118
},
"-117": {
"color": "#ff8c61",
"title": "-117",
"sortData": -117
},
"-116": {
"color": "#ffd669",
"title": "-116",
"sortData": -116
},
"-114": {
"color": "#7ffff6",
"title": "-114",
"sortData": -114
},
"-113": {
"color": "#c3d5de",
"title": "-113",
"sortData": -113
},
"-112": {
"color": "#91a0ba",
"title": "-112",
"sortData": -112
},
"-110": {
"color": "#ff956e",
"title": "-110",
"sortData": -110
},
"-109": {
"color": "#ffd974",
"title": "-109",
"sortData": -109
},
"-108": {
"color": "#87fff6",
"title": "-108",
"sortData": -108
},
"-107": {
"color": "#cddfe9",
"title": "-107",
"sortData": -107
},
"-106": {
"color": "#99a8c4",
"title": "-106",
"sortData": -106
},
"-105": {
"color": "#ff9c78",
"title": "-105",
"sortData": -105
},
"-104": {
"color": "#ffdb7d",
"title": "-104",
"sortData": -104
},
"-103": {
"color": "#8cfff7",
"title": "-103",
"sortData": -103
},
"-102": {
"color": "#d5e7f1",
"title": "-102",
"sortData": -102
},
"-101": {
"color": "#9eaecb",
"title": "-101",
"sortData": -101
},
"-100": {
"color": "#ffa27f",
"title": "-100",
"sortData": -100
},
"-99": {
"color": "#ffdd84",
"title": "-99",
"sortData": -99
},
"-98": {
"color": "#91fff7",
"title": "-98",
"sortData": -98
},
"-97": {
"color": "#dbeef8",
"title": "-97",
"sortData": -97
},
"-96": {
"color": "#a2b3d0",
"title": "-96",
"sortData": -96
},
"-95": {
"color": "#ffa685",
"title": "-95",
"sortData": -95
},
"-94": {
"color": "#ffdf89",
"title": "-94",
"sortData": -94
},
"-93": {
"color": "#95fff7",
"title": "-93",
"sortData": -93
},
"-92": {
"color": "#dff3fe",
"title": "-92",
"sortData": -92
},
"-91": {
"color": "#a6b7d5",
"title": "-91",
"sortData": -91
},
"-90": {
"color": "#ffaa8a",
"title": "-90",
"sortData": -90
},
"-89": {
"color": "#ffe08e",
"title": "-89",
"sortData": -89
},
"-88": {
"color": "#98fff8",
"title": "-88",
"sortData": -88
},
"-87": {
"color": "#e3f5ff",
"title": "-87",
"sortData": -87
},
"-86": {
"color": "#a9bad9",
"title": "-86",
"sortData": -86
},
"-85": {
"color": "#ffad8f",
"title": "-85",
"sortData": -85
},
"-84": {
"color": "#ffe192",
"title": "-84",
"sortData": -84
},
"-83": {
"color": "#9bfff8",
"title": "-83",
"sortData": -83
},
"-82": {
"color": "#e5f6ff",
"title": "-82",
"sortData": -82
},
"-81": {
"color": "#acbddc",
"title": "-81",
"sortData": -81
},
"-80": {
"color": "#ffb092",
"title": "-80",
"sortData": -80
},
"-79": {
"color": "#ffe295",
"title": "-79",
"sortData": -79
},
"-78": {
"color": "#9efff8",
"title": "-78",
"sortData": -78
},
"-77": {
"color": "#e7f7ff",
"title": "-77",
"sortData": -77
},
"-76": {
"color": "#aec0e0",
"title": "-76",
"sortData": -76
},
"-75": {
"color": "#ffb296",
"title": "-75",
"sortData": -75
},
"-74": {
"color": "#ffe398",
"title": "-74",
"sortData": -74
},
"-73": {
"color": "#e7f7ff",
"title": "-73",
"sortData": -73
},
"-72": {
"color": "#aec0e0",
"title": "-72",
"sortData": -72
},
"-71": {
"color": "#ffb296",
"title": "-71",
"sortData": -71
},
"-70": {
"color": "#ffe398",
"title": "-70",
"sortData": -70
},
"-69": {
"color": "#9efff8",
"title": "-69",
"sortData": -69
},
"-68": {
"color": "#e7f7ff",
"title": "-68",
"sortData": -68
},
"-67": {
"color": "#aec0e0",
"title": "-67",
"sortData": -67
},
"-66": {
"color": "#ffb296",
"title": "-66",
"sortData": -66
},
"-65": {
"color": "#ffe398",
"title": "-65",
"sortData": -65
},
"-64": {
"color": "#9efff8",
"title": "-64",
"sortData": -64
},
"-63": {
"color": "#e7f7ff",
"title": "-63",
"sortData": -63
},
"-62": {
"color": "#aec0e0",
"title": "-62",
"sortData": -62
},
"-61": {
"color": "#ffb296",
"title": "-61",
"sortData": -61
},
"-60": {
"color": "#ffe398",
"title": "-60",
"sortData": -60
},
"-59": {
"color": "#9efff8",
"title": "-59",
"sortData": -59
},
"-58": {
"color": "#e7f7ff",
"title": "-58",
"sortData": -58
},
"-57": {
"color": "#aec0e0",
"title": "-57",
"sortData": -57
},
"-56": {
"color": "#ffb296",
"title": "-56",
"sortData": -56
},
"-55": {
"color": "#ffe398",
"title": "-55",
"sortData": -55
},
"-54": {
"color": "#9efff8",
"title": "-54",
"sortData": -54
},
"-53": {
"color": "#e7f7ff",
"title": "-53",
"sortData": -53
},
"-52": {
"color": "#aec0e0",
"title": "-52",
"sortData": -52
},
"-51": {
"color": "#ffb296",
"title": "-51",
"sortData": -51
},
"-50": {
"color": "#ffe398",
"title": "-50",
"sortData": -50
},
"-49": {
"color": "#9efff8",
"title": "-49",
"sortData": -49
},
"-48": {
"color": "#e7f7ff",
"title": "-48",
"sortData": -48
},
"-47": {
"color": "#aec0e0",
"title": "-47",
"sortData": -47
},
"-46": {
"color": "#ffb296",
"title": "-46",
"sortData": -46
},
"-45": {
"color": "#ffe398",
"title": "-45",
"sortData": -45
},
"-44": {
"color": "#9efff8",
"title": "-44",
"sortData": -44
},
"-43": {
"color": "#e7f7ff",
"title": "-43",
"sortData": -43,
"inResultset": true
},
"-42": {
"color": "#aec0e0",
"title": "-42",
"sortData": -42,
"inResultset": true
},
"-41": {
"color": "#ffb296",
"title": "-41",
"sortData": -41,
"inResultset": true
},
"-40": {
"color": "#ffe398",
"title": "-40",
"sortData": -40,
"inResultset": true
},
"-39": {
"color": "#9efff8",
"title": "-39",
"sortData": -39,
"inResultset": true
},
"-38": {
"color": "#e7f7ff",
"title": "-38",
"sortData": -38,
"inResultset": true
},
"-37": {
"color": "#aec0e0",
"title": "-37",
"sortData": -37,
"inResultset": true
},
"-36": {
"color": "#ffb296",
"title": "-36",
"sortData": -36,
"inResultset": true
},
"-35": {
"color": "#ffe398",
"title": "-35",
"sortData": -35,
"inResultset": true
},
"-34": {
"color": "#9efff8",
"title": "-34",
"sortData": -34,
"inResultset": true
},
"-33": {
"color": "#e7f7ff",
"title": "-33",
"sortData": -33,
"inResultset": true
},
"-32": {
"color": "#aec0e0",
"title": "-32",
"sortData": -32,
"inResultset": true
},
"-31": {
"color": "#ffb296",
"title": "-31",
"sortData": -31,
"inResultset": true
},
"-30": {
"color": "#ffe398",
"title": "-30",
"sortData": -30,
"inResultset": true
},
"-29": {
"color": "#9efff8",
"title": "-29",
"sortData": -29,
"inResultset": true
},
"-28": {
"color": "#e7f7ff",
"title": "-28",
"sortData": -28,
"inResultset": true
},
"-27": {
"color": "#aec0e0",
"title": "-27",
"sortData": -27,
"inResultset": true
},
"-26": {
"color": "#ffb296",
"title": "-26",
"sortData": -26,
"inResultset": true
},
"-25": {
"color": "#ffe398",
"title": "-25",
"sortData": -25,
"inResultset": true
},
"-24": {
"color": "#9efff8",
"title": "-24",
"sortData": -24,
"inResultset": true
},
"-23": {
"color": "#e7f7ff",
"title": "-23",
"sortData": -23,
"inResultset": true
},
"-22": {
"color": "#aec0e0",
"title": "-22",
"sortData": -22,
"inResultset": true
},
"-21": {
"color": "#ffb296",
"title": "-21",
"sortData": -21,
"inResultset": true
},
"-20": {
"color": "#ffe398",
"title": "-20",
"sortData": -20,
"inResultset": true
},
"-19": {
"color": "#9efff8",
"title": "-19",
"sortData": -19,
"inResultset": true
},
"-18": {
"color": "#e7f7ff",
"title": "-18",
"sortData": -18,
"inResultset": true
},
"-17": {
"color": "#aec0e0",
"title": "-17",
"sortData": -17,
"inResultset": true
},
"-16": {
"color": "#ffb296",
"title": "-16",
"sortData": -16,
"inResultset": true
},
"-15": {
"color": "#ffe398",
"title": "-15",
"sortData": -15,
"inResultset": true
},
"-14": {
"color": "#9efff8",
"title": "-14",
"sortData": -14,
"inResultset": true
},
"-13": {
"color": "#e7f7ff",
"title": "-13",
"sortData": -13,
"inResultset": true
},
"-12": {
"color": "#aec0e0",
"title": "-12",
"sortData": -12,
"inResultset": true
},
"-11": {
"color": "#ffb296",
"title": "-11",
"sortData": -11,
"inResultset": true
},
"-10": {
"color": "#ffe398",
"title": "-10",
"sortData": -10,
"inResultset": true
},
"-9": {
"color": "#9efff8",
"title": "-9",
"sortData": -9,
"inResultset": true
},
"-8": {
"color": "#e7f7ff",
"title": "-8",
"sortData": -8,
"inResultset": true
},
"-7": {
"color": "#aec0e0",
"title": "-7",
"sortData": -7,
"inResultset": true
},
"-6": {
"color": "#ffb296",
"title": "-6",
"sortData": -6,
"inResultset": true
},
"-5": {
"color": "#ffe398",
"title": "-5",
"sortData": -5,
"inResultset": true
},
"-4": {
"color": "#9efff8",
"title": "-4",
"sortData": -4,
"inResultset": true
},
"-3": {
"color": "#e7f7ff",
"title": "-3",
"sortData": -3,
"inResultset": true
},
"-2": {
"color": "#aec0e0",
"title": "-2",
"sortData": -2,
"inResultset": true
},
"-1": {
"color": "#ffb296",
"title": "-1",
"sortData": -1,
"inResultset": true
}
}
},
"field": {
"id": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(rsum(([5223D-6D7],[33E91-600]))) / ( [5223D-6D7], all([141C2-BD7]), [33E91-600])",
"context": {
"[141C2-BD7]": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance"
},
"[5223D-6D7]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[33E91-600]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[C25B1-A0E]": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "FilterSingleTickets",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Single"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Single Tickets"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color_bkp": {
"type": "color",
"color": "#fa7240"
}
},
"originalJaql": {
"type": "measure",
"formula": "(rsum(([AB618-9FA],[9CFFC-C67])))",
"context": {
"[AB618-9FA]": {
"type": "measure",
"formula": "[4D334-05D]+[2B61A-315]",
"context": {
"[2B61A-315]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Comp Count",
"dim": "[SEAT & TICKET VALUES.Ticket Comp Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Comp Count"
},
"[4D334-05D]": {
"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": "Ticket Total Paid and Comp"
},
"[9CFFC-C67]": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022"
]
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Reopening"
},
"quickFunction": false,
"disabled": false,
"y2": false,
"field": {
"id": "(rsum(([82A87-9F3],[742BE-3CB]))) / ( [82A87-9F3], all([4FB6E-8F7]), [5EADC-394])",
"index": 1
}
}
]
},
{
"name": "break by",
"items": [
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category"
},
"format": {
"members": {
"Comp": {
"color": "#60C2BB",
"title": "Comp",
"sortData": "Comp"
},
"Subscription": {
"color": "#60c2bb",
"title": "Subscription",
"sortData": "Subscription",
"inResultset": true
},
"Group": {
"color": "#6E798D",
"title": "Group",
"sortData": "Group",
"inResultset": true
},
"Single": {
"color": "#FA7240",
"title": "Single",
"sortData": "Single",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Order Weeks Prior to Performance",
"dim": "[SEAT & TICKET.Order Weeks Prior to Performance]",
"datatype": "numeric",
"title": "Order Weeks Prior to Performance (1)",
"filter": {
"toNotEqual": "1"
},
"collapsed": false,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Comp",
"(none)"
]
}
},
"collapsed": true,
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
}
]
}
]
},
"type": "chart/line",
"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": {
"lineWidth": {
"width": "bold"
},
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": false,
"rotation": 0
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": false,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "order_weeks_prior_to_performance",
"title": "Order Weeks Prior to Performance",
"singular": "Order Weeks Prior to Performance",
"plural": "Order Weeks Prior to Performance"
},
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
},
{
"id": "order_weeks_prior_to_performance_(1)",
"title": "Order Weeks Prior to Performance (1)",
"singular": "Order Weeks Prior to Performance (1)",
"plural": "Order Weeks Prior to Performance (1)"
}
]
}
},
"instanceid": "4DB4D-EA38-51",
"queryStartTime": "2022-02-18T10:24:07",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at http://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\nwidget.on('render', function(scope, args) {\n args.widget.options.previousScrollerLocation.min = 0;\n args.widget.options.previousScrollerLocation.max = 25;\n});",
"dashboardid": "620ead282df9e61f384395e4",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
}
],
"hierarchies": []
}