{ "title": "Spring 2024 Yard School of Art TEST", "desc": "", "source": "65e73bbbc3230f0f0c16bbbb", "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "D84FE-F42D-50", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "664px", "defaultWidth": 512, "widgetid": "65f990fa42c42834f04badc6", "autoHeight": "664px" } ], "width": 100, "stretchable": false, "pxlWidth": 1049, "index": 0 } ] } ], "pxlWidth": 1049, "index": 0 } ], "container": { "sizzle1711039525014": { "undefined": { "parentNode": [ 3330.1142480613785, 89, true ] } } } }, "original": null, "oid": "65f990fa42c42834f04badc1", "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "editing": false, "filters": [ { "jaql": { "table": "ORDER DATE", "column": "Fiscal Current Year Offset", "dim": "[ORDER DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] } }, "instanceid": "FA193-3CCA-6B", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "FY24 Yard School - Spring" ] } }, "instanceid": "1ED4C-0EC6-11", "isCascading": false, "disabled": false }, { "instanceid": "652C1-83D3-25", "isCascading": true, "levels": [ { "table": "PERFORMANCE DETAIL", "column": "Title", "dim": "[PERFORMANCE DETAIL.Title]", "datatype": "text", "merged": true, "title": "Title", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "panel": "scope", "filter": { "explicit": true, "multiSelection": true, "members": [ "Yard School of Art" ] } }, { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "panel": "scope", "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "ZZ Zen Art Workshop", "ZZShibori Indigo Dyeing Wrkshp", "Ceramic Open Studio", "Ceramics Open Studio", "Spring Ceramics Open Studio", "Winter Ceramics Open Studio", "In-Person Family Studio Family", "In-Person Family Studio Worksh", "SummerART (5-7)", "SummerART (6-8)", "SummerART Open House" ] } } } ], "model": { "instanceid": "FCB43-EED6-C4", "__store": [ "[PERFORMANCE DETAIL.Title]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Production Season]" ] }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Status", "dim": "[PERFORMANCE DETAIL.Status]", "datatype": "text", "merged": true, "title": "Status", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-12-04T22:56:18" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "3BAFF-BFE1-55", "isCascading": false, "disabled": false }, { "jaql": { "table": "ZONE", "column": "Zone", "dim": "[ZONE.Zone]", "datatype": "text", "merged": true, "title": "Zone", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-01-18T22:56:14" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Wait List" ] } } }, "instanceid": "80B6C-DBDB-C0", "isCascading": false } ], "filterToDatasourceMapping": {}, "isPublic": null, "defaultFilters": [ { "jaql": { "table": "ORDER DATE", "column": "Fiscal Current Year Offset", "dim": "[ORDER DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] } }, "instanceid": "FA193-3CCA-6B", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "FY24 Yard School - Spring" ] } }, "instanceid": "1ED4C-0EC6-11", "isCascading": false, "disabled": false }, { "instanceid": "652C1-83D3-25", "isCascading": true, "levels": [ { "table": "PERFORMANCE DETAIL", "column": "Title", "dim": "[PERFORMANCE DETAIL.Title]", "datatype": "text", "merged": true, "title": "Title", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "panel": "scope", "filter": { "explicit": true, "multiSelection": true, "members": [ "Yard School of Art" ] } }, { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "collapsed": true, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "panel": "scope", "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "ZZ Zen Art Workshop", "ZZShibori Indigo Dyeing Wrkshp", "Ceramic Open Studio", "Ceramics Open Studio", "Spring Ceramics Open Studio", "Winter Ceramics Open Studio", "In-Person Family Studio Family", "In-Person Family Studio Worksh", "SummerART (5-7)", "SummerART (6-8)", "SummerART Open House" ] } } } ], "model": { "instanceid": "FCB43-EED6-C4", "__store": [ "[PERFORMANCE DETAIL.Title]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Production Season]" ] }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Status", "dim": "[PERFORMANCE DETAIL.Status]", "datatype": "text", "merged": true, "title": "Status", "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-12-04T22:56:18" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "3BAFF-BFE1-55", "isCascading": false, "disabled": false }, { "jaql": { "table": "ZONE", "column": "Zone", "dim": "[ZONE.Zone]", "datatype": "text", "merged": true, "title": "Zone", "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-01-18T22:56:14" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Wait List" ] } } }, "instanceid": "80B6C-DBDB-C0", "isCascading": false } ], "parentFolder": null, "previewLayout": [], "migrated": true, "lastPublish": "2024-03-05T15:40:29.279Z", "allowChangeSubscription": false, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "Adult YSA Sales Summary", "subtype": "pivot", "desc": null, "source": "65e73bbbc3230f0f0c16bbc0", "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[ZONE.Zone]" ], "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 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Performance" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Class Start Date", "sortDetails": { "field": 2, "dir": "desc", "sortingLastDimension": false, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 2 } }, { "jaql": { "table": "ZONE", "column": "Zone", "dim": "[ZONE.Zone]", "datatype": "text", "merged": true, "title": "Zone" }, "field": { "id": "[ZONE.Zone]", "index": 3 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Registrations" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 4 } }, { "jaql": { "type": "measure", "formula": "[738B9-34E]", "context": { "[738B9-34E]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" } }, "title": "Paid Registrations" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[738B9-34E]", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([85F25-2A3], [A3927-08A])", "context": { "[85F25-2A3]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Total Ticket Count", "agg": "sum" }, "[A3927-08A]": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Member Adult", "Member Child" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-09-06T22:57:33" } } }, "title": "Member Registrations" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([85F25-2A3], [A3927-08A])", "index": 6 } }, { "jaql": { "type": "measure", "formula": "([CABC5-F7A], [B8999-E38])", "context": { "[CABC5-F7A]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Total Ticket Count", "agg": "sum" }, "[B8999-E38]": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Adult", "Child" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-09-06T22:57:33" } }, "[EB967-386]": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Member Adult", "Member Child" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-09-06T22:57:33" } } }, "title": "Non-Member Registrations" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([CABC5-F7A], [B8999-E38])", "index": 7 } }, { "jaql": { "type": "measure", "formula": "([64809-C5F], [1A6FD-EEC])", "context": { "[64809-C5F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Total Ticket Count", "agg": "sum" }, "[B1CEF-F11]": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Adult", "Child" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-09-06T22:57:33" } }, "[1A6FD-EEC]": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Complimentary" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-09-06T22:57:33" } } }, "title": "Comp Registrations" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([64809-C5F], [1A6FD-EEC])", "index": 8 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Unpaid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Unpaid Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]_sum", "index": 9 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Seat Unsold Count", "dim": "[SEAT & TICKET VALUES.Seat Unsold Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Unsold Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Seat Unsold Count]_sum", "index": 10 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Seat Unsold Value", "dim": "[SEAT & TICKET VALUES.Seat Unsold Value]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Unsold Value" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Seat Unsold Value]_sum", "index": 11 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "and": [ { "doesntContain": "Open Studio" }, { "doesntContain": "zz" } ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "filter": { "explicit": true, "multiSelection": true, "members": [ "Adult Classes" ] }, "collapsed": false, "datasource": { "title": "MONT-Seats and Tickets", "fullname": "USEA1RAPCUBE213.aws.tnhs.cloud/MONT-Seats and Tickets", "id": "aUSEA1RAPCUBE213LgAaAWSLgAaTNHSLgAaCLOUD_aMONTLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA1RAPCUBE213.aws.tnhs.cloud", "database": "aMONTLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false } ] } ] }, "type": "pivot", "oid": "65f990fa42c42834f04badc6", "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" }, { "id": "performance", "title": "Performance", "singular": "Performance", "plural": "Performance" }, { "id": "class_start_date", "title": "Class Start Date", "singular": "Class Start Date", "plural": "Class Start Date" }, { "id": "zone", "title": "Zone", "singular": "Zone", "plural": "Zone" }, { "id": "production", "title": "Production", "singular": "Production", "plural": "Production" } ] }, "rowsGrandTotal": true }, "instanceid": "55EE9-FEAB-7D", "queryStartTime": "2024-03-21T12:19:49", "drawing": true, "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 }, "realTimeRefreshing": false, "dashboardid": "65f990fa42c42834f04badc1", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true, "currentPage": 1, "script_old": null, "script": null } ], "hierarchies": [] }