{
"title": "Workshop: Seats & Tickets Genre",
"desc": "",
"source": null,
"type": "dashboard",
"style": {
"name": "vivid",
"palette": {
"colors": [
"#547A94",
"#F48E06",
"#DB4935",
"#333333",
"#008775"
],
"min": "#547A94",
"max": "#F48E06",
"name": "Tessitura",
"sortOrder": 0
}
},
"layout": {
"instanceid": "42026-6D2E-70",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "36px",
"defaultWidth": 128,
"widgetid": "64c022c783e07d0b547824ba"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1110,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "64c023f783e07d0b547824c5",
"height": "276px",
"autoHeight": "97px"
}
],
"width": 50,
"stretchable": false,
"pxlWidth": 555,
"index": 1
}
]
}
],
"pxlWidth": 1110,
"index": 0
}
],
"container": {
"sizzle1690555352808": {
"undefined": {
"parentNode": [
6971.311223418731,
95,
true
]
}
}
}
},
"original": null,
"oid": "64c022c783e07d0b547824b8",
"dataExploration": false,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filters": [
{
"jaql": {
"table": "SEASON",
"column": "Season Fiscal Current Year Offset",
"dim": "[SEASON.Season Fiscal Current Year Offset]",
"datatype": "numeric",
"title": "Season Fiscal Current Year Offset",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"0",
"-1",
"-2"
]
}
},
"instanceid": "39E9F-207B-E5",
"isCascading": false,
"disabled": false
},
{
"instanceid": "DDA1D-6213-FD",
"isCascading": true,
"disabled": false,
"levels": [
{
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"panel": "scope",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Education Programs"
]
}
}
},
{
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Adult Ballet - Drop-In Classes",
"Adult Ballet Program",
"Adult Education Workshop",
"Adult Learning",
"Air & Weather",
"Animal Encounters",
"Astronomy Lectures",
"Children's Ballet Program",
"Improv Series",
"Playwriting Camp 101",
"Winter Break Explorers Camp"
]
}
}
],
"model": {
"instanceid": "AF687-0E93-C5",
"__store": [
"[SEASON.Season Type]",
"[PERFORMANCE DETAIL.Production]"
]
},
"locked": true
},
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Sold Flag",
"dim": "[SEAT & TICKET.Seat Sold Flag]",
"datatype": "text",
"merged": true,
"title": "Seat Sold Flag",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Y"
]
}
},
"instanceid": "CEE79-3544-E2",
"isCascading": false,
"locked": true
}
],
"editing": true,
"parentFolder": "64c3f407fc0cdd433c0bf642",
"settings": {
"autoUpdateOnFiltersChange": true
},
"filterToDatasourceMapping": {},
"defaultFilters": [
{
"jaql": {
"table": "SEASON",
"column": "Season Fiscal Current Year Offset",
"dim": "[SEASON.Season Fiscal Current Year Offset]",
"datatype": "numeric",
"title": "Season Fiscal Current Year Offset",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"0"
]
}
},
"instanceid": "39E9F-207B-E5",
"isCascading": false
},
{
"instanceid": "DDA1D-6213-FD",
"isCascading": true,
"disabled": false,
"levels": [
{
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"panel": "scope",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Education Programs"
]
}
}
},
{
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Adult Ballet - Drop-In Classes",
"Adult Ballet Program",
"Adult Education Workshop",
"Adult Learning",
"Air & Weather",
"Animal Encounters",
"Astronomy Lectures",
"Before and After Care",
"Children's Ballet Program",
"Improv Series",
"Playwriting Camp 101",
"Winter Break Explorers Camp"
]
}
}
],
"model": {
"instanceid": "AF687-0E93-C5",
"__store": [
"[SEASON.Season Type]",
"[PERFORMANCE DETAIL.Production]"
]
},
"locked": true
},
{
"jaql": {
"table": "SEAT & TICKET DETAILS",
"column": "Seat Sold Flag",
"dim": "[SEAT & TICKET.Seat Sold Flag]",
"datatype": "text",
"merged": true,
"title": "Seat Sold Flag",
"collapsed": true,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Y"
]
}
},
"instanceid": "CEE79-3544-E2",
"isCascading": false,
"locked": true
}
],
"allowChangeSubscription": false,
"isPublic": null,
"previewLayout": [],
"lastPublish": "2023-07-28T18:17:36.390Z",
"subscription": {
"isDataChange": true,
"type": "onUpdate",
"schedule": "* * * * * *",
"timezone": 240,
"tzName": "America/New_York",
"context": {
"dashboardid": "64c022c783e07d0b547824b8"
},
"active": false,
"executionPerDay": 1,
"reportType": {
"inline": true
},
"emailSettings": {
"isEmail": true,
"isPdf": false
},
"startAt": "2023-07-28",
"subscribe": false
},
"widgets": [
{
"title": "RICHTEXT_MAIN.TITLE",
"type": "richtexteditor",
"subtype": "richtexteditor",
"oid": "64c022c783e07d0b547824ba",
"desc": null,
"source": null,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"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": "Workshop: Seats & Tickets Genre",
"vAlign": "valign-middle",
"bgColor": "#6fa1c3",
"textAlign": "center"
}
},
"instanceid": "D36A9-FB0A-37",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"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": "64c022c783e07d0b547824b8"
},
{
"title": "Ticket Counts",
"type": "chart/column",
"subtype": "column/classic",
"oid": "64c023f783e07d0b547824c5",
"desc": null,
"source": null,
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season Fiscal Year",
"dim": "[SEASON.Season Fiscal Year]",
"datatype": "numeric",
"title": "Season Fiscal Year"
},
"field": {
"id": "[SEASON.Season Fiscal Year]",
"index": 0
},
"format": {
"width": 130
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "(sum([E691E-D7C]),[C40DB-EEB])",
"context": {
"[E691E-D7C]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
},
"[C40DB-EEB]": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Adult Ballet - Drop-In Classes",
"Adult Ballet Program",
"Children's Ballet Program"
]
},
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Dance"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "(sum([E691E-D7C]),[C40DB-EEB])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([595C3-B1F]),[7BACE-A2D])",
"context": {
"[595C3-B1F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
},
"[7BACE-A2D]": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Air & Weather",
"Animal Encounters",
"Astronomy Lectures",
"Winter Break Explorers Camp"
]
},
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
}
},
"[503B1-413]": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Adult Ballet - Drop-In Classes",
"Adult Ballet Program",
"Children's Ballet Program"
]
},
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Nature"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#F48E06",
"type": "color"
}
},
"field": {
"id": "(sum([595C3-B1F]),[7BACE-A2D])",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([8676A-9BB]),[6B0E8-CE9])",
"context": {
"[8676A-9BB]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
},
"[7C256-698]": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Air & Weather",
"Animal Encounters",
"Astronomy Lectures",
"Winter Break Explorers Camp"
]
},
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
}
},
"[6B0E8-CE9]": {
"table": "PERFORMANCE DETAIL",
"column": "Production",
"dim": "[PERFORMANCE DETAIL.Production]",
"datatype": "text",
"merged": true,
"title": "Production",
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Improv Series",
"Playwriting Camp 101"
]
},
"datasource": {
"title": "LLNA-Seats and Tickets",
"fullname": "USEA2SATCUBE450.aws.tnhs.cloud/LLNA-Seats and Tickets",
"id": "aUSEA2SATCUBE450LgAaAWSLgAaTNHSLgAaCLOUD_aLLNALQAaSEATSIAAaANDIAAaTICKETS",
"address": "USEA2SATCUBE450.aws.tnhs.cloud",
"database": "aLLNALQAaSeatsIAAaandIAAaTickets"
}
}
},
"title": "Theatre"
},
"format": {
"mask": {
"type": "number",
"abbreviations": {
"t": true,
"b": true,
"m": true,
"k": true
},
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"color": "#DB4935",
"type": "color"
}
},
"field": {
"id": "(sum([8676A-9BB]),[6B0E8-CE9])",
"index": 3
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": false,
"rotation": 0,
"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": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "season_fiscal_year",
"title": "Season Fiscal Year",
"singular": "Season Fiscal Year",
"plural": "Season Fiscal Year"
}
]
}
},
"instanceid": "A309F-E0BB-1C",
"queryStartTime": "2023-07-28T12:48:39",
"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": 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
},
"realTimeRefreshing": false,
"viewState": {
"activeTab": "filters"
},
"options": {
"dashboardFiltersMode": "filter",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": 0,
"max": 2
}
},
"dashboardid": "64c022c783e07d0b547824b8",
"drawing": true,
"disableSelctor": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false
}
],
"hierarchies": []
}