{
  "title": "Memberships Active Today",
  "oid": "624f45e94834ab30e41bfb8b",
  "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": "51B2E-1F06-B6",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": 384,
                    "defaultWidth": 512,
                    "widgetid": "624f465e4834ab30e41bfbbb"
                  }
                ]
              }
            ]
          }
        ]
      }
    ],
    "container": {}
  },
  "original": null,
  "datasource": {
    "title": "SDNA-Memberships",
    "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships",
    "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS",
    "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
    "database": "aSDNALQAaMemberships"
  },
  "editing": true,
  "filters": [
    {
      "jaql": {
        "table": "MEMBERSHIP LEVEL",
        "column": "Membership Organization",
        "dim": "[MEMBERSHIP LEVEL.Membership Organization]",
        "datatype": "text",
        "merged": true,
        "title": "Membership Organization",
        "collapsed": true,
        "datasource": {
          "title": "SDNA-Memberships",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaMemberships",
          "lastBuildTime": "2022-04-07T00:50:59"
        },
        "filter": {
          "explicit": true,
          "multiSelection": true,
          "members": [
            "SR Membership (AD)"
          ]
        }
      },
      "instanceid": "99404-407F-91",
      "isCascading": false
    },
    {
      "jaql": {
        "table": "EXPIRATION DATE",
        "column": "Date",
        "dim": "[EXPIRATION DATE.Date (Calendar)]",
        "datatype": "datetime",
        "merged": true,
        "title": "Expiration Today Forward",
        "level": "days",
        "datasource": {
          "title": "SDNA-Memberships",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaMemberships",
          "lastBuildTime": "2022-04-07T00:50:59"
        },
        "collapsed": true,
        "filter": {
          "next": {
            "count": 1000,
            "offset": 0
          },
          "custom": true
        }
      },
      "instanceid": "BDDD2-61E7-DD",
      "isCascading": false,
      "disabled": false
    },
    {
      "jaql": {
        "table": "INITIATION DATE",
        "column": "Date",
        "dim": "[INITIATION DATE.Date (Calendar)]",
        "datatype": "datetime",
        "merged": true,
        "title": "Initiation Today Backward",
        "level": "days",
        "datasource": {
          "title": "SDNA-Memberships",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Memberships",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaMEMBERSHIPS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaMemberships",
          "lastBuildTime": "2022-04-07T00:50:59"
        },
        "collapsed": true,
        "filter": {
          "last": {
            "count": 1000,
            "offset": 0
          },
          "custom": true
        }
      },
      "instanceid": "4E86F-A695-0A",
      "isCascading": false,
      "disabled": false
    }
  ],
  "filterToDatasourceMapping": {},
  "widgets": [
    {
      "title": "",
      "subtype": "pivot",
      "oid": "624f465e4834ab30e41bfbbb",
      "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",
        "lastBuildTime": "2022-04-07T00:50:59"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "MEMBERSHIP LEVEL",
                  "column": "Membership Level",
                  "dim": "[MEMBERSHIP LEVEL.Membership Level]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Membership Level"
                },
                "field": {
                  "id": "[MEMBERSHIP LEVEL.Membership Level]",
                  "index": 0
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "table": "MEMBERSHIP VALUES",
                  "column": "Membership Count",
                  "dim": "[MEMBERSHIP VALUES.Membership Count]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total Membership Count"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  }
                },
                "field": {
                  "id": "[MEMBERSHIP VALUES.Membership Count]_sum",
                  "index": 1
                }
              }
            ]
          },
          {
            "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
        }
      },
      "instanceid": "E6D6B-3C64-1E",
      "queryStartTime": "2022-04-07T16:15:21",
      "drawing": true,
      "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": "624f45e94834ab30e41bfb8b",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true
      }
    }
  ],
  "hierarchies": []
}