{
"title": "First Time Buyer Widget Ideas",
"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": "A3122-9FD6-7E",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": 128,
"defaultWidth": 128,
"widgetid": "649605e3ea72261fecfee3f0"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "649a01d1637e9a3e347bda15",
"height": "64px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"height": "180px",
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f1"
}
],
"width": 34.10202655485675,
"stretchable": false,
"pxlWidth": 472.984,
"index": 0
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f2",
"height": "180px"
}
],
"width": 32.20637753105084,
"stretchable": false,
"pxlWidth": 446.688,
"index": 1
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f5",
"height": "180px"
}
],
"width": 33.69159591409242,
"stretchable": false,
"pxlWidth": 467.297,
"index": 2
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "192px",
"defaultWidth": 128,
"widgetid": "649605e3ea72261fecfee3f4"
}
],
"width": 33.0760749724366,
"stretchable": false,
"pxlWidth": 458.75,
"index": 0
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f3",
"height": "192px",
"autoHeight": "416px"
}
],
"width": 66.9239250275634,
"stretchable": false,
"pxlWidth": 928.234,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3fa",
"height": "248px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"defaultWidth": 128,
"widgetid": "649a01f8637e9a3e347bda17",
"height": "64px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3fc",
"height": "408px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f6",
"height": 192
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 693.5,
"index": 0
},
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3f8",
"height": 192
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 693.5,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "649605e3ea72261fecfee3fb",
"height": "408px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": "64px",
"defaultWidth": 512,
"widgetid": "6499f715637e9a3e347bd9e3"
}
],
"index": 0,
"stretchable": false,
"width": 100,
"pxlWidth": 1387
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": "132px",
"defaultWidth": 512,
"widgetid": "6499f71a637e9a3e347bd9e5",
"autoHeight": "107px"
}
],
"index": 0,
"stretchable": false,
"width": 54.24476295479603,
"pxlWidth": 752.359
},
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": "132px",
"defaultWidth": 512,
"widgetid": "6499f71e637e9a3e347bd9e7"
}
],
"width": 45.75523704520397,
"stretchable": false,
"pxlWidth": 634.625,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 102,
"maxHeight": 1024,
"minWidth": 128,
"maxWidth": 2048,
"height": "356px",
"defaultWidth": 512,
"widgetid": "6499f722637e9a3e347bd9e9"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1387,
"index": 0
}
]
}
],
"pxlWidth": 1387,
"index": 0
}
],
"container": {
"sizzle1687871825826": {
"undefined": {
"parentNode": [
268.64180688911364,
87,
true
]
}
}
}
},
"original": null,
"oid": "649605e3ea72261fecfee3ef",
"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": null,
"filters": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production 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": "2023-06-26T10:09:06.016Z"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"BT Swan Lake 2022"
]
}
},
"instanceid": "827B9-B6CA-16",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category",
"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",
"lastBuildTime": "2023-01-26T05:43:12"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)",
"Comp"
]
}
}
},
"instanceid": "A88D7-D5E4-A5",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"isPublic": null,
"previewLayout": [],
"settings": {
"autoUpdateOnFiltersChange": false
},
"allowChangeSubscription": false,
"lastPublish": "2023-06-15T22:06:54.820Z",
"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": "2023-01-26T05:43:12"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "649605e3ea72261fecfee3f0",
"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": "First Time Buyers
A collection of widgets to get you to the next level with reviewing first time buyer trends.
For questions, contact Christine at wingenfeld@trustarts.org.",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "1350A-67BD-B9",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "649605e3ea72261fecfee3ef",
"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": "Constituents | Jumpable",
"subtype": "indicator/numeric",
"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": "value",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "Count Constituents"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Count"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 10000,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [9E8A1-267], [67D04-1C9])) =0 \nthen 1\nelse null\nend",
"context": {
"[67D04-1C9]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[9E8A1-267]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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"
}
}
}
]
}
]
},
"oid": "649605e3ea72261fecfee3f1",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "B33A7-997B-49",
"queryStartTime": "2023-06-26T16:35:27",
"widgetTimingLoged": false,
"drawing": true,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true,
"dirty": true
},
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false,
"drillTarget": {
"oid": "5ea86ddd42ba532104076b38",
"caption": "_Constituents",
"folder": "5c49becf14d1f11fc064e6c7"
}
},
"drilledDashboardDisplay": {}
},
{
"title": "Donors | Not Jumpable",
"subtype": "indicator/numeric",
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "( [DD7C9-B3D] , [ED153-FAB])",
"context": {
"[DD7C9-B3D]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "# of unique Constituent ID",
"agg": "count"
},
"[ED153-FAB]": {
"table": "CONSTITUENT",
"column": "Current Membership Level",
"dim": "[CONSTITUENT.Current Membership Level]",
"datatype": "text",
"merged": true,
"title": "Current Membership Level",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Current Member"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"type": "measure",
"formula": "([6105F-396] , [00B0F-B45])",
"context": {
"[00B0F-B45]": {
"table": "CONSTITUENT",
"column": "Most Recent Gift Date",
"dim": "[CONSTITUENT.Most Recent Gift Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in Most Recent Gift Date",
"filter": {
"last": {
"count": 10,
"offset": 0
},
"custom": true
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[35A63-5A1]": {
"table": "CONSTITUENT",
"column": "Most Recent Gift Date",
"dim": "[CONSTITUENT.Most Recent Gift Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in Most Recent Gift Date"
},
"[6105F-396]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "# of unique Constituent ID",
"agg": "count"
}
},
"title": "Donor Past 10 Years"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 1000,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [E13A5-E88], [433F2-42A])) =0 \nthen 1\nelse null\nend",
"context": {
"[433F2-42A]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[E13A5-E88]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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"
}
}
}
]
}
]
},
"oid": "649605e3ea72261fecfee3f2",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "B33A7-997B-49",
"queryStartTime": "2023-06-27T08:54:24",
"widgetTimingLoged": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"drilledDashboardDisplay": {},
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true,
"canEditFilters": true
},
{
"title": "Donors | Not Jumpable but can download and import as a list.",
"subtype": "pivot",
"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": "rows",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"field": {
"id": "[CONSTITUENT.Constituent ID]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "( [DD7C9-B3D] , [ED153-FAB])",
"context": {
"[DD7C9-B3D]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "# of unique Constituent ID",
"agg": "count"
},
"[ED153-FAB]": {
"table": "CONSTITUENT",
"column": "Current Membership Level",
"dim": "[CONSTITUENT.Current Membership Level]",
"datatype": "text",
"merged": true,
"title": "Current Membership Level",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"(none)"
]
}
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
}
},
"title": "Current Member"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "( [DD7C9-B3D] , [ED153-FAB])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "([6105F-396] , [00B0F-B45])",
"context": {
"[00B0F-B45]": {
"table": "CONSTITUENT",
"column": "Most Recent Gift Date",
"dim": "[CONSTITUENT.Most Recent Gift Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in Most Recent Gift Date",
"filter": {
"last": {
"count": 10,
"offset": 0
},
"custom": true
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
}
},
"[35A63-5A1]": {
"table": "CONSTITUENT",
"column": "Most Recent Gift Date",
"dim": "[CONSTITUENT.Most Recent Gift Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "years",
"title": "Years in Most Recent Gift Date"
},
"[6105F-396]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "# of unique Constituent ID",
"agg": "count"
}
},
"title": "Donor Past 10 Years"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color_bkp": {
"color": "#60C2BB",
"type": "color"
},
"color": {
"type": "color",
"color": "transparent"
},
"width": 112
},
"field": {
"id": "([6105F-396] , [00B0F-B45])",
"index": 2
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 10000,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [37A53-D4C], [BA7C2-64E])) =0 \nthen 1\nelse null\nend",
"context": {
"[BA7C2-64E]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[37A53-D4C]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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"
}
}
}
]
}
]
},
"oid": "649605e3ea72261fecfee3f3",
"type": "pivot",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"pageSize": "10",
"automaticHeight": true,
"colors": {
"rows": true,
"columns": false,
"headers": false,
"members": false,
"totals": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "0FD2A-DB8E-A6",
"queryStartTime": "2023-06-15T18:01:50",
"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
},
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"drilledDashboardDisplay": {},
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"drawing": true,
"canEditFilters": 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": "2023-01-26T05:43:12"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "649605e3ea72261fecfee3f4",
"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": "The donors widget is not jumpable (this may be fixed in v16.) A workaround is to turn it into a pivot table, export the table and then import it as a list.
If your organization does not use memberships, you could filter the last contribution date to the last 14 months.",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "F02CB-CF5F-5F",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "649605e3ea72261fecfee3ef",
"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": "Proportion of Audience as FTBs",
"subtype": "indicator/numeric",
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(count ( [E1669-695], if ( min (ddiff ( [84BEE-222], [5F02F-532]))=0, max( [E1669-695]), null))) / [44D58-8F1]",
"context": {
"[5F02F-532]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[44D58-8F1]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "# of unique Constituent ID"
},
"[E1669-695]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[84BEE-222]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Proportion FTBs"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "Total Constituents"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
}
}
]
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "649605e3ea72261fecfee3f5",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": false,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": []
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "B33A7-997B-49",
"queryStartTime": "2023-06-15T18:01:50",
"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
},
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"drilledDashboardDisplay": {
"url": "/app/main?t=1674751325#/dashboards/5ea86ddd42ba532104076b38?l=false",
"payload": "{\"filters\":[{\"levels\":[{\"table\":\"SEASON\",\"column\":\"Season\",\"dim\":\"[SEASON.Season]\",\"datatype\":\"text\",\"merged\":true,\"title\":\"Season\",\"filter\":{\"explicit\":true,\"multiSelection\":true,\"members\":[\"OP22 Pittsburgh Opera\"]},\"datasource\":{\"title\":\"Seats and Tickets\",\"fullname\":\"hestia.tessitura.cd.local/Seats and Tickets\",\"id\":\"aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS\",\"address\":\"hestia.tessitura.cd.local\",\"database\":\"aSeatsIAAaandIAAaTickets\",\"lastBuildTime\":\"2023-01-26T05:43:00\"},\"collapsed\":true,\"panel\":\"scope\"},{\"table\":\"PERFORMANCE DETAIL\",\"column\":\"Production Season\",\"dim\":\"[PERFORMANCE DETAIL.Production Season]\",\"datatype\":\"text\",\"merged\":true,\"title\":\"Production 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\":\"2023-01-26T05:43:00\"},\"filter\":{\"explicit\":true,\"multiSelection\":true,\"members\":[\"OP Carmen\"]},\"panel\":\"scope\"},{\"table\":\"PERFORMANCE DATE\",\"column\":\"Date\",\"dim\":\"[PERFORMANCE DATE.Date (Calendar)]\",\"datatype\":\"datetime\",\"merged\":true,\"title\":\"Days in Date\",\"level\":\"days\",\"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\":\"2023-01-26T05:43:00\"},\"filter\":{\"explicit\":false,\"multiSelection\":true,\"all\":true}}],\"model\":{\"instanceid\":\"61C68-4CBC-63\",\"__store\":[\"[SEASON.Season]\",\"[PERFORMANCE DETAIL.Production Season]\",\"[PERFORMANCE DATE.Date (Calendar)]\"]},\"isCascading\":true}]}"
},
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true
},
{
"title": "First Time ATP",
"subtype": "indicator/numeric",
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "([777AF-3E2]) / [AB28D-053]",
"context": {
"[777AF-3E2]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"[AB28D-053]": {
"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": "Average Ticket Price"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": []
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 10000,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [43991-9E8], [A41B5-92E])) =0 \nthen 1\nelse null\nend",
"context": {
"[A41B5-92E]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[43991-9E8]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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": "649605e3ea72261fecfee3f6",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "B33A7-997B-49",
"queryStartTime": "2023-06-15T18:01:50",
"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
},
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"drilledDashboardDisplay": {},
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true,
"canEditFilters": true
},
{
"title": "Overall ATP",
"subtype": "indicator/numeric",
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "([777AF-3E2]) / [AB28D-053]",
"context": {
"[777AF-3E2]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Total Ticket Paid Amount",
"agg": "sum"
},
"[AB28D-053]": {
"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": "Average Ticket Price"
},
"format": {
"mask": {
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": false
},
"decimals": "auto",
"currency": {
"symbol": "$",
"position": "pre"
}
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "secondary",
"items": []
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 1,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [B9678-FCC], [01F74-5C5])) =0 \nthen 1\nelse 0\nend",
"context": {
"[01F74-5C5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B9678-FCC]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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": true
}
]
}
]
},
"oid": "649605e3ea72261fecfee3f8",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "B33A7-997B-49",
"queryStartTime": "2023-06-07T14:42:02",
"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
},
"viewState": {
"activeTab": "filters"
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"drilledDashboardDisplay": {},
"canEditFilters": true,
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"drawing": true
},
{
"title": "Price Type Category Breakdown",
"subtype": "bar/stacked",
"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": "categories",
"items": []
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "Constituents"
},
"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": "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",
"inResultset": true
},
"Group": {
"color": "#94A1A8",
"title": "Group",
"sortData": "Group",
"inResultset": true
},
"Single": {
"color": "#6E798D",
"title": "Single",
"sortData": "Single",
"inResultset": true
},
"Subscription": {
"color": "#FA7240",
"title": "Subscription",
"sortData": "Subscription",
"inResultset": true
}
}
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID",
"filter": {
"top": 10000,
"by": {
"type": "measure",
"formula": "case when min (ddiff( [2096B-3AF], [817CA-A4F])) =0 \nthen 1\nelse null\nend",
"context": {
"[817CA-A4F]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[2096B-3AF]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"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"
}
}
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"agg": "count",
"title": "# of unique Constituent ID",
"filter": {
"fromNotEqual": "1"
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"collapsed": false
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
},
"disabled": true
}
]
}
]
},
"oid": "649605e3ea72261fecfee3fa",
"type": "chart/bar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0,
"labels": {
"enabled": true,
"types": {
"count": false,
"percentage": false,
"relative": true,
"totals": false
},
"stacked": true,
"stackedPercentage": false
}
},
"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,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"navigator": {
"enabled": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
},
{
"id": "constituent_id",
"title": "Constituent ID",
"singular": "Constituent ID",
"plural": "Constituent ID"
}
]
}
},
"instanceid": "A87AF-1198-C0",
"queryStartTime": "2023-06-27T09:20:41",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"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,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"drilledDashboardDisplay": {},
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": -0.5,
"max": 0.5
},
"selectorLocked": false,
"drillTarget": {
"oid": "5ea86ddd42ba532104076b38",
"caption": "_Constituents",
"folder": "646f8f3113cd0d2d98b5c098"
}
},
"drawing": true
},
{
"title": "Breakdown of FTBs vs Returning Buyers by Geo Area",
"subtype": "column/classic",
"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": "categories",
"items": [
{
"jaql": {
"table": "CONSTITUENT",
"column": "Primary Address Geo Area",
"dim": "[CONSTITUENT.Primary Address Geo Area]",
"datatype": "text",
"merged": true,
"title": "Primary Address Geo Area"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "Contribution([D88BC-E33])",
"context": {
"[D88BC-E33]": {
"type": "measure",
"formula": "Count ( [D678B-3E9] , if ( Min ( ddiff ( [FB57A-369], [0BB2B-4F5])) = 0 , max ( [D678B-3E9]), null))",
"context": {
"[0BB2B-4F5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[D678B-3E9]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[FB57A-369]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"title": "Breakout by FTBs"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#60C2BB",
"type": "color"
}
},
"disabled": false,
"originalJaql": {
"type": "measure",
"formula": "Count ( [D678B-3E9] , if ( Min ( ddiff ( [FB57A-369], [0BB2B-4F5])) = 0 , max ( [D678B-3E9]), null))",
"context": {
"[0BB2B-4F5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[D678B-3E9]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[FB57A-369]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
},
"quickFunction": "Contribution"
},
{
"jaql": {
"type": "measure",
"formula": "Contribution([DAB32-5D9])",
"context": {
"[DAB32-5D9]": {
"type": "measure",
"formula": "Count ( [B3D2F-DB0] , if ( Min ( ddiff ( [99D80-C4D], [2A321-AA1])) <> 0 , max ( [B3D2F-DB0]), null))",
"context": {
"[2A321-AA1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B3D2F-DB0]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[99D80-C4D]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula (1)"
}
},
"title": "Breakout by Not First Time Buyers"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#94A1A8",
"type": "color"
}
},
"disabled": false,
"originalJaql": {
"type": "measure",
"formula": "Count ( [B3D2F-DB0] , if ( Min ( ddiff ( [99D80-C4D], [2A321-AA1])) <> 0 , max ( [B3D2F-DB0]), null))",
"context": {
"[2A321-AA1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B3D2F-DB0]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[99D80-C4D]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula (1)"
},
"quickFunction": "Contribution"
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "649605e3ea72261fecfee3fb",
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": true,
"rotation": 0,
"labels": {
"enabled": false,
"types": {
"count": false,
"percentage": false,
"relative": false,
"totals": false
},
"stacked": false,
"stackedPercentage": false
}
},
"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,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "primary_address_geo_area",
"title": "Primary Address Geo Area",
"singular": "Primary Address Geo Area",
"plural": "Primary Address Geo Area"
}
]
}
},
"instanceid": "B61A6-B483-D6",
"queryStartTime": "2023-06-27T09:20:41",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"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,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 15
}
},
"drawing": true
},
{
"title": "Breakdown of FTBs vs Returning Buyers by PT Category",
"subtype": "column/classic",
"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": "categories",
"items": [
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Type Category",
"dim": "[PERFORMANCE PRICING.Price Type Category]",
"datatype": "text",
"merged": true,
"title": "Price Type Category"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "Contribution([D88BC-E33])",
"context": {
"[D88BC-E33]": {
"type": "measure",
"formula": "Count ( [D678B-3E9] , if ( Min ( ddiff ( [FB57A-369], [0BB2B-4F5])) = 0 , max ( [D678B-3E9]), null))",
"context": {
"[0BB2B-4F5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[D678B-3E9]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[FB57A-369]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
}
},
"title": "Breakout by FTBs"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#60C2BB",
"type": "color"
}
},
"disabled": false,
"originalJaql": {
"type": "measure",
"formula": "Count ( [D678B-3E9] , if ( Min ( ddiff ( [FB57A-369], [0BB2B-4F5])) = 0 , max ( [D678B-3E9]), null))",
"context": {
"[0BB2B-4F5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[D678B-3E9]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[FB57A-369]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
},
"quickFunction": "Contribution"
},
{
"jaql": {
"type": "measure",
"formula": "Contribution([DAB32-5D9])",
"context": {
"[DAB32-5D9]": {
"type": "measure",
"formula": "Count ( [B3D2F-DB0] , if ( Min ( ddiff ( [99D80-C4D], [2A321-AA1])) <> 0 , max ( [B3D2F-DB0]), null))",
"context": {
"[2A321-AA1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B3D2F-DB0]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[99D80-C4D]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula (1)"
}
},
"title": "Breakout by Non-FTBs"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#94A1A8",
"type": "color"
}
},
"disabled": false,
"originalJaql": {
"type": "measure",
"formula": "Count ( [B3D2F-DB0] , if ( Min ( ddiff ( [99D80-C4D], [2A321-AA1])) <> 0 , max ( [B3D2F-DB0]), null))",
"context": {
"[2A321-AA1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B3D2F-DB0]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[99D80-C4D]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula (1)"
},
"quickFunction": "Contribution"
},
{
"jaql": {
"type": "measure",
"formula": "Contribution(Count ( [DDD58-9A7] ))",
"context": {
"[DDD58-9A7]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
}
},
"title": "Overall Buyers"
},
"format": {
"mask": {
"decimals": 0,
"percent": true,
"percentMultiplier": 100
},
"color": {
"color": "#6E798D",
"type": "color"
}
},
"disabled": true,
"originalJaql": {
"type": "measure",
"formula": "Count ( [B3D2F-DB0] , if ( Min ( ddiff ( [99D80-C4D], [2A321-AA1])) <> 0 , max ( [B3D2F-DB0]), null))",
"context": {
"[2A321-AA1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[B3D2F-DB0]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[99D80-C4D]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula (1)"
},
"quickFunction": "Contribution"
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "649605e3ea72261fecfee3fc",
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "top"
},
"seriesLabels": {
"enabled": true,
"rotation": 0,
"labels": {
"enabled": false,
"types": {
"count": false,
"percentage": false,
"relative": false,
"totals": false
},
"stacked": false,
"stackedPercentage": false
}
},
"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,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "price_type_category",
"title": "Price Type Category",
"singular": "Price Type Category",
"plural": "Price Type Category"
}
]
}
},
"instanceid": "B61A6-B483-D6",
"queryStartTime": "2023-06-27T09:20:41",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"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,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "design"
},
"realTimeRefreshing": false,
"dashboardid": "649605e3ea72261fecfee3ef",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 4
}
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "6499f715637e9a3e347bd9e3",
"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": []
},
"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": "What did they come to next?
Some of these widgets require additional widget-level filtering.",
"vAlign": "valign-middle",
"bgColor": "#c3d5de",
"textAlign": "center"
}
},
"instanceid": "24264-1D68-EE",
"widgetTimingLoged": true,
"realTimeRefreshing": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"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"
},
"dashboardid": "649605e3ea72261fecfee3ef"
},
{
"title": "Returning Buyer Summary",
"subtype": "pivot",
"oid": "6499f71a637e9a3e347bd9e5",
"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": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"field": {
"id": "[PERFORMANCE DETAIL.Production Season]",
"index": 0
},
"disabled": false
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "count([9BADA-010], if ( min ( ddiff ( [40D5F-DA0] , [DAD1E-A9A])) =0, max ( [9BADA-010]), null))",
"context": {
"[DAD1E-A9A]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[9BADA-010]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[40D5F-DA0]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "First Time Buyers"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "count([9BADA-010], if ( min ( ddiff ( [40D5F-DA0] , [DAD1E-A9A])) =0, max ( [9BADA-010]), null))",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "count ( [BB8D9-843], \n \n \n if ( min ( ddiff ( [B04B5-2FB],[A65C5-3E5])) = 0 \n \n \n and ( [1B611-89D], all ( [C5095-8DA])) > 1, \n \n \n \n max ( [BB8D9-843]), null))",
"context": {
"[1B611-89D]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season ID",
"dim": "[PERFORMANCE DETAIL.Production Season ID]",
"datatype": "numeric",
"agg": "count",
"title": "# of unique Production Season ID"
},
"[A65C5-3E5]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[C5095-8DA]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"[BB8D9-843]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[B04B5-2FB]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Count Returning"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "count ( [BB8D9-843], \n \n \n if ( min ( ddiff ( [B04B5-2FB],[A65C5-3E5])) = 0 \n \n \n and ( [1B611-89D], all ( [C5095-8DA])) > 1, \n \n \n \n max ( [BB8D9-843]), null))",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "(count ( [4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5],[E668C-AF1])) = 0 and ( [AD881-AA0], all ( [0300A-EB2])) > 1, max ( [4DEFA-A2B]), null))) / ( count([4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5] , [E668C-AF1])) =0, max ( [4DEFA-A2B]), null)))",
"context": {
"[AD881-AA0]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season ID",
"dim": "[PERFORMANCE DETAIL.Production Season ID]",
"datatype": "numeric",
"agg": "count",
"title": "# of unique Production Season ID"
},
"[E668C-AF1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[0300A-EB2]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"[4DEFA-A2B]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[5A4DF-AB5]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Proportion Returning"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(count ( [4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5],[E668C-AF1])) = 0 and ( [AD881-AA0], all ( [0300A-EB2])) > 1, max ( [4DEFA-A2B]), null))) / ( count([4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5] , [E668C-AF1])) =0, max ( [4DEFA-A2B]), null)))",
"index": 3
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"type": "pivot",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"pageSize": 25,
"automaticHeight": true,
"colors": {
"rows": true,
"columns": false,
"headers": false,
"members": false,
"totals": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
}
]
}
},
"instanceid": "D5EFB-6878-DE",
"queryStartTime": "2023-06-26T17:26:29",
"widgetTimingLoged": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 2,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"canEditFilters": true,
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true,
"selectorLocked": false
},
"dashboardid": "649605e3ea72261fecfee3ef",
"drawing": true
},
{
"title": "Returning Buyer Proportion",
"subtype": "indicator/numeric",
"oid": "6499f71e637e9a3e347bd9e7",
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(count ( [4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5],[E668C-AF1])) = 0 and ( [AD881-AA0], all ( [0300A-EB2])) > 1, max ( [4DEFA-A2B]), null))) / ( count([4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5] , [E668C-AF1])) =0, max ( [4DEFA-A2B]), null)))",
"context": {
"[AD881-AA0]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season ID",
"dim": "[PERFORMANCE DETAIL.Production Season ID]",
"datatype": "numeric",
"agg": "count",
"title": "# of unique Production Season ID"
},
"[E668C-AF1]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[0300A-EB2]": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"[4DEFA-A2B]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[5A4DF-AB5]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Proportion Returning"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
},
"field": {
"id": "(count ( [4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5],[E668C-AF1])) = 0 and ( [AD881-AA0], all ( [0300A-EB2])) > 1, max ( [4DEFA-A2B]), null))) / ( count([4DEFA-A2B], if ( min ( ddiff ( [5A4DF-AB5] , [E668C-AF1])) =0, max ( [4DEFA-A2B]), null)))",
"index": 1
}
}
]
},
{
"name": "secondary",
"items": []
},
{
"name": "min",
"items": []
},
{
"name": "max",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": true,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": []
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "1F371-959A-CF",
"queryStartTime": "2023-06-26T17:26:29",
"widgetTimingLoged": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drilledDashboardDisplay": {
"url": "/app/main?t=1674829953#/dashboards/5ea86ddd42ba532104076b38?l=false",
"payload": "{\"filters\":[{\"jaql\":{\"table\":\"CONSTITUENT\",\"column\":\"First Performance Name\",\"dim\":\"[CONSTITUENT.First Performance Name]\",\"datatype\":\"text\",\"merged\":true,\"title\":\"First Performance Name\",\"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\":\"2023-01-26T05:43:12\"},\"filter\":{\"explicit\":true,\"multiSelection\":true,\"members\":[\"2022 OP Carmen\"]}}},{\"jaql\":{\"table\":\"PERFORMANCE DETAIL\",\"column\":\"Production Season\",\"dim\":\"[PERFORMANCE DETAIL.Production Season]\",\"datatype\":\"text\",\"merged\":true,\"title\":\"Production Season - also select or will pull in all productions since first one\",\"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\":\"2023-01-26T05:43:12\"},\"filter\":{\"explicit\":true,\"multiSelection\":true,\"members\":[\"OP Carmen\"]}}},{\"jaql\":{\"table\":\"PERFORMANCE PRICING\",\"column\":\"Price Type Category\",\"dim\":\"[PERFORMANCE PRICING.Price Type Category]\",\"datatype\":\"text\",\"merged\":true,\"title\":\"Price Type Category\",\"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\",\"lastBuildTime\":\"2023-01-26T05:43:12\"},\"filter\":{\"explicit\":false,\"multiSelection\":true,\"all\":true}}}]}"
},
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"dashboardid": "649605e3ea72261fecfee3ef",
"drawing": true
},
{
"title": "Subsequent Performances - ADDITIONAL WIDGET-LEVEL FILTER",
"subtype": "bar/classic",
"oid": "6499f722637e9a3e347bd9e9",
"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": [
"[PERFORMANCE DETAIL.Production Season]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season",
"dim": "[SEASON.Season]",
"datatype": "text",
"merged": true,
"title": "Season"
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "count([6488E-1F8], if ( min ( ddiff ( [48CD6-048] , [CAD28-ABE])) >0, max ( [6488E-1F8]), null))",
"context": {
"[CAD28-ABE]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[6488E-1F8]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[48CD6-048]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#60C2BB",
"type": "color"
}
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"type": "measure",
"formula": "count([6488E-1F8], if ( min ( ddiff ( [48CD6-048] , [CAD28-ABE])) >0, max ( [6488E-1F8]), null))",
"context": {
"[CAD28-ABE]": {
"table": "CONSTITUENT",
"column": "First Performance Date",
"dim": "[CONSTITUENT.First Performance Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in First Performance Date"
},
"[6488E-1F8]": {
"table": "CONSTITUENT",
"column": "Constituent ID",
"dim": "[CONSTITUENT.Constituent ID]",
"datatype": "numeric",
"merged": true,
"title": "Constituent ID"
},
"[48CD6-048]": {
"table": "PERFORMANCE DATE",
"column": "Date",
"dim": "[PERFORMANCE DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date"
}
},
"title": "Formula",
"filter": {
"fromNotEqual": 0
},
"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"
}
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
}
},
"disabled": false
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "First Performance Name",
"dim": "[CONSTITUENT.First Performance Name]",
"datatype": "text",
"merged": true,
"title": "First Performance Name",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2022 BT Swan Lake 2022"
]
},
"datasource": {
"title": "Seats and Tickets",
"fullname": "hestia.tessitura.cd.local/Seats and Tickets",
"id": "aHESTIALgAaTESSITURALgAaCDLgAaLOCAL_aSEATSIAAaANDIAAaTICKETS",
"address": "hestia.tessitura.cd.local",
"database": "aSeatsIAAaandIAAaTickets"
},
"collapsed": true
}
}
]
}
]
},
"type": "chart/bar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0,
"labels": {
"enabled": false,
"types": {
"count": false,
"percentage": false,
"relative": false,
"totals": false
},
"stacked": false,
"stackedPercentage": false
}
},
"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,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"navigator": {
"enabled": false
},
"lineWidth": {
"width": "bold"
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "season",
"title": "Season",
"singular": "Season",
"plural": "Season"
},
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
},
{
"id": "first_performance_name",
"title": "First Performance Name",
"singular": "First Performance Name",
"plural": "First Performance Name"
}
]
}
},
"instanceid": "1CAB3-99CA-61",
"queryStartTime": "2023-06-27T09:20:50",
"widgetTimingLoged": false,
"disableSelctor": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"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,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"viewState": {
"activeTab": "design"
},
"realTimeRefreshing": false,
"drilledDashboardDisplay": {},
"canEditFilters": true,
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
},
"selectorLocked": false,
"drillTarget": {
"oid": "5ea86ddd42ba532104076b38",
"caption": "_Constituents",
"folder": "5c49becf14d1f11fc064e6c7"
}
},
"dashboardid": "649605e3ea72261fecfee3ef",
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "649a01d1637e9a3e347bda15",
"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": []
},
"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": "First Time Buyer Summary
",
"vAlign": "valign-middle",
"bgColor": "#c3d5de",
"textAlign": "center"
}
},
"instanceid": "24264-1D68-EE",
"widgetTimingLoged": false,
"realTimeRefreshing": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"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"
},
"dashboardid": "649605e3ea72261fecfee3ef"
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "649a01f8637e9a3e347bda17",
"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": []
},
"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": "How do they compare to overall buyers?
",
"vAlign": "valign-middle",
"bgColor": "#c3d5de",
"textAlign": "center"
}
},
"instanceid": "24264-1D68-EE",
"widgetTimingLoged": false,
"realTimeRefreshing": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": false,
"volatile": false,
"hideDrilledDashboards": false,
"hideSharedDashboardsForNonOwner": true,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 3,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true,
"sendPieChartMeasureFiltersOnClick": true,
"forceZeroInsteadNull": false,
"mergeTargetDashboardFilters": false,
"drillToDashboardByName": true
},
"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"
},
"dashboardid": "649605e3ea72261fecfee3ef"
}
],
"hierarchies": []
}