{ "title": "Active Member Count", "oid": "5d16315f6bfa9b28181bf2b5", "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": "043E7-C174-DD", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d163ec46bfa9b28181bf4df", "height": 384 } ], "width": 50 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d16399a6bfa9b28181bf419", "height": 384 } ], "width": 100, "stretchable": false, "pxlWidth": 1317, "index": 0 } ] } ], "pxlWidth": 100, "index": 0 } ], "container": { "sizzle-1561735477404": { "parentNode": [ "13945.29655953474 565", 172 ] } } }, "original": null, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" }, "editing": true, "widgets": [ { "title": "Monthly Active Member Count", "subtype": "pivot", "oid": "5d16399a6bfa9b28181bf419", "desc": null, "source": null, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "sortDetails": { "field": 0, "dir": "asc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "asc" }, "field": { "id": "[MEMBERSHIP LEVEL.Membership Organization]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "( [6E2D9-698] , [CAF7B-5EC] , [D0549-2EA])", "context": { "[6E2D9-698]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[D0549-2EA]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[CAF7B-5EC]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2017-01-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "Jan 2017" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [6E2D9-698] , [CAF7B-5EC] , [D0549-2EA])", "index": 1 } }, { "jaql": { "type": "measure", "formula": "( [0B9DB-B87] , [AB2AA-A7E] , [B99CA-F7C])", "context": { "[0B9DB-B87]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[0C363-6BA]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[B99CA-F7C]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-02-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[AB2AA-A7E]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2017-02-28", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "Feb 2017" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [0B9DB-B87] , [AB2AA-A7E] , [B99CA-F7C])", "index": 2 } }, { "jaql": { "type": "measure", "formula": "( [BEC00-3BE] , [8649D-66F] , [76399-C27])", "context": { "[BEC00-3BE]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[76399-C27]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-03-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[8649D-66F]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2017-03-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "Mar 2017" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [BEC00-3BE] , [8649D-66F] , [76399-C27])", "index": 3 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" } ] }, "rowsGrandTotal": true }, "instanceid": "01C68-E3B7-39", "queryStartTime": "2019-06-28T12:34:59", "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, "dashboardid": "5d16315f6bfa9b28181bf2b5", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "drawing": true }, { "title": "Annual Active Member Count", "subtype": "pivot", "oid": "5d163ec46bfa9b28181bf4df", "desc": null, "source": null, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "sortDetails": { "field": 0, "dir": "asc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "asc" }, "field": { "id": "[MEMBERSHIP LEVEL.Membership Organization]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "( [AF6A7-37C] , [6692D-975] , [313E8-A59] )", "context": { "[AF6A7-37C]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[313E8-A59]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[6692D-975]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2017-12-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "2017" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [AF6A7-37C] , [6692D-975] , [313E8-A59] )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "( [4CE07-2C7] , [D15B6-D86] , [103FA-F23] )", "context": { "[4CE07-2C7]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[950ED-055]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[103FA-F23]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2018-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[D15B6-D86]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2018-12-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "2018" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [4CE07-2C7] , [D15B6-D86] , [103FA-F23] )", "index": 2 } }, { "jaql": { "type": "measure", "formula": "( [542E6-CC4] , [B3D0C-9D5] , [E98C4-429] )", "context": { "[542E6-CC4]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[A5564-335]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[E98C4-429]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2019-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[B3D0C-9D5]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2019-12-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "2019" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [542E6-CC4] , [B3D0C-9D5] , [E98C4-429] )", "index": 3 } }, { "jaql": { "type": "measure", "formula": "( [CEE65-A66] , [06E52-E55] , [2C432-774] )", "context": { "[CEE65-A66]": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "[F1F9B-46E]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2017-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[2C432-774]": { "table": "EXPIRATION DATE", "column": "Date", "dim": "[EXPIRATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "filter": { "from": "2020-01-01", "to": "2999-12-31", "custom": true }, "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } }, "[06E52-E55]": { "table": "INITIATION DATE", "column": "Date", "dim": "[INITIATION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "filter": { "from": "1900-01-01", "to": "2020-12-31", "custom": true }, "level": "days", "collapsed": false, "datasource": { "title": "Memberships", "fullname": "SBBIDB1.tnsb.local/Memberships", "id": "aSBBIDB1LgAaTNSBLgAaLOCAL_aMEMBERSHIPS", "address": "SBBIDB1.tnsb.local", "database": "aMemberships" } } }, "title": "2020" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "( [CEE65-A66] , [06E52-E55] , [2C432-774] )", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" } ] }, "rowsGrandTotal": true }, "instanceid": "01C68-E3B7-39", "queryStartTime": "2019-06-28T12:28:12", "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, "dashboardid": "5d16315f6bfa9b28181bf2b5", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "drawing": true } ], "hierarchies": [] }