{ "title": "Renewal Segments", "oid": "65e2147d9f9eda0c9818e1d3", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "65e2154f9f9eda0c9818e1d7" } ], "index": 0, "stretchable": false, "width": 100 } ] } ] } ] }, "original": null, "dataExploration": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" }, "filters": [], "editing": true, "parentFolder": "64f0199f04671c3bdc58efdc", "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "Package count over years split by Subcription Subset", "subtype": "bar/stacked", "oid": "65e2154f9f9eda0c9818e1d7", "desc": null, "source": null, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "drillHistory": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "parent": { "jaql": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset" }, "disabled": false }, "through": { "jaql": { "datatype": "numeric", "dim": "[SEASON.Season Fiscal Current Year Offset]", "title": "Season Fiscal Current Year Offset", "column": "Season Fiscal Current Year Offset", "table": "SEASON", "filter": { "explicit": true, "multiSelection": true, "members": [ "-5" ] } } }, "disabled": true } ], "ignore": { "dimensions": [ "[SEASON.Season Fiscal Current Year Offset]", "[CONSTITUENT.Constituent ID]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset" }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "\n( [7FB68-B9B], [B9959-B95] )", "context": { "[8B037-A12]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[B9959-B95]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[7FB68-B9B]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" } }, "title": "Total Subs" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#618caa", "type": "color" } }, "singleSeriesType": "line" }, { "jaql": { "type": "measure", "formula": "CASE WHEN [63B95-754] = 0\nTHEN\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [BB5CC-03B], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [734D8-403], [361DA-259]))\n , ( [800E9-187], [BB5CC-03B], [361DA-259] )\n , NULL )\n )\n\n\n\n-\n\n\n\n\n\n\n\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [BB5CC-03B], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [734D8-403], [361DA-259]))\n AND\n (([D2A67-704], [734D8-403])) > 0\n , ( [800E9-187], [BB5CC-03B], [361DA-259] )\n , NULL )\n ) \n \n \n \nWHEN [63B95-754] = -1\nTHEN\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [8FBBB-08C], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [C027E-32D], [361DA-259]))\n , ( [800E9-187], [8FBBB-08C], [361DA-259] )\n , NULL )\n )\n\n\n\n-\n\n\n\n\n\n\n\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [8FBBB-08C], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [C027E-32D], [361DA-259]))\n AND\n (([D2A67-704], [C027E-32D])) > 0\n , ( [800E9-187], [8FBBB-08C], [361DA-259] )\n , NULL )\n ) \n \n \n \n \nWHEN [63B95-754] = -2\nTHEN\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [FDB76-C09], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [246B3-BE7], [361DA-259]))\n , ( [800E9-187], [FDB76-C09], [361DA-259] )\n , NULL )\n )\n\n\n\n-\n\n\n\n\n\n\n\nSUM ( [16C98-0CC] ,\n IF ( ([86C7D-6B1], [FDB76-C09], [361DA-259] ) > 0\n AND\n ISNULL(([86C7D-6B1], [246B3-BE7], [361DA-259]))\n AND\n (([D2A67-704], [246B3-BE7])) > 0\n , ( [800E9-187], [FDB76-C09], [361DA-259] )\n , NULL )\n ) \n \nELSE NULL END", "context": { "[8FBBB-08C]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -1 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[BB5CC-03B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[FDB76-C09]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset -2 (2022)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[C027E-32D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -1", "filter": { "toNotEqual": "-1" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[246B3-BE7]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -2", "filter": { "toNotEqual": "-2" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[734D8-403]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < 0", "filter": { "toNotEqual": "0" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[63B95-754]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Current Year Offset" }, "[361DA-259]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[800E9-187]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" }, "[86C7D-6B1]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE DETAIL.Package ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[D2A67-704]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[16C98-0CC]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "New to Lyric" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "color": "#547A94", "type": "color" } }, "field": { "id": "SUM ( [67C09-DBE] ,\n IF ( ISNULL ( ( [C7772-6D4] , [49CF7-350] , [807C7-6DA] ) )\n AND ( [C7772-6D4] , [49CF7-350] , [B6B69-F09] ) > 0\n , ( [183C3-32D] , [49CF7-350] )\n , NULL )\n )", "index": 1 }, "singleSeriesType": "bar" }, { "jaql": { "type": "measure", "formula": "CASE WHEN [4EC88-C85] = 0\nTHEN\nSUM ( [2C6E6-B7A] ,\n IF ( ([5310D-FA1], [E2BBF-2C5], [AA6F3-D85] ) > 0\n AND ([5310D-FA1], [0AF4B-C14], [AA6F3-D85]) > 0\n , ( [62B28-379], [E2BBF-2C5], [AA6F3-D85] )\n , NULL )\n ) \n \n \nWHEN [4EC88-C85] = -1\nTHEN\nSUM ( [2C6E6-B7A] ,\n IF ( ([5310D-FA1], [0AF4B-C14], [AA6F3-D85] ) > 0\n AND ([5310D-FA1], [5D625-EBA], [AA6F3-D85]) > 0\n , ( [62B28-379], [0AF4B-C14], [AA6F3-D85] )\n , NULL )\n ) \n \nWHEN [4EC88-C85] = -2\nTHEN\nSUM ( [2C6E6-B7A] ,\n IF ( ([5310D-FA1], [5D625-EBA], [AA6F3-D85] ) > 0\n AND ([5310D-FA1], [AE9A2-931], [AA6F3-D85]) > 0\n , ( [62B28-379], [5D625-EBA], [AA6F3-D85] )\n , NULL )\n )\n \nELSE NULL END", "context": { "[AE9A2-931]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -3 (2021)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-3" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[5E35B-134]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -2 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[0AF4B-C14]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -1 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[5D625-EBA]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -2 (2022)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[E2BBF-2C5]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[4EC88-C85]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Current Year Offset" }, "[AA6F3-D85]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[62B28-379]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" }, "[5310D-FA1]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE DETAIL.Package ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[2C6E6-B7A]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "Renew" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "SUM ( [D10B2-8D2] ,\n IF ( ( [0E906-356] , [26C87-E27] , [1F7B5-C6F] ) > 0\n AND ( [0E906-356] , [26C87-E27] , [C4711-62B] ) > 0\n , ( [A4046-210] , [26C87-E27] )\n , NULL )\n )", "index": 2 }, "singleSeriesType": "bar" }, { "jaql": { "type": "measure", "formula": "Case WHEN [69523-398] = 0\nTHEN\n(( [50B29-F1A], [29303-0A2], [7E79E-971] ))\n\n-\n\nSUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [29303-0A2], [7E79E-971] ) > 0\n AND\n ISNULL(([3C5D9-A7A], [EEB30-83D], [7E79E-971]))\n , ( [50B29-F1A], [29303-0A2], [7E79E-971] )\n , NULL )\n )\n \n-\n \n \n SUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [29303-0A2], [7E79E-971] ) > 0\n AND ([3C5D9-A7A], [8D50A-93E], [7E79E-971]) > 0\n , ( [50B29-F1A], [29303-0A2], [7E79E-971] )\n , NULL )\n )\n\n\nWHEN [69523-398] = -1\nTHEN\n(( [50B29-F1A], [8D50A-93E], [7E79E-971] ))\n\n-\n\nSUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [8D50A-93E], [7E79E-971] ) > 0\n AND\n ISNULL(([3C5D9-A7A], [02DD4-24D], [7E79E-971]))\n , ( [50B29-F1A],[8D50A-93E], [7E79E-971] )\n , NULL )\n )\n \n-\n \n \n SUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [8D50A-93E], [7E79E-971] ) > 0\n AND ([3C5D9-A7A], [5C477-A2D], [7E79E-971]) > 0\n , ( [50B29-F1A], [8D50A-93E], [7E79E-971] )\n , NULL )\n )\n\nWHEN [69523-398] = -2\nTHEN\n(( [50B29-F1A], [5C477-A2D], [7E79E-971] ))\n\n-\n\nSUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [5C477-A2D], [7E79E-971] ) > 0\n AND\n ISNULL(([3C5D9-A7A], [A1C64-4BD], [7E79E-971]))\n , ( [50B29-F1A],[5C477-A2D], [7E79E-971] )\n , NULL )\n )\n \n-\n \n \n SUM ( [F3B66-7DF] ,\n IF ( ([3C5D9-A7A], [5C477-A2D], [7E79E-971] ) > 0\n AND ([3C5D9-A7A], [D0B0F-6E1], [7E79E-971]) > 0\n , ( [50B29-F1A], [5C477-A2D], [7E79E-971] )\n , NULL )\n ) \n \nELSE NULL END\n \n \n \n \n", "context": { "[5C477-A2D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -2 (2022)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[8D50A-93E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -1 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[D0B0F-6E1]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -3 (2021)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-3" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[29303-0A2]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[02DD4-24D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -1", "filter": { "toNotEqual": "-1" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[A1C64-4BD]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -2", "filter": { "toNotEqual": "-2" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[EEB30-83D]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < 0", "filter": { "toNotEqual": "0" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[69523-398]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Current Year Offset" }, "[1C100-C00]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-3" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[7E79E-971]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[50B29-F1A]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" }, "[3C5D9-A7A]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE DETAIL.Package ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[F3B66-7DF]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "Lapsed" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "color": "#DB4935", "type": "color" } }, "field": { "id": "-1*SUM ( [F8BAC-189] ,\n IF ( ISNULL ( ( [D24D0-5C2] , [E0DF6-A7A] , [E4BA6-0A0] ) )\n AND ( [D24D0-5C2] , [E0DF6-A7A] , [93153-A85] ) > 0\n , ( [3B361-46A] , [E0DF6-A7A] , [93153-A85] )\n\t\t, NULL )\n )", "index": 3 } }, { "jaql": { "type": "measure", "formula": "CASE WHEN [227FF-888] = 0\n\nTHEN\n\n\nSUM ( [1E69D-289] ,\n IF ( ([5CF60-7F5], [04B11-1A2], [52FF2-7E5] ) > 0\n AND\n ISNULL(([5CF60-7F5], [5955B-50F], [52FF2-7E5]))\n AND\n (([11108-EF3], [5955B-50F])) > 0\n , ( [4C603-091], [04B11-1A2], [52FF2-7E5] )\n , NULL )\n )\n \n \n \nWHEN [227FF-888] = -1\n\nTHEN\n\n\nSUM ( [1E69D-289] ,\n IF ( ([5CF60-7F5], [EFF22-7F4], [52FF2-7E5] ) > 0\n AND\n ISNULL(([5CF60-7F5], [F1BA7-118], [52FF2-7E5]))\n AND\n (([11108-EF3], [F1BA7-118])) > 0\n , ( [4C603-091], [EFF22-7F4], [52FF2-7E5] )\n , NULL )\n )\n \n \nWHEN [227FF-888] = -2\n\nTHEN\n\n\nSUM ( [1E69D-289] ,\n IF ( ([5CF60-7F5], [90046-C59], [52FF2-7E5] ) > 0\n AND\n ISNULL(([5CF60-7F5], [597C3-64B], [52FF2-7E5]))\n AND\n (([11108-EF3], [597C3-64B])) > 0\n , ( [4C603-091], [90046-C59], [52FF2-7E5] )\n , NULL )\n )\n \n \n ELSE NULL END", "context": { "[EFF22-7F4]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -1 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[04B11-1A2]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[90046-C59]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset -2 (2022)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[F1BA7-118]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -1", "filter": { "toNotEqual": "-1" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[597C3-64B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < -2", "filter": { "toNotEqual": "-2" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[5955B-50F]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset < 0", "filter": { "toNotEqual": "0" }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[227FF-888]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Max Season Fiscal Current Year Offset", "agg": "max" }, "[52FF2-7E5]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[4C603-091]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" }, "[5CF60-7F5]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE DETAIL.Package ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[11108-EF3]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[1E69D-289]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "Former STB" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#a2b86c" } } }, { "jaql": { "type": "measure", "formula": "CASE WHEN [C2858-04E] = 0\nTHEN\nSUM ( [A3A05-2CB] ,\n IF ( ISNULL(([9CAB6-1A8], [3DC1A-1A3], [1383C-8E6] ))\n AND ([9CAB6-1A8], [C814C-B30], [1383C-8E6]) > 0\n , ( [3DC1E-F0B], [C814C-B30], [1383C-8E6] )\n , NULL )\n ) *-1 \n \n \nWHEN [C2858-04E] = -1\nTHEN\nSUM ( [A3A05-2CB] ,\n IF ( ISNULL(([9CAB6-1A8], [C814C-B30], [1383C-8E6] ))\n AND ([9CAB6-1A8], [39892-B28], [1383C-8E6]) > 0\n , ( [3DC1E-F0B],[39892-B28], [1383C-8E6] )\n , NULL )\n ) * -1 \n \n \n \nWHEN [C2858-04E] = -2\nTHEN\nSUM ( [A3A05-2CB] ,\n IF ( ISNULL(([9CAB6-1A8], [39892-B28], [1383C-8E6] ))\n AND ([9CAB6-1A8], [41079-585], [1383C-8E6]) > 0\n , ( [3DC1E-F0B],[41079-585], [1383C-8E6] )\n , NULL )\n ) * -1 \n \nELSE NULL END", "context": { "[39892-B28]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -2 (2022)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[C814C-B30]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = -1 (2023)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[3DC1A-1A3]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset = 0 (2024)", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[41079-585]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset -3 (2021)", "filter": { "explicit": true, "multiSelection": true, "members": [ "-3" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[C2858-04E]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Current Year Offset" }, "[1383C-8E6]": { "table": "PACKAGE DETAIL", "column": "Type", "dim": "[PACKAGE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Package type: NOT TradeOne OR None", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "TradeOne" ] } }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } }, "[3DC1E-F0B]": { "table": "SEAT & TICKET DETAILS", "column": "Package Seat Key", "dim": "[SEAT & TICKET.Package Seat Key]", "datatype": "text", "merged": true, "title": "# of unique Package Seat Key", "agg": "count" }, "[9CAB6-1A8]": { "table": "PACKAGE DETAIL", "column": "Package ID", "dim": "[PACKAGE DETAIL.Package ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Package ID" }, "[A3A05-2CB]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "Churned" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#434343" } } }, { "jaql": { "type": "measure", "formula": "0", "context": {}, "title": "0" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "#000000" } }, "disabled": false, "singleSeriesType": "line" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0", "-1", "-2" ] }, "collapsed": false, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" } } }, { "jaql": { "table": "SEAT & TICKET DETAILS", "column": "Order Weeks Since OnSale", "dim": "[SEAT & TICKET DETAILS.Order Weeks Since OnSale]", "datatype": "numeric", "title": "Order Weeks Since OnSale", "filter": { "explicit": false, "multiSelection": true, "all": true }, "datasource": { "title": "LOCH-Seats and Tickets", "fullname": "USEA2SAPCUBE208.aws.tnhs.cloud/LOCH-Seats and Tickets", "id": "aUSEA2SAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aLOCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "USEA2SAPCUBE208.aws.tnhs.cloud", "database": "aLOCHLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true } } ] } ] }, "type": "chart/bar", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "top" }, "seriesLabels": { "enabled": true, "rotation": 0, "labels": { "enabled": true, "types": { "count": false, "percentage": false, "relative": true, "totals": true }, "stacked": true, "stackedPercentage": false } }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": true }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": true, "text": "Number of packages" }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "season_fiscal_current_year_offset", "title": "Season Fiscal Current Year Offset", "singular": "Season Fiscal Current Year Offset", "plural": "Season Fiscal Current Year Offset" }, { "id": "order_weeks_since_onsale", "title": "Order Weeks Since OnSale", "singular": "Order Weeks Since OnSale", "plural": "Order Weeks Since OnSale" } ] } }, "instanceid": "43483-4987-91", "queryStartTime": "2024-03-01T11:46:54", "widgetTimingLoged": true, "disableSelctor": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "canEditFilters": true, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "dashboardid": "65e2147d9f9eda0c9818e1d3" } ], "hierarchies": [] }