{
  "title": "monthly goals",
  "oid": "6318e7dfa05f973b148dba83",
  "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": "47A03-B94B-48",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": 384,
                    "defaultWidth": 512,
                    "widgetid": "6318e917a05f973b148dbab7"
                  }
                ]
              }
            ]
          }
        ]
      }
    ],
    "container": {}
  },
  "original": null,
  "datasource": {
    "title": "SDNA-Contributions",
    "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Contributions",
    "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaCONTRIBUTIONS",
    "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
    "database": "aSDNALQAaContributions"
  },
  "editing": true,
  "filters": [
    {
      "jaql": {
        "table": "CREATE DATE",
        "column": "Date",
        "dim": "[CREATE DATE.Date (Calendar)]",
        "datatype": "datetime",
        "merged": true,
        "title": "Years in Date",
        "level": "years",
        "collapsed": true,
        "datasource": {
          "title": "SDNA-Contributions",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Contributions",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaCONTRIBUTIONS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaContributions",
          "lastBuildTime": "2022-09-07T00:48:00"
        },
        "filter": {
          "explicit": true,
          "multiSelection": true,
          "members": [
            "2022-01-01T00:00:00"
          ]
        }
      },
      "instanceid": "E88C8-19F0-B4",
      "isCascading": false
    }
  ],
  "filterToDatasourceMapping": {},
  "widgets": [
    {
      "title": "",
      "subtype": "pivot",
      "oid": "6318e917a05f973b148dbab7",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "SDNA-Contributions",
        "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Contributions",
        "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaCONTRIBUTIONS",
        "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
        "database": "aSDNALQAaContributions",
        "lastBuildTime": "2022-09-07T00:48:00"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "CREATE DATE",
                  "column": "Date",
                  "dim": "[CREATE DATE.Date (Calendar)]",
                  "datatype": "datetime",
                  "merged": true,
                  "level": "months",
                  "title": "Months in Date"
                },
                "format": {
                  "mask": {
                    "years": "yyyy",
                    "quarters": "yyyy Q",
                    "months": "MM/yyyy",
                    "weeks": "ww yyyy",
                    "days": "shortDate",
                    "minutes": "HH:mm",
                    "isdefault": true
                  }
                },
                "field": {
                  "id": "[CREATE DATE.Date (Calendar)]_months",
                  "index": 0
                },
                "hierarchies": [
                  "calendar",
                  "calendar - weeks"
                ]
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "table": "CONTRIBUTION VALUES",
                  "column": "Contribution Count",
                  "dim": "[CONTRIBUTION VALUES.Contribution Count]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total Contribution Count"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "[CONTRIBUTION VALUES.Contribution Count]_sum",
                  "index": 1
                }
              },
              {
                "jaql": {
                  "table": "CONTRIBUTION VALUES",
                  "column": "Amount",
                  "dim": "[CONTRIBUTION VALUES.Amount]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total Amount"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "[CONTRIBUTION VALUES.Amount]_sum",
                  "index": 2
                }
              },
              {
                "jaql": {
                  "type": "measure",
                  "formula": "CASE\nWHEN [7DAB1-35E] = 1 THEN 1234\nWHEN [7DAB1-35E] = 2 THEN 2345\nWHEN [7DAB1-35E] = 3 THEN 3456\nWHEN [7DAB1-35E] = 4 THEN 4567\nWHEN [7DAB1-35E] = 5 THEN 5678\nWHEN [7DAB1-35E] = 6 THEN 6789\nWHEN [7DAB1-35E] = 7 THEN 7890\nWHEN [7DAB1-35E] = 8 THEN 8901\nWHEN [7DAB1-35E] = 9 THEN 9012\nWHEN [7DAB1-35E] = 10 THEN 10234\nWHEN [7DAB1-35E] = 11 THEN 11345\nWHEN [7DAB1-35E] = 12 THEN 12456\nELSE 0 END",
                  "context": {
                    "[7DAB1-35E]": {
                      "table": "CREATE DATE",
                      "column": "Calendar Month",
                      "dim": "[CREATE DATE.Calendar Month]",
                      "datatype": "numeric",
                      "agg": "max",
                      "title": "Max Calendar Month"
                    }
                  },
                  "title": "Monthly Goals"
                },
                "format": {
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  },
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  }
                },
                "field": {
                  "id": "CASE\nWHEN [7DAB1-35E] = 1 THEN 1234\nWHEN [7DAB1-35E] = 2 THEN 2345\nWHEN [7DAB1-35E] = 3 THEN 3456\nWHEN [7DAB1-35E] = 4 THEN 4567\nWHEN [7DAB1-35E] = 5 THEN 5678\nWHEN [7DAB1-35E] = 6 THEN 6789\nWHEN [7DAB1-35E] = 7 THEN 7890\nWHEN [7DAB1-35E] = 8 THEN 8901\nWHEN [7DAB1-35E] = 9 THEN 9012\nWHEN [7DAB1-35E] = 10 THEN 10234\nWHEN [7DAB1-35E] = 11 THEN 11345\nWHEN [7DAB1-35E] = 12 THEN 12456\nELSE 0 END",
                  "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": "months",
              "title": "months",
              "singular": "months",
              "plural": "months"
            }
          ]
        }
      },
      "instanceid": "537FD-A1FA-B0",
      "queryStartTime": "2022-09-07T14:53:30",
      "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": "6318e7dfa05f973b148dba83",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true,
        "autoUpdateOnEveryChange": true
      }
    }
  ],
  "hierarchies": []
}