{ "title": "Churn from Base Season", "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": "8BC57-AE79-70", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "100px", "defaultWidth": 128, "widgetid": "6398e369310ad927acf840de" } ], "width": 100, "stretchable": false, "pxlWidth": 2006, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "44px", "defaultWidth": 128, "widgetid": "6398e369310ad927acf840e2" } ], "width": 100, "stretchable": false, "pxlWidth": 2006, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "340px", "defaultWidth": 512, "widgetid": "6398e369310ad927acf840df", "autoHeight": "271px" } ], "width": 36.68993020937189, "stretchable": false, "pxlWidth": 736, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6398e369310ad927acf840e0", "height": "340px", "autoHeight": "207px" } ], "width": 15.919527006954382, "stretchable": false, "pxlWidth": 319, "index": 1 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6398e369310ad927acf840e1", "height": "340px", "autoHeight": "251px" } ], "width": 47.39054278367372, "stretchable": false, "pxlWidth": 951, "index": 2 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "defaultWidth": 128, "widgetid": "6398e369310ad927acf840e3", "height": "44px" } ], "width": 100, "stretchable": false, "pxlWidth": 2006, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6398e369310ad927acf840e4", "height": "356px", "autoHeight": "287px" } ], "width": 52.44267198404786, "stretchable": false, "pxlWidth": 1052, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6398e369310ad927acf840e5", "height": "356px", "autoHeight": "245px" } ], "width": 47.55732801595214, "stretchable": false, "pxlWidth": 954, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": 128, "defaultWidth": 128, "widgetid": "6398e561310ad927acf840f2" } ], "width": 100, "stretchable": false, "pxlWidth": 2006, "index": 0 } ] } ], "pxlWidth": 2006, "index": 0 } ], "container": { "sizzle1670936878125": { "undefined": { "parentNode": [ 18824, 212, true ] } } } }, "original": null, "oid": "6398e369310ad927acf840dd", "dataExploration": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "filters": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Seasons Back", "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" }, "filter": { "from": -7 } }, "instanceid": "1EF1C-2E9C-7E", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Seasons Since", "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" }, "collapsed": false, "filter": { "from": 2015 } }, "instanceid": "19F23-E0A5-4A", "isCascading": false, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Base Season Buyers", "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" }, "filter": { "top": 1000000, "by": { "type": "measure", "formula": "([8AB80-D50],[879B2-209])", "context": { "[0D13B-B35]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "equals": "2018" }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" } }, "[879B2-209]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "equals": 2015 }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" } }, "[8AB80-D50]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "([Total Ticket Count],[Season Fiscal Year2])" } } }, "instanceid": "247F3-0C39-03", "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Ballet", "Broadway" ] } }, "instanceid": "92F40-4D2A-70", "isCascading": false, "disabled": true }, { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T14:19:45.902Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Subscription" ] } }, "instanceid": "E473F-EDB0-60", "isCascading": false, "disabled": true } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": false }, "filterToDatasourceMapping": {}, "parentFolder": null, "widgets": [ { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T09:19:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "oid": "6398e369310ad927acf840de", "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": "
  1. Seasons Back: Limits the visible set of seasons in the widget. Set to the negative count of seasons back to the base season fiscal year from which retention and churn will be calculated. This applies only to the first row of widgets.
  2. Seasons Since: Limits the visible set of seasons in the widget. Set to the base season fiscal year from which retention and churn will be calculated. This applies only to the second row of widgets.
  3. Base Season Buyers: Limits widget to buyers of a given base season. Edit filter. Click on the formula next to \"by:\" to edit it.  Click on Season Fiscal Year and select Edit Filter to change the desired base fiscal year.
  4. Having to align the Base Season Buyers FY with the other filters is not ideal but necessary. Performance may improve replacing this with a Lists filter of a Tessitura list of constituents from the desired base fiscal year.
  5. Formulas as written only support up to -7 fiscal years back at the moment. 
", "vAlign": "valign-middle", "bgColor": "#FFFFFF", "textAlign": "center" } }, "instanceid": "773E8-E477-94", "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": "6398e369310ad927acf840dd" }, { "title": "", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEASON.Season Fiscal Year]" ], "all": false }, "panels": [ { "name": "rows", "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 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 1 } }, { "jaql": { "type": "measure", "formula": "CASE \nWHEN [7693C-699] = ([7693C-699],ALL([2996C-65E]))\nTHEN [5EDD3-436]\nELSE NULL END", "context": { "[7693C-699]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[5EDD3-436]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "# of unique Constituent ID", "agg": "count" }, "[2996C-65E]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6EF52-A27]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "Base year count in base year only" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 108 }, "field": { "id": "CASE \nWHEN [7693C-699] = ([7693C-699],ALL([2996C-65E]))\nTHEN [5EDD3-436]\nELSE NULL END", "index": 2 } }, { "jaql": { "type": "measure", "formula": "([3C847-F3A],[091DD-D08])", "context": { "[3C847-F3A]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[091DD-D08]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "Base year count in every year" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 96 }, "field": { "id": "([3C847-F3A],[091DD-D08])", "index": 3 } }, { "jaql": { "type": "measure", "formula": "CASE\nWHEN [26CD7-302] = 0\nTHEN ([6031A-FEA],[BFF77-2E7],ALL([DD0FE-366])) - ([6031A-FEA],[D5215-30B],ALL([DD0FE-366]))\nELSE NULL END", "context": { "[26CD7-302]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[E66D1-198]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -122 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[D5215-30B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BFF77-2E7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": 0 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6031A-FEA]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[DD0FE-366]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "2022 churn" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE\nWHEN [26CD7-302] = 0\nTHEN ([6031A-FEA],[BFF77-2E7],ALL([DD0FE-366])) - ([6031A-FEA],[D5215-30B],ALL([DD0FE-366]))\nELSE NULL END", "index": 4 } }, { "jaql": { "type": "measure", "formula": "CASE\nWHEN [A0F6F-12F] = 0\nTHEN ([A7AD3-0FA],[81D14-9F6],ALL([E2D09-60C])) \nELSE NULL END", "context": { "[A0F6F-12F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[A6ED8-2B3]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -122 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[81D14-9F6]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A7AD3-0FA]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[E2D09-60C]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "2022 retained" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE\nWHEN [A0F6F-12F] = 0\nTHEN ([A7AD3-0FA],[81D14-9F6],ALL([E2D09-60C])) \nELSE NULL END", "index": 5 } }, { "jaql": { "type": "measure", "formula": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "context": { "[ED455-E23]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[95B21-98B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -9 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A69EC-9AC]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -10 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[C85CF-4F0]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9D31A-957]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[38287-35C]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FDE0C-0D2]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FF33A-EB7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[DAB2D-03E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[3F243-2CD]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[5E9EC-69B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[2C5D7-48F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[48C7B-1BF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4019D-E44]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[45368-BA3]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "retained" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "index": 6 } }, { "jaql": { "type": "measure", "formula": "([BC962-990],[21821-95C]) - CASE\nWHEN [4B125-117] = -10 THEN ([BC962-990],[3B12E-568],ALL([21821-95C])) \nWHEN [4B125-117] = -9 THEN ([BC962-990],[22A81-D99],ALL([21821-95C])) \nWHEN [4B125-117] = -8 THEN ([BC962-990],[8FEF7-C56],ALL([21821-95C])) \nWHEN [4B125-117] = -7 THEN ([BC962-990],[16305-8AE],ALL([21821-95C])) \nWHEN [4B125-117] = -6 THEN ([BC962-990],[FE26E-FDC],ALL([21821-95C])) \nWHEN [4B125-117] = -5 THEN ([BC962-990],[6041F-552],ALL([21821-95C])) \nWHEN [4B125-117] = -4 THEN ([BC962-990],[57710-B37],ALL([21821-95C])) \nWHEN [4B125-117] = -3 THEN ([BC962-990],[BB606-8AD],ALL([21821-95C])) \nWHEN [4B125-117] = -2 THEN ([BC962-990],[1D480-008],ALL([21821-95C])) \nWHEN [4B125-117] = -1 THEN ([BC962-990],[B4FDF-940],ALL([21821-95C])) \nWHEN [4B125-117] = 0 THEN ([BC962-990],[243E6-F8A],ALL([21821-95C])) \nWHEN [4B125-117] = 1 THEN ([BC962-990],[9726C-D32],ALL([21821-95C])) \nELSE NULL END", "context": { "[4B125-117]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[9726C-D32]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[243E6-F8A]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 0 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[B4FDF-940]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[1D480-008]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BB606-8AD]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[57710-B37]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6041F-552]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FE26E-FDC]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[16305-8AE]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[8FEF7-C56]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[22A81-D99]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -9 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[3B12E-568]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -10 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BC962-990]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[21821-95C]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "churned (base-retained)" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([BC962-990],[21821-95C]) - CASE\nWHEN [4B125-117] = -10 THEN ([BC962-990],[3B12E-568],ALL([21821-95C])) \nWHEN [4B125-117] = -9 THEN ([BC962-990],[22A81-D99],ALL([21821-95C])) \nWHEN [4B125-117] = -8 THEN ([BC962-990],[8FEF7-C56],ALL([21821-95C])) \nWHEN [4B125-117] = -7 THEN ([BC962-990],[16305-8AE],ALL([21821-95C])) \nWHEN [4B125-117] = -6 THEN ([BC962-990],[FE26E-FDC],ALL([21821-95C])) \nWHEN [4B125-117] = -5 THEN ([BC962-990],[6041F-552],ALL([21821-95C])) \nWHEN [4B125-117] = -4 THEN ([BC962-990],[57710-B37],ALL([21821-95C])) \nWHEN [4B125-117] = -3 THEN ([BC962-990],[BB606-8AD],ALL([21821-95C])) \nWHEN [4B125-117] = -2 THEN ([BC962-990],[1D480-008],ALL([21821-95C])) \nWHEN [4B125-117] = -1 THEN ([BC962-990],[B4FDF-940],ALL([21821-95C])) \nWHEN [4B125-117] = 0 THEN ([BC962-990],[243E6-F8A],ALL([21821-95C])) \nWHEN [4B125-117] = 1 THEN ([BC962-990],[9726C-D32],ALL([21821-95C])) \nELSE NULL END", "index": 7 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "6398e369310ad927acf840df", "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": "season_fiscal_year", "title": "Season Fiscal Year", "singular": "Season Fiscal Year", "plural": "Season Fiscal Year" } ] } }, "instanceid": "DD9E2-5F90-2E", "queryStartTime": "2022-12-13T15:11:49", "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": 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, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6398e369310ad927acf840dd", "viewState": { "activeTab": "filters" } }, { "title": "", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T09:19:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEASON.Season Fiscal Year]" ], "all": false }, "panels": [ { "name": "rows", "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 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "CASE WHEN [989AF-A43] = -7 THEN ([E69DD-DBE],[757F3-706],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -6 THEN ([E69DD-DBE],[F9111-947],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -5 THEN ([E69DD-DBE],[AD3E7-975],ALL([52FD2-7E9])) WHEN [989AF-A43] = -4\nTHEN ([E69DD-DBE],[29334-525],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -3 THEN ([E69DD-DBE],[85B7B-F81],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -2 THEN ([E69DD-DBE],[EFE4E-EF8],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -1 THEN ([E69DD-DBE],[B7454-DCF],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 0 THEN ([E69DD-DBE],[6919B-9CA],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 1 THEN ([E69DD-DBE],[53A0C-1D5],ALL([52FD2-7E9])) \nELSE NULL END / ([E69DD-DBE],[52FD2-7E9])\n ", "context": { "[989AF-A43]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[6919B-9CA]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[B7454-DCF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[EFE4E-EF8]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[85B7B-F81]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[29334-525]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[AD3E7-975]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[F9111-947]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[53A0C-1D5]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[757F3-706]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[E69DD-DBE]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[52FD2-7E9]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "retained" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE WHEN [989AF-A43] = -7 THEN ([E69DD-DBE],[757F3-706],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -6 THEN ([E69DD-DBE],[F9111-947],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -5 THEN ([E69DD-DBE],[AD3E7-975],ALL([52FD2-7E9])) WHEN [989AF-A43] = -4\nTHEN ([E69DD-DBE],[29334-525],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -3 THEN ([E69DD-DBE],[85B7B-F81],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -2 THEN ([E69DD-DBE],[EFE4E-EF8],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -1 THEN ([E69DD-DBE],[B7454-DCF],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 0 THEN ([E69DD-DBE],[6919B-9CA],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 1 THEN ([E69DD-DBE],[53A0C-1D5],ALL([52FD2-7E9])) \nELSE NULL END / ([E69DD-DBE],[52FD2-7E9])\n ", "index": 1 } }, { "jaql": { "type": "measure", "formula": "1-CASE WHEN [FEA58-3BA] = -7 THEN ([A3F81-5EC],[53A4F-49D],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -6 THEN ([A3F81-5EC],[E1A7E-D0A],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -5 THEN ([A3F81-5EC],[40F64-3A8],ALL([09FE2-2B2])) WHEN [FEA58-3BA] = -4\nTHEN ([A3F81-5EC],[4E5BC-876],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -3 THEN ([A3F81-5EC],[076DA-062],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -2 THEN ([A3F81-5EC],[CDD3E-8C3],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -1 THEN ([A3F81-5EC],[7A913-D8E],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = 0 THEN ([A3F81-5EC],[76005-E0E],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = 1 THEN ([A3F81-5EC],[BA01E-515],ALL([09FE2-2B2])) \nELSE NULL END / ([A3F81-5EC],[09FE2-2B2])\n ", "context": { "[FEA58-3BA]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[76005-E0E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[7A913-D8E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[CDD3E-8C3]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[076DA-062]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4E5BC-876]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[40F64-3A8]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[E1A7E-D0A]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BA01E-515]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[53A4F-49D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A3F81-5EC]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[09FE2-2B2]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "churned" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "1-CASE WHEN [FEA58-3BA] = -7 THEN ([A3F81-5EC],[53A4F-49D],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -6 THEN ([A3F81-5EC],[E1A7E-D0A],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -5 THEN ([A3F81-5EC],[40F64-3A8],ALL([09FE2-2B2])) WHEN [FEA58-3BA] = -4\nTHEN ([A3F81-5EC],[4E5BC-876],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -3 THEN ([A3F81-5EC],[076DA-062],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -2 THEN ([A3F81-5EC],[CDD3E-8C3],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = -1 THEN ([A3F81-5EC],[7A913-D8E],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = 0 THEN ([A3F81-5EC],[76005-E0E],ALL([09FE2-2B2])) \nWHEN [FEA58-3BA] = 1 THEN ([A3F81-5EC],[BA01E-515],ALL([09FE2-2B2])) \nELSE NULL END / ([A3F81-5EC],[09FE2-2B2])\n ", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "6398e369310ad927acf840e0", "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": "season_fiscal_year", "title": "Season Fiscal Year", "singular": "Season Fiscal Year", "plural": "Season Fiscal Year" } ] } }, "instanceid": "DD9E2-5F90-2E", "queryStartTime": "2022-12-13T15:08:35", "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, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6398e369310ad927acf840dd", "drawing": true, "viewState": { "activeTab": "filters" } }, { "title": "", "subtype": "column/stackedcolumn", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEASON.Season Fiscal Year]" ], "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 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "CASE WHEN [B5A9D-663] = -8 THEN ([44125-0DD],[9F2AF-6DF],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -7 THEN ([44125-0DD],[6A07E-EAB],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -6 THEN ([44125-0DD],[5320C-53A],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -5 THEN ([44125-0DD],[06369-B2E],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -4THEN ([44125-0DD],[D38E0-0D7],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -3 THEN ([44125-0DD],[917B0-ECE],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -2 THEN ([44125-0DD],[44838-C1A],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = -1 THEN ([44125-0DD],[AB77C-6CE],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = 0 THEN ([44125-0DD],[B2D3D-B46],ALL([78DE8-BC7])) \nWHEN [B5A9D-663] = 1 THEN ([44125-0DD],[927A4-7FC],ALL([78DE8-BC7])) \nELSE NULL END / ([44125-0DD],[78DE8-BC7])\n ", "context": { "[B5A9D-663]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[927A4-7FC]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[B2D3D-B46]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[AB77C-6CE]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[44838-C1A]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[917B0-ECE]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[D38E0-0D7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[06369-B2E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[5320C-53A]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9F2AF-6DF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6A07E-EAB]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[44125-0DD]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[78DE8-BC7]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "% of Patrons Retained" }, "format": { "mask": { "decimals": 0, "percent": true, "percentMultiplier": 100 }, "color": { "type": "color", "color": "#547a94" } }, "field": { "id": "CASE WHEN [989AF-A43] = -7 THEN ([E69DD-DBE],[757F3-706],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -6 THEN ([E69DD-DBE],[F9111-947],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -5 THEN ([E69DD-DBE],[AD3E7-975],ALL([52FD2-7E9])) WHEN [989AF-A43] = -4\nTHEN ([E69DD-DBE],[29334-525],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -3 THEN ([E69DD-DBE],[85B7B-F81],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -2 THEN ([E69DD-DBE],[EFE4E-EF8],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = -1 THEN ([E69DD-DBE],[B7454-DCF],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 0 THEN ([E69DD-DBE],[6919B-9CA],ALL([52FD2-7E9])) \nWHEN [989AF-A43] = 1 THEN ([E69DD-DBE],[53A0C-1D5],ALL([52FD2-7E9])) \nELSE NULL END / ([E69DD-DBE],[52FD2-7E9])\n ", "index": 1 } }, { "jaql": { "type": "measure", "formula": "-1+CASE WHEN [E694C-71C] = -8 THEN ([34942-BC4],[6A6A1-F62],ALL([F1D07-611])) \nWHEN [E694C-71C] = -7 THEN ([34942-BC4],[6A6A1-F62],ALL([F1D07-611])) \nWHEN [E694C-71C] = -6 THEN ([34942-BC4],[2742B-D9E],ALL([F1D07-611])) \nWHEN [E694C-71C] = -5 THEN ([34942-BC4],[D9BDA-C5B],ALL([F1D07-611])) WHEN [E694C-71C] = -4\nTHEN ([34942-BC4],[6F4DF-094],ALL([F1D07-611])) \nWHEN [E694C-71C] = -3 THEN ([34942-BC4],[62408-B12],ALL([F1D07-611])) \nWHEN [E694C-71C] = -2 THEN ([34942-BC4],[276F7-204],ALL([F1D07-611])) \nWHEN [E694C-71C] = -1 THEN ([34942-BC4],[919C1-9EB],ALL([F1D07-611])) \nWHEN [E694C-71C] = 0 THEN ([34942-BC4],[9ED6E-48E],ALL([F1D07-611])) \nWHEN [E694C-71C] = 1 THEN ([34942-BC4],[049AF-E24],ALL([F1D07-611])) \nELSE NULL END / ([34942-BC4],[F1D07-611])\n ", "context": { "[E694C-71C]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[049AF-E24]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9ED6E-48E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[919C1-9EB]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[276F7-204]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[62408-B12]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6F4DF-094]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[D9BDA-C5B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[2742B-D9E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6A6A1-F62]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[34942-BC4]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[F1D07-611]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "% of Patrons Churned" }, "format": { "mask": { "decimals": 0, "percent": true, "percentMultiplier": 100 }, "color": { "type": "color", "color": "#6fa1c3" } }, "field": { "id": "-1+CASE WHEN [97F78-217] = -7 THEN ([DB3F2-F8D],[60D5B-25C],ALL([A4E20-4BE])) \nWHEN [97F78-217] = -6 THEN ([DB3F2-F8D],[71A05-E30],ALL([A4E20-4BE])) \nWHEN [97F78-217] = -5 THEN ([DB3F2-F8D],[ABFA4-9D0],ALL([A4E20-4BE])) WHEN [97F78-217] = -4\nTHEN ([DB3F2-F8D],[4786A-04C],ALL([A4E20-4BE])) \nWHEN [97F78-217] = -3 THEN ([DB3F2-F8D],[04085-C37],ALL([A4E20-4BE])) \nWHEN [97F78-217] = -2 THEN ([DB3F2-F8D],[74F75-653],ALL([A4E20-4BE])) \nWHEN [97F78-217] = -1 THEN ([DB3F2-F8D],[7814D-915],ALL([A4E20-4BE])) \nWHEN [97F78-217] = 0 THEN ([DB3F2-F8D],[7E2AD-51C],ALL([A4E20-4BE])) \nELSE NULL END / ([DB3F2-F8D],[A4E20-4BE])\n ", "index": 2 } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "6398e369310ad927acf840e1", "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": true, "types": { "count": false, "percentage": false, "relative": false, "totals": true }, "stacked": true, "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": "4EF21-43C3-82", "queryStartTime": "2022-12-13T16:00:49", "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, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 7 } }, "dashboardid": "6398e369310ad927acf840dd", "drawing": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "filters" } }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T09:19:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "oid": "6398e369310ad927acf840e2", "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": "3 widgets below use Seasons Back Filter (they ignore Seasons Since)", "vAlign": "valign-middle", "bgColor": "#e6e6e6", "textAlign": "center" } }, "instanceid": "6023D-A850-41", "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": "6398e369310ad927acf840dd" }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T09:19:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "oid": "6398e369310ad927acf840e3", "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": "2 widgets below use Seasons Since Filter (they ignore Seasons Back)
", "vAlign": "valign-middle", "bgColor": "#e6e6e6", "textAlign": "center" } }, "instanceid": "6023D-A850-41", "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 }, "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": "6398e369310ad927acf840dd" }, { "title": "", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEASON.Season Fiscal Current Year Offset]" ], "all": false }, "panels": [ { "name": "rows", "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 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 1 } }, { "jaql": { "type": "measure", "formula": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "context": { "[ED455-E23]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[95B21-98B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -9 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A69EC-9AC]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -10 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[C85CF-4F0]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9D31A-957]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[38287-35C]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FDE0C-0D2]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FF33A-EB7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[DAB2D-03E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[3F243-2CD]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[5E9EC-69B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[2C5D7-48F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[48C7B-1BF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4019D-E44]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[45368-BA3]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "retained" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "index": 2 } }, { "jaql": { "type": "measure", "formula": "CASE WHEN [544BA-23D] = -7 THEN ([61891-F85],[75185-CF5],ALL([9AD75-AA6])) - ([61891-F85],[C51F6-781],ALL([9AD75-AA6])) WHEN [544BA-23D] = -6 THEN ([61891-F85],[D4F6B-396],ALL([9AD75-AA6])) - ([61891-F85],[F331D-4A6],ALL([9AD75-AA6])) WHEN [544BA-23D] = -5 THEN ([61891-F85],[41068-300],ALL([9AD75-AA6])) - ([61891-F85],[6333F-D61],ALL([9AD75-AA6])) WHEN [544BA-23D] = -4 THEN ([61891-F85],[BE675-8F7],ALL([9AD75-AA6])) - ([61891-F85],[DB194-408],ALL([9AD75-AA6])) WHEN [544BA-23D] = -3 THEN ([61891-F85],[F468B-FBB],ALL([9AD75-AA6])) - ([61891-F85],[76C7A-1B4],ALL([9AD75-AA6])) WHEN [544BA-23D] = -2 THEN ([61891-F85],[88D98-278],ALL([9AD75-AA6])) - ([61891-F85],[2BC1A-7A3],ALL([9AD75-AA6])) WHEN [544BA-23D] = -1 THEN ([61891-F85],[20B63-74A],ALL([9AD75-AA6])) - ([61891-F85],[96D2B-4A5],ALL([9AD75-AA6])) WHEN [544BA-23D] = 0 THEN ([61891-F85],[BE2D8-3DA],ALL([9AD75-AA6])) - ([61891-F85],[323BC-9D0],ALL([9AD75-AA6])) WHEN [544BA-23D] = 1 THEN ([61891-F85],[64C71-0A5],ALL([9AD75-AA6])) - ([61891-F85],[99047-055],ALL([9AD75-AA6])) ELSE NULL END", "context": { "[544BA-23D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[99047-055]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[64C71-0A5]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[323BC-9D0]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BE2D8-3DA]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[96D2B-4A5]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[20B63-74A]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[2BC1A-7A3]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[88D98-278]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[76C7A-1B4]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[F468B-FBB]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[DB194-408]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[BE675-8F7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6333F-D61]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[41068-300]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[F331D-4A6]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[D4F6B-396]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[C51F6-781]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[75185-CF5]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[61891-F85]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[9AD75-AA6]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "churn" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE WHEN [544BA-23D] = -7 THEN ([61891-F85],[75185-CF5],ALL([9AD75-AA6])) - ([61891-F85],[C51F6-781],ALL([9AD75-AA6])) WHEN [544BA-23D] = -6 THEN ([61891-F85],[D4F6B-396],ALL([9AD75-AA6])) - ([61891-F85],[F331D-4A6],ALL([9AD75-AA6])) WHEN [544BA-23D] = -5 THEN ([61891-F85],[41068-300],ALL([9AD75-AA6])) - ([61891-F85],[6333F-D61],ALL([9AD75-AA6])) WHEN [544BA-23D] = -4 THEN ([61891-F85],[BE675-8F7],ALL([9AD75-AA6])) - ([61891-F85],[DB194-408],ALL([9AD75-AA6])) WHEN [544BA-23D] = -3 THEN ([61891-F85],[F468B-FBB],ALL([9AD75-AA6])) - ([61891-F85],[76C7A-1B4],ALL([9AD75-AA6])) WHEN [544BA-23D] = -2 THEN ([61891-F85],[88D98-278],ALL([9AD75-AA6])) - ([61891-F85],[2BC1A-7A3],ALL([9AD75-AA6])) WHEN [544BA-23D] = -1 THEN ([61891-F85],[20B63-74A],ALL([9AD75-AA6])) - ([61891-F85],[96D2B-4A5],ALL([9AD75-AA6])) WHEN [544BA-23D] = 0 THEN ([61891-F85],[BE2D8-3DA],ALL([9AD75-AA6])) - ([61891-F85],[323BC-9D0],ALL([9AD75-AA6])) WHEN [544BA-23D] = 1 THEN ([61891-F85],[64C71-0A5],ALL([9AD75-AA6])) - ([61891-F85],[99047-055],ALL([9AD75-AA6])) ELSE NULL END", "index": 3 } }, { "jaql": { "type": "measure", "formula": "([94B17-6C3],[38F4C-993])", "context": { "[94B17-6C3]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[38F4C-993]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "bottom": 1, "by": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min" } }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "can't get base year count on every row" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 113 }, "field": { "id": "([94B17-6C3],[38F4C-993])", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "6398e369310ad927acf840e4", "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": "season_fiscal_year", "title": "Season Fiscal Year", "singular": "Season Fiscal Year", "plural": "Season Fiscal Year" } ] } }, "instanceid": "DD9E2-5F90-2E", "queryStartTime": "2022-12-13T15:15:34", "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, "viewState": { "activeTab": "filters" }, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6398e369310ad927acf840dd", "drawing": true }, { "title": "", "subtype": "column/stackedcolumn", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[SEASON.Season Fiscal Current Year Offset]" ], "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 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "context": { "[ED455-E23]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[95B21-98B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -9 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A69EC-9AC]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -10 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[C85CF-4F0]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9D31A-957]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "0" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[38287-35C]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FDE0C-0D2]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[FF33A-EB7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[DAB2D-03E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[3F243-2CD]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[5E9EC-69B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[2C5D7-48F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[48C7B-1BF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -8 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4019D-E44]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[45368-BA3]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "# of Patrons Retained" }, "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": "CASE\nWHEN [ED455-E23] = -10 THEN ([4019D-E44],[A69EC-9AC],ALL([45368-BA3])) \nWHEN [ED455-E23] = -9 THEN ([4019D-E44],[95B21-98B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -8 THEN ([4019D-E44],[48C7B-1BF],ALL([45368-BA3])) \nWHEN [ED455-E23] = -7 THEN ([4019D-E44],[2C5D7-48F],ALL([45368-BA3])) \nWHEN [ED455-E23] = -6 THEN ([4019D-E44],[5E9EC-69B],ALL([45368-BA3])) \nWHEN [ED455-E23] = -5 THEN ([4019D-E44],[3F243-2CD],ALL([45368-BA3])) \nWHEN [ED455-E23] = -4 THEN ([4019D-E44],[DAB2D-03E],ALL([45368-BA3])) \nWHEN [ED455-E23] = -3 THEN ([4019D-E44],[FF33A-EB7],ALL([45368-BA3])) \nWHEN [ED455-E23] = -2 THEN ([4019D-E44],[FDE0C-0D2],ALL([45368-BA3])) \nWHEN [ED455-E23] = -1 THEN ([4019D-E44],[38287-35C],ALL([45368-BA3])) \nWHEN [ED455-E23] = 0 THEN ([4019D-E44],[9D31A-957],ALL([45368-BA3])) \nWHEN [ED455-E23] = 1 THEN ([4019D-E44],[C85CF-4F0],ALL([45368-BA3])) \nELSE NULL END", "index": 1 } }, { "jaql": { "type": "measure", "formula": "-1*CASE \nWHEN [4DC5E-0B8] = -7 THEN ([F813D-54D],[6B53C-D95],ALL([96508-960])) - ([F813D-54D],[B6AB4-F58],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -6 THEN ([F813D-54D],[9F7B1-772],ALL([96508-960])) - ([F813D-54D],[DE519-2B7],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -5 THEN ([F813D-54D],[09A0C-837],ALL([96508-960])) - ([F813D-54D],[47336-D05],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -4 THEN ([F813D-54D],[C733C-01D],ALL([96508-960])) - ([F813D-54D],[1627D-960],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -3 THEN ([F813D-54D],[62840-370],ALL([96508-960])) - ([F813D-54D],[4CFFD-B5E],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -2 THEN ([F813D-54D],[4134E-4DE],ALL([96508-960])) - ([F813D-54D],[13D73-F61],ALL([96508-960])) \nWHEN [4DC5E-0B8] = -1 THEN ([F813D-54D],[7E215-55F],ALL([96508-960])) - ([F813D-54D],[A3CEB-02D],ALL([96508-960])) \nWHEN [4DC5E-0B8] = 0 THEN ([F813D-54D],[25B3F-AAF],ALL([96508-960])) - ([F813D-54D],[F157B-C1B],ALL([96508-960])) \nWHEN [4DC5E-0B8] = 1 THEN ([F813D-54D],[A55CF-1CF],ALL([96508-960])) - ([F813D-54D],[1614E-E64],ALL([96508-960])) ELSE NULL END", "context": { "[4DC5E-0B8]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "min", "title": "Min Season Fiscal Current Year Offset" }, "[F157B-C1B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": 0 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[25B3F-AAF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": 0 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A3CEB-02D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[7E215-55F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[13D73-F61]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4134E-4DE]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -2 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[1614E-E64]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": "1" }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[A55CF-1CF]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": 1 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[4CFFD-B5E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[62840-370]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -3 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[1627D-960]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[C733C-01D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -4 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[47336-D05]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[09A0C-837]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -5 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[DE519-2B7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[9F7B1-772]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -6 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[B6AB4-F58]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "from": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[6B53C-D95]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "to": -7 }, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets" } }, "[F813D-54D]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[96508-960]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" } }, "title": "# of Patrons Churned" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#6fa1c3" } }, "field": { "id": "CASE WHEN [544BA-23D] = -7 THEN ([61891-F85],[75185-CF5],ALL([9AD75-AA6])) - ([61891-F85],[C51F6-781],ALL([9AD75-AA6])) WHEN [544BA-23D] = -6 THEN ([61891-F85],[D4F6B-396],ALL([9AD75-AA6])) - ([61891-F85],[F331D-4A6],ALL([9AD75-AA6])) WHEN [544BA-23D] = -5 THEN ([61891-F85],[41068-300],ALL([9AD75-AA6])) - ([61891-F85],[6333F-D61],ALL([9AD75-AA6])) WHEN [544BA-23D] = -4 THEN ([61891-F85],[BE675-8F7],ALL([9AD75-AA6])) - ([61891-F85],[DB194-408],ALL([9AD75-AA6])) WHEN [544BA-23D] = -3 THEN ([61891-F85],[F468B-FBB],ALL([9AD75-AA6])) - ([61891-F85],[76C7A-1B4],ALL([9AD75-AA6])) WHEN [544BA-23D] = -2 THEN ([61891-F85],[88D98-278],ALL([9AD75-AA6])) - ([61891-F85],[2BC1A-7A3],ALL([9AD75-AA6])) WHEN [544BA-23D] = -1 THEN ([61891-F85],[20B63-74A],ALL([9AD75-AA6])) - ([61891-F85],[96D2B-4A5],ALL([9AD75-AA6])) WHEN [544BA-23D] = 0 THEN ([61891-F85],[BE2D8-3DA],ALL([9AD75-AA6])) - ([61891-F85],[323BC-9D0],ALL([9AD75-AA6])) WHEN [544BA-23D] = 1 THEN ([61891-F85],[64C71-0A5],ALL([9AD75-AA6])) - ([61891-F85],[99047-055],ALL([9AD75-AA6])) ELSE NULL END", "index": 2 } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "6398e369310ad927acf840e5", "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": true, "types": { "count": false, "percentage": false, "relative": false, "totals": true }, "stacked": true, "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": "96D57-6F4B-BF", "queryStartTime": "2022-12-13T16:00:49", "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": 7 } }, "dashboardid": "6398e369310ad927acf840dd", "drawing": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false }, { "title": "RICHTEXT_MAIN.TITLE", "subtype": "richtexteditor", "oid": "6398e561310ad927acf840f2", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "CWALLINGFORD-TN/Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-12-08T09:19:45" }, "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": "
Why can't we get percentages when we use Seasons Since, which is more intuitive for users than Seasons Back?
If churn counts from the base season are more desirable than percentages, then the easier to use Seasons Since paired with the lower churn widget will suffice. If percentages are more desirable, than Seasons Back in concert with the upper widget will be better suited.

Pivot table widgets are included merely as \"showing work\".
", "vAlign": "valign-middle", "bgColor": "#FFFFFF", "textAlign": "center" } }, "instanceid": "F92C1-4647-39", "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": "6398e369310ad927acf840dd" } ], "hierarchies": [] }