{ "title": "New, Return, Lapse, and Churn Chart", "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": "5689C-04A5-96", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "5f051e1390bde617b8e2c92e" } ] } ] } ] } ] }, "original": null, "oid": "5f051df590bde617b8e2c91f", "datasource": { "title": "BRCH-Seats and Tickets", "fullname": "CWALLINGFORD-VM/BRCH-Seats and Tickets", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaSeatsIAAaandIAAaTickets" }, "editing": true, "filters": [ { "jaql": { "table": "SEAT & TICKET DETAILS", "column": "Is Package Flag", "dim": "[SEAT & TICKET.Is Package Flag]", "datatype": "text", "merged": true, "title": "Is Package Flag", "collapsed": true, "datasource": { "title": "BRCH-Seats and Tickets", "fullname": "CWALLINGFORD-VM/BRCH-Seats and Tickets", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "943FC-F153-9E", "isCascading": false }, { "jaql": { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "datasource": { "title": "BRCH-Seats and Tickets", "fullname": "CWALLINGFORD-VM/BRCH-Seats and Tickets", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "521EF-90E4-D4", "isCascading": false }, { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "BRCH-Seats and Tickets", "fullname": "CWALLINGFORD-VM/BRCH-Seats and Tickets", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaSeatsIAAaandIAAaTickets" }, "filter": { "from": "2018", "to": "2020" } }, "instanceid": "D8EA9-0E62-9F", "isCascading": false, "disabled": false } ], "filterToDatasourceMapping": {}, "parentFolder": null, "widgets": [ { "title": "Seasonal Constituent Counts with Break Out", "type": "chart/bar", "subtype": "bar/stacked", "oid": "5f051e1390bde617b8e2c92e", "desc": null, "source": null, "datasource": { "title": "BRCH-Seats and Tickets", "fullname": "CWALLINGFORD-VM/BRCH-Seats and Tickets", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaSeatsIAAaandIAAaTickets" }, "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": "FY", "sortDetails": { "field": 0, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true } }, "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": "Total" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "#232323" } }, "singleSeriesType": "line" }, { "jaql": { "type": "measure", "formula": "CASE\n WHEN [E9F87-A14] = 2020 THEN \n ( [D435A-705] , [7B51F-1CC] ) -\n ( [D435A-705] , [69FF4-7E3] ) \n WHEN [E9F87-A14] = 2019 THEN \n ( [D435A-705] , [E48E1-D7A] ) -\n ( [D435A-705] , [1E8B6-100] ) \n WHEN [E9F87-A14] = 2018 THEN \n ( [D435A-705] , [80DCF-426] ) -\n ( [D435A-705] , [B7614-551] ) \n ELSE NULL END", "context": { "[D435A-705]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[E9F87-A14]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Year" }, "[80DCF-426]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[1E8B6-100]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[E48E1-D7A]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[69FF4-7E3]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[7B51F-1CC]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[B7614-551]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } } }, "title": "New" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "CASE\n WHEN [617A9-5AA] = 0 THEN \n ( [9F5B6-353] , [7411E-35A] , ALL( [24A9C-B41] ) ) -\n ( [9F5B6-353] , [F92B0-CEF] , ALL( [24A9C-B41] ) ) \n WHEN [617A9-5AA] = -1 THEN \n ( [9F5B6-353] , [D81B0-270] , ALL( [24A9C-B41] ) ) -\n ( [9F5B6-353] , [801EC-681] , ALL( [24A9C-B41] ) ) \n WHEN [617A9-5AA] = -2 THEN \n ( [9F5B6-353] , [4ADF7-0A6] , ALL( [24A9C-B41] ) ) -\n ( [9F5B6-353] , [1A491-86A] , ALL( [24A9C-B41] ) ) \n ELSE NULL END", "index": 2 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "CASE WHEN [78778-19F] = 2020 THEN \n ( [22C0D-D4E] , [A32C7-367] ) +\n ( [22C0D-D4E] , [B1010-F5E] ) -\n ( [22C0D-D4E] , [84396-A3B] ) \n WHEN [78778-19F] = 2019 THEN \n ( [22C0D-D4E] , [71C5E-369] ) +\n ( [22C0D-D4E] , [CD86F-65E] ) -\n ( [22C0D-D4E] , [10099-5BE] ) \n WHEN [78778-19F] = 2018 THEN \n ( [22C0D-D4E] , [A5DD1-203] ) +\n ( [22C0D-D4E] , [3BFE3-941] ) -\n ( [22C0D-D4E] , [5DA08-21E] ) \n ELSE NULL END\n ", "context": { "[22C0D-D4E]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[78778-19F]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Year" }, "[3BFE3-941]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[A5DD1-203]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[10099-5BE]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[CD86F-65E]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[71C5E-369]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[84396-A3B]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[B1010-F5E]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[A32C7-367]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[5DA08-21E]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Returned" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "color": "#DB4935", "type": "color" } }, "field": { "id": "CASE WHEN [24889-F36] = 0 THEN \n ( [73909-CFF] , [56FE1-894] , ALL ( [7B494-326] ) ) +\n ( [73909-CFF] , [4FFE8-000] , ALL ( [7B494-326] ) ) -\n ( [73909-CFF] , [C4FDB-246] , ALL ( [7B494-326] ) )\n WHEN [24889-F36] = -1 THEN \n ( [73909-CFF] , [2CDFA-E54] , ALL ( [7B494-326] ) ) +\n ( [73909-CFF] , [47C28-7A1] , ALL ( [7B494-326] ) ) -\n ( [73909-CFF] , [2640D-363] , ALL ( [7B494-326] ) )\n WHEN [24889-F36] = -2 THEN \n ( [73909-CFF] , [F801D-5D9] , ALL ( [7B494-326] ) ) +\n ( [73909-CFF] , [0F6F7-387] , ALL ( [7B494-326] ) ) -\n ( [73909-CFF] , [EDCAB-2C2] , ALL ( [7B494-326] ) )\n ELSE NULL END\n ", "index": 3 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "0", "context": {}, "title": "0" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "#232323" } }, "field": { "id": "0", "index": 6 }, "singleSeriesType": "line" }, { "jaql": { "type": "measure", "formula": "-1 * \nCASE\n WHEN [2CB95-8D5] = 2020 THEN \n ( [B8A23-9E9] , [8ED76-C1C] ) -\n ( [B8A23-9E9] , [E1EE4-D4F] ) \n WHEN [2CB95-8D5] = 2019 THEN \n ( [B8A23-9E9] , [599DB-596] ) -\n ( [B8A23-9E9] , [54977-A73] ) \n WHEN [2CB95-8D5] = 2018 THEN \n ( [B8A23-9E9] , [EB6E6-980] ) -\n ( [B8A23-9E9] , [122F9-4AA] ) \n ELSE NULL END", "context": { "[B8A23-9E9]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[2CB95-8D5]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Year" }, "[EB6E6-980]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[54977-A73]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[599DB-596]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[E1EE4-D4F]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[8ED76-C1C]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[122F9-4AA]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Churned" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "#232323" } }, "field": { "id": "-1 * \nCASE\n WHEN [3E3F5-95F] = 0 THEN \n ( [9D8AF-825] , [47D48-54E] , ALL( [1BB73-830] ) ) -\n ( [9D8AF-825] , [87517-2D0] , ALL( [1BB73-830] ) ) \n WHEN [3E3F5-95F] = -1 THEN \n ( [9D8AF-825] , [AE94F-853] , ALL( [1BB73-830] ) ) -\n ( [9D8AF-825] , [69BA7-93F] , ALL( [1BB73-830] ) ) \n WHEN [3E3F5-95F] = -2 THEN \n ( [9D8AF-825] , [D4DEC-F8E] , ALL( [1BB73-830] ) ) -\n ( [9D8AF-825] , [DD7F7-9FE] , ALL( [1BB73-830] ) ) \n ELSE NULL END", "index": 5 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "-1 * CASE\n WHEN [3602F-E35] = 2020 THEN \n ( [5011B-0E1] , [38A8C-CBD] ) - \n ( [5011B-0E1] , [EF268-1DB] )\n WHEN [3602F-E35] = 2019 THEN \n ( [5011B-0E1] , [D10C7-D55] ) - \n ( [5011B-0E1] , [5C41D-B64] )\n WHEN [3602F-E35] = 2018 THEN \n ( [5011B-0E1] , [13DF6-7A2] ) - \n ( [5011B-0E1] , [750BD-3B1] )\n ELSE NULL END\n", "context": { "[5011B-0E1]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "[3602F-E35]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "agg": "max", "title": "Max Season Fiscal Year" }, "[13DF6-7A2]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[5C41D-B64]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[D10C7-D55]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[EF268-1DB]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[38A8C-CBD]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } }, "[750BD-3B1]": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018" ] }, "collapsed": false, "datasource": { "title": "MALO-Seats and Tickets", "fullname": "EUACUBEBP004.EURAMP01.local/MALO-Seats and Tickets", "id": "aEUACUBEBP004LgAaEURAMP01LgAaLOCAL_aMALOLQAaSEATSIAAaANDIAAaTICKETS", "address": "EUACUBEBP004.EURAMP01.local", "database": "aMALOLQAaSeatsIAAaandIAAaTickets" } } }, "title": "Lapsed" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "number": { "separated": true } }, "color": { "type": "color", "color": "#808080" } }, "field": { "id": "CASE\n WHEN [F48FF-F99] = 0 THEN \n ( [39F1C-D55] , [645EB-75C] , ALL ( [DFF13-0DE] ) ) - \n ( [39F1C-D55] , [88E91-601] , ALL ( [DFF13-0DE] ) )\n WHEN [F48FF-F99] = -1 THEN \n ( [39F1C-D55] , [F9D81-DD4] , ALL ( [DFF13-0DE] ) ) - \n ( [39F1C-D55] , [D1E81-395] , ALL ( [DFF13-0DE] ) ) \n WHEN [F48FF-F99] = -2 THEN \n ( [39F1C-D55] , [784A5-E80] , ALL ( [DFF13-0DE] ) ) - \n ( [39F1C-D55] , [1E88A-CD5] , ALL ( [DFF13-0DE] ) ) \n ELSE NULL END\n", "index": 4 }, "disabled": false } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "top" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": false, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "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": "fy", "title": "FY", "singular": "FY", "plural": "FY" } ] } }, "instanceid": "E7F9C-CC3D-C8", "queryStartTime": "2020-07-07T21:16:53", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "design" }, "canEditFilters": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "cancelled": true, "dashboardid": "5f051df590bde617b8e2c91f", "drawing": true } ], "hierarchies": [] }