{ "title": "5 Year Active on Date", "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": "C3A29-1EBB-9D", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "500px", "defaultWidth": 512, "widgetid": "635030a4b8f9d14a9817578f" } ], "width": 31.818181818181817, "stretchable": false, "pxlWidth": 528, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "635030a4b8f9d14a98175790", "height": "500px" } ], "width": 33.25358851674641, "stretchable": false, "pxlWidth": 556, "index": 1 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "63515799df72363e3453a8ba", "height": "500px" } ], "width": 34.928229665071754, "stretchable": false, "pxlWidth": 1052, "index": 2 } ] } ], "pxlWidth": 1439, "index": 0 } ], "container": {} }, "original": null, "oid": "635030a4b8f9d14a9817578e", "dataExploration": false, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" }, "filters": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" }, "collapsed": true, "filter": { "explicit": true, "multiSelection": true, "members": [ "SR Donor/Member Levels", "SR Membership (AD)" ], "filter": { "turnedOff": true, "exclude": { "members": [ "SR Donor/Member Levels" ] } } } }, "instanceid": "61873-AE90-AE", "isCascading": false, "disabled": false } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "parentFolder": null, "widgets": [ { "title": "Active in October (explicit date filters)", "type": "chart/column", "subtype": "column/classic", "oid": "635030a4b8f9d14a9817578f", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[INITIATION DATE.Date (Calendar)]", "[EXPIRATION DATE.Date (Calendar)]", "[MEMBERSHIP PURCHASE DATE.Date (Calendar)]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "([400CD-817],[CE46B-A3A],[29B3D-BBD])", "context": { "[400CD-817]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[29B3D-BBD]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Expiration Date", "level": "days", "filter": { "from": "2022-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[D36DF-21A]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2022-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[CE46B-A3A]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Start Date", "level": "days", "filter": { "to": "2022-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "This Month" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([A3B28-5A9],[66069-133],[9C4F7-D04])", "context": { "[A3B28-5A9]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[9C4F7-D04]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2021-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[66069-133]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2021-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[279A6-3ED]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2022-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "This Month -1 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#F48E06", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([C21DE-76C],[97A94-DD0],[F612E-D26])", "context": { "[C21DE-76C]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[CC3C1-44A]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2021-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[F612E-D26]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2020-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[97A94-DD0]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2020-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "This Month -2 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#DB4935", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([8C6A7-D92],[16BA2-227],[E2574-C71])", "context": { "[8C6A7-D92]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[3B84B-EA6]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2020-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[E2574-C71]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2019-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[16BA2-227]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2019-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "This Month -3 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#333333", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([0F120-7A9],[CE030-643],[5EE6F-5AD])", "context": { "[0F120-7A9]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[D52B0-D5F]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2019-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[5EE6F-5AD]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2018-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[CE030-643]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2018-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "This Month -4 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#008775", "type": "color" } } } ] }, { "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": "bottom" }, "seriesLabels": { "enabled": true, "rotation": 0, "labels": { "enabled": false, "stacked": false, "stackedPercentage": false, "types": { "count": false, "relative": false, "percentage": false, "totals": 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": "Membership Count" }, "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 }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" } ] } }, "instanceid": "48786-0100-BE", "queryStartTime": "2022-10-19T10:02:25", "widgetTimingLoged": false, "drawing": 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, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "dashboardid": "635030a4b8f9d14a9817578e", "viewState": { "activeTab": "filters" } }, { "title": "Active 1-Oct (explicit date filters)", "type": "chart/column", "subtype": "column/classic", "oid": "635030a4b8f9d14a98175790", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[INITIATION DATE.Date (Calendar)]", "[EXPIRATION DATE.Date (Calendar)]", "[MEMBERSHIP PURCHASE DATE.Date (Calendar)]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "([E7EB8-4F8],[E2A3A-2A4],[E1089-590])", "context": { "[E7EB8-4F8]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[0791B-F5D]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2022-10-31" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[E1089-590]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2022-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[E2A3A-2A4]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2022-10-01" }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "2022-10-01" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([EC3A2-B66],[D4BAF-3B3],[26C78-5A2])", "context": { "[EC3A2-B66]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[423A7-A6E]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2021-10-31", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[26C78-5A2]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2021-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[D4BAF-3B3]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2021-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "2021-10-01" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#F48E06", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([884B3-DE5],[ACBE6-25E],[378E4-F1E])", "context": { "[884B3-DE5]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[C2E8F-F8B]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2020-10-31", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[378E4-F1E]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2020-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[ACBE6-25E]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2020-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "2020-10-01" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#DB4935", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([8EBAB-F7C],[F755D-F99],[C82F2-53E])", "context": { "[8EBAB-F7C]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[AFC2F-CE1]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2020-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[C82F2-53E]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2019-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[F755D-F99]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2019-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "2019-10-01" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#333333", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([D2D82-E5C],[F6409-F60],[AA1B4-571])", "context": { "[D2D82-E5C]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[BECEC-EF0]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2019-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[AA1B4-571]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2018-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } }, "[F6409-F60]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "to": "2018-10-01", "custom": true }, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships" } } }, "title": "2018-10-01" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#008775", "type": "color" } } } ] }, { "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": "bottom" }, "seriesLabels": { "enabled": true, "rotation": 0, "labels": { "enabled": false, "stacked": false, "stackedPercentage": false, "types": { "count": false, "relative": false, "percentage": false, "totals": 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": "Membership Count" }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": false, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": false, "hideMinMax": false }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" } ] } }, "instanceid": "48786-0100-BE", "queryStartTime": "2022-10-19T13:12:10", "widgetTimingLoged": false, "disableSelctor": 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 }, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "dashboardid": "635030a4b8f9d14a9817578e", "drawing": true, "chart": { "0": {}, "context": {}, "length": 1 } }, { "title": "Active Today (relative 365 day filters)", "subtype": "column/classic", "oid": "63515799df72363e3453a8ba", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[INITIATION DATE.Date (Calendar)]", "[EXPIRATION DATE.Date (Calendar)]", "[MEMBERSHIP PURCHASE DATE.Date (Calendar)]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "([73994-30B],[8A80F-C55],[703F1-7FD])", "context": { "[73994-30B]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[87DA3-DC0]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": 1 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[703F1-7FD]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": 0 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[8A80F-C55]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "last": { "count": 99999, "offset": 0 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } } }, "title": "Today" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([DE0E4-985],[8AB27-831],[C2D8F-07F])", "context": { "[DE0E4-985]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[3F274-2E6]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": 0 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[C2D8F-07F]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": -365 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[8AB27-831]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "last": { "count": 99999, "offset": 365 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } } }, "title": "Today -1Y" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#F48E06", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([3A9CE-F4D],[D558C-F56],[D7BD7-B16])", "context": { "[3A9CE-F4D]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[8CD8F-922]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": -1095 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[D7BD7-B16]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": -730 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[D558C-F56]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "last": { "count": 99999, "offset": 730 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } } }, "title": "Today -2Y" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#DB4935", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([1DF90-D2B],[8BCE3-CFB],[80BD7-2A1])", "context": { "[1DF90-D2B]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[0E3E6-B4C]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": 0 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[80BD7-2A1]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": -1095 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[8BCE3-CFB]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "last": { "count": 99999, "offset": 1095 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } } }, "title": "Today - 3Y" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#333333", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "([2C114-FC0],[A8913-052],[9DB23-7D4])", "context": { "[2C114-FC0]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[1C2C1-0F4]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": 0 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[9DB23-7D4]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "next": { "count": 99999, "offset": -1460 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } }, "[A8913-052]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "last": { "count": 99999, "offset": 1460 }, "custom": true }, "datasource": { "title": "SDNA-Memberships", "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships", "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS", "address": "USEA2SAPCUBE400.aws.tnhs.cloud", "database": "aSDNALQAaMemberships" } } }, "title": "Today -4Y" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#008775", "type": "color" } } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "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": "bottom" }, "seriesLabels": { "enabled": true, "rotation": 0, "labels": { "enabled": false, "stacked": false, "stackedPercentage": false, "types": { "count": false, "relative": false, "percentage": false, "totals": 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": "Membership Count" }, "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 }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" } ] } }, "instanceid": "48786-0100-BE", "queryStartTime": "2022-10-20T10:31:14", "widgetTimingLoged": false, "disableSelctor": 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 }, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "chart": { "0": {}, "context": {}, "length": 1 }, "dashboardid": "635030a4b8f9d14a9817578e", "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null }, "selectorLocked": false }, "drawing": true } ], "hierarchies": [] }