{ "title": "Mode of Sale Analysis", "oid": "63d8052405a5850ed08d9c21", "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": "67868-1AF8-6A", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "253px", "defaultWidth": 512, "widgetid": "63d80d1005a5850ed08d9c24", "autoHeight": "253px" } ], "width": 100, "stretchable": false, "pxlWidth": 0, "index": 0 } ] } ], "pxlWidth": 0, "index": 0 } ], "container": { "sizzle1675103255162": { "undefined": { "parentNode": [ 8994.571368040402, 85, true ] } } } }, "original": null, "dataExploration": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "filters": [ { "instanceid": "FC9C9-92B5-54", "isCascading": true, "levels": [ { "table": "ORDER DETAILS", "column": "Mode of Sale Category", "dim": "[ORDER DETAILS.Mode of Sale Category]", "datatype": "text", "merged": true, "title": "Mode of Sale Category", "collapsed": true, "panel": "scope", "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "ORDER DETAILS", "column": "Mode of Sale", "dim": "[ORDER DETAILS.Mode of Sale]", "datatype": "text", "merged": true, "title": "Mode of Sale", "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "all": true } } ], "model": { "instanceid": "DE1D6-A196-72", "__store": [ "[ORDER DETAILS.Mode of Sale Category]", "[ORDER DETAILS.Mode of Sale]" ] }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Performance Date", "level": "months", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2022-12-01T00:00:00" ] } }, "instanceid": "70BCA-87D5-65", "isCascading": false, "disabled": false }, { "jaql": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Order Date", "level": "years", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "05E42-6845-BD", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2022 Broadway" ] } }, "instanceid": "7377B-5531-73", "isCascading": false, "disabled": false }, { "jaql": { "table": "ORDER DATE", "column": "Calendar Year", "dim": "[TICKET.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900" ] } } }, "instanceid": "F5B4E-0F4E-27", "isCascading": false, "locked": true } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "widgets": [ { "title": "", "subtype": "pivot", "oid": "63d80d1005a5850ed08d9c24", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T12:31:48" }, "selection": null, "metadata": { "drillHistory": [ { "jaql": { "table": "ORDER DETAILS", "column": "Order ID", "dim": "[ORDER DETAILS.Order ID]", "datatype": "numeric", "title": "Order ID" }, "parent": { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Date and Code]", "index": 2 } }, "through": { "jaql": { "datatype": "text", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "title": "Performance Date and Code", "column": "Performance Date and Code", "table": "PERFORMANCE DETAIL", "filter": { "explicit": true, "multiSelection": true, "members": [ "2022-12-09 Fri(E)-MRY120922E" ] } } }, "field": { "id": "[ORDER DETAILS.Order ID]", "index": 2 } } ], "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "ORDER DETAILS", "column": "Mode of Sale", "dim": "[ORDER DETAILS.Mode of Sale]", "datatype": "text", "merged": true, "title": "Mode of Sale" }, "field": { "id": "[ORDER DETAILS.Mode of Sale]", "index": 0 }, "format": { "subtotal": true } }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season" }, "field": { "id": "[SEASON.Season]", "index": 1 }, "format": { "subtotal": true } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code", "dim": "[PERFORMANCE DETAIL.Performance Date and Code]", "datatype": "text", "merged": true, "title": "Performance Date and Code" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Date and Code]", "index": 2 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "([936C9-AB8],[7AA8D-A62])", "context": { "[936C9-AB8]": { "table": "ORDER DETAILS", "column": "Order ID", "dim": "[ORDER DETAILS.Order ID]", "datatype": "numeric", "agg": "count", "title": "# of unique Order ID" }, "[7AA8D-A62]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Unseated, Paid", "Unseated, Unpaid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Requested Orders" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([936C9-AB8],[7AA8D-A62])", "index": 3 } }, { "jaql": { "type": "measure", "formula": "([9AF0C-C7B],[5F4ED-F3B])", "context": { "[9AF0C-C7B]": { "table": "SEAT & TICKET DETAILS", "column": "SLI ID", "dim": "[SEAT & TICKET.SLI ID]", "datatype": "numeric", "agg": "count", "title": "# of unique SLI ID" }, "[5F4ED-F3B]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Unseated, Paid", "Unseated, Unpaid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T12:31:48" } } }, "title": "Requested Tickets" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([9AF0C-C7B],[5F4ED-F3B])", "index": 4 } }, { "jaql": { "type": "measure", "formula": "([C19B6-9C4],[15661-601])", "context": { "[C19B6-9C4]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Value", "dim": "[SEAT & TICKET VALUES.Ticket Value]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Value" }, "[15661-601]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Unseated, Paid", "Unseated, Unpaid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Requested Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([C19B6-9C4],[15661-601])", "index": 5 } }, { "jaql": { "type": "measure", "formula": "([1DAAB-21E],[BE73C-8B9])", "context": { "[1DAAB-21E]": { "table": "ORDER DETAILS", "column": "Order ID", "dim": "[ORDER DETAILS.Order ID]", "datatype": "numeric", "agg": "count", "title": "# of unique Order ID" }, "[BE73C-8B9]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Seated, Unpaid", "Seated, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T12:31:48" } }, "[99643-26F]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Unseated, Paid", "Unseated, Unpaid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Pending Orders" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#e6e6e6" } }, "field": { "id": "([1DAAB-21E],[BE73C-8B9])", "index": 6 } }, { "jaql": { "type": "measure", "formula": "([3B21D-6FD],[B4BD2-B77])", "context": { "[3B21D-6FD]": { "table": "SEAT & TICKET DETAILS", "column": "SLI ID", "dim": "[SEAT & TICKET.SLI ID]", "datatype": "numeric", "agg": "count", "title": "# of unique SLI ID" }, "[B4BD2-B77]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Seated, Unpaid", "Seated, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Pending Tickets" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#e6e6e6" } }, "field": { "id": "([3B21D-6FD],[B4BD2-B77])", "index": 7 } }, { "jaql": { "type": "measure", "formula": "([4BB04-036],[C02D3-78E])", "context": { "[4BB04-036]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Value", "dim": "[SEAT & TICKET VALUES.Ticket Value]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Value" }, "[C02D3-78E]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Seated, Unpaid", "Seated, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Pending Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "#e6e6e6" } }, "field": { "id": "([4BB04-036],[C02D3-78E])", "index": 8 } }, { "jaql": { "type": "measure", "formula": "([6ECF1-D84],[D21B7-C1E])", "context": { "[6ECF1-D84]": { "table": "ORDER DETAILS", "column": "Order ID", "dim": "[ORDER DETAILS.Order ID]", "datatype": "numeric", "agg": "count", "title": "# of unique Order ID" }, "[D21B7-C1E]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticketed, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T12:31:48" } }, "[49ECE-D0B]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Unseated, Paid", "Unseated, Unpaid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Completed Orders" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([6ECF1-D84],[D21B7-C1E])", "index": 9 } }, { "jaql": { "type": "measure", "formula": "([9E7A9-977],[9BAF7-270])", "context": { "[9E7A9-977]": { "table": "SEAT & TICKET DETAILS", "column": "SLI ID", "dim": "[SEAT & TICKET.SLI ID]", "datatype": "numeric", "agg": "count", "title": "# of unique SLI ID" }, "[9BAF7-270]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticketed, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Completed Tickets" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([9E7A9-977],[9BAF7-270])", "index": 10 } }, { "jaql": { "type": "measure", "formula": "([D7CDF-E7C],[41EFB-153])", "context": { "[D7CDF-E7C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Value", "dim": "[SEAT & TICKET VALUES.Ticket Value]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Value" }, "[41EFB-153]": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticketed, Paid" ] }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-01-05T17:31:48.377Z" } } }, "title": "Completed Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([D7CDF-E7C],[41EFB-153])", "index": 11 } } ] }, { "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": "40", "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": true, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "mode_of_sale", "title": "Mode of Sale", "singular": "Mode of Sale", "plural": "Mode of Sale" }, { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "performance_date_and_code", "title": "Performance Date and Code", "singular": "Performance Date and Code", "plural": "Performance Date and Code" } ] }, "rowsGrandTotal": true }, "instanceid": "66D3E-97F0-70", "queryStartTime": "2023-01-30T14:54:44", "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 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "dashboardid": "63d8052405a5850ed08d9c21" } ], "hierarchies": [] }