{
  "title": "Orders with Contributions",
  "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": "D789B-5786-44",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 64,
                    "maxHeight": 1028,
                    "height": 192,
                    "minWidth": 48,
                    "maxWidth": 1028,
                    "defaultWidth": 512,
                    "widgetid": "6049092bcd219d22ec856e93"
                  }
                ]
              }
            ]
          }
        ]
      }
    ],
    "container": {}
  },
  "original": null,
  "oid": "6048ed2ccd219d22ec856c36",
  "datasource": {
    "title": "HNOC-Finance",
    "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
    "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
    "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
    "database": "aHNOCLQAaFinance"
  },
  "editing": true,
  "filters": [
    {
      "jaql": {
        "table": "ORDER DATE",
        "column": "Date",
        "dim": "[ORDER.Date1 (Calendar)]",
        "datatype": "datetime",
        "merged": true,
        "title": "Days in Date",
        "level": "days",
        "datasource": {
          "title": "HNOC-Finance",
          "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
          "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
          "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
          "database": "aHNOCLQAaFinance",
          "lastBuildTime": "2021-03-09T23:31:37"
        },
        "collapsed": true,
        "filter": {
          "from": "2020-04-01",
          "to": "2021-03-10"
        }
      },
      "instanceid": "A9716-47EE-F0",
      "isCascading": false,
      "disabled": true
    }
  ],
  "filterToDatasourceMapping": {},
  "migrated": true,
  "parentFolder": "62850fe2822b653cb49f428d",
  "subscription": {
    "isDataChange": true,
    "type": "onUpdate",
    "schedule": "* * * * * *",
    "context": {
      "dashboardId": "6048ed2ccd219d22ec856c36",
      "dashboardid": "6048ed2ccd219d22ec856c36"
    },
    "active": false,
    "executionPerDay": 1,
    "reportType": {
      "inline": true
    },
    "emailSettings": {
      "isEmail": true,
      "isPdf": false
    }
  },
  "isPublic": null,
  "widgets": [
    {
      "title": "Orders with Contributions",
      "type": "indicator",
      "subtype": "indicator/numeric",
      "oid": "6049092bcd219d22ec856e93",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "HNOC-Finance",
        "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
        "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
        "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
        "database": "aHNOCLQAaFinance",
        "lastBuildTime": "2021-03-09T23:31:37"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "value",
            "items": [
              {
                "jaql": {
                  "type": "measure",
                  "formula": " ([9C8E3-4E8] , [6CDC1-8AC]) /  ([9C8E3-4E8], [A57FF-751] )",
                  "context": {
                    "[A57FF-751]": {
                      "table": "FINANCE DETAILS",
                      "column": "Transaction Category",
                      "dim": "[FINANCE DETAILS.Transaction Category]",
                      "datatype": "text",
                      "merged": true,
                      "title": "Transaction Category",
                      "filter": {
                        "explicit": false,
                        "multiSelection": true,
                        "all": true
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "HNOC-Finance",
                        "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
                        "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
                        "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
                        "database": "aHNOCLQAaFinance",
                        "lastBuildTime": "2021-03-09T23:31:37"
                      }
                    },
                    "[6CDC1-8AC]": {
                      "table": "FINANCE DETAILS",
                      "column": "Transaction Category",
                      "dim": "[FINANCE DETAILS.Transaction Category]",
                      "datatype": "text",
                      "merged": true,
                      "title": "Transaction Category",
                      "filter": {
                        "explicit": true,
                        "multiSelection": true,
                        "members": [
                          "Contribution in Order"
                        ]
                      },
                      "collapsed": false,
                      "datasource": {
                        "title": "HNOC-Finance",
                        "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
                        "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
                        "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
                        "database": "aHNOCLQAaFinance",
                        "lastBuildTime": "2021-03-09T23:31:37"
                      }
                    },
                    "[9C8E3-4E8]": {
                      "table": "FINANCE DETAILS",
                      "column": "Order ID",
                      "dim": "[FINANCE DETAILS.Order ID]",
                      "datatype": "numeric",
                      "agg": "count",
                      "title": "# of unique Order ID"
                    }
                  },
                  "title": "Formula"
                },
                "format": {
                  "mask": {
                    "decimals": "auto",
                    "percent": true,
                    "percentMultiplier": 100
                  },
                  "color": {
                    "color": "#547A94",
                    "type": "color"
                  }
                }
              }
            ]
          },
          {
            "name": "secondary",
            "items": []
          },
          {
            "name": "min",
            "items": []
          },
          {
            "name": "max",
            "items": []
          },
          {
            "name": "filters",
            "items": [
              {
                "jaql": {
                  "table": "FUND",
                  "column": "Fund",
                  "dim": "[FUND.Fund]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Fund",
                  "filter": {
                    "explicit": true,
                    "multiSelection": true,
                    "members": [
                      "Add-On (General Donation)"
                    ]
                  },
                  "datasource": {
                    "title": "HNOC-Finance",
                    "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
                    "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
                    "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
                    "database": "aHNOCLQAaFinance",
                    "lastBuildTime": "2021-03-09T23:31:37"
                  },
                  "collapsed": true
                }
              },
              {
                "jaql": {
                  "table": "FINANCE DETAILS",
                  "column": "Mode of Sale",
                  "dim": "[FINANCE DETAILS.Mode of Sale]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Mode of Sale",
                  "filter": {
                    "explicit": false,
                    "multiSelection": true,
                    "exclude": {
                      "members": [
                        "(none)",
                        "Telephone/mail",
                        "Walk-in"
                      ]
                    }
                  },
                  "collapsed": false,
                  "datasource": {
                    "title": "HNOC-Finance",
                    "fullname": "USEA2SAPCUBE010.aws.tnhs.cloud/HNOC-Finance",
                    "id": "aUSEA2SAPCUBE010LgAaAWSLgAaTNHSLgAaCLOUD_aHNOCLQAaFINANCE",
                    "address": "USEA2SAPCUBE010.aws.tnhs.cloud",
                    "database": "aHNOCLQAaFinance",
                    "lastBuildTime": "2021-03-09T23:31:37"
                  }
                }
              }
            ]
          }
        ]
      },
      "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": {
        "subtype": "simple",
        "skin": "vertical",
        "components": {
          "title": {
            "inactive": false,
            "enabled": true
          },
          "icon": {
            "inactive": true,
            "enabled": true
          },
          "secondaryTitle": {
            "inactive": true,
            "enabled": true
          }
        },
        "indicator/numeric": {
          "subtype": "simple",
          "skin": "vertical",
          "components": {
            "title": {
              "inactive": false,
              "enabled": true
            },
            "icon": {
              "inactive": false,
              "enabled": true
            },
            "secondaryTitle": {
              "inactive": true,
              "enabled": true
            }
          }
        },
        "indicator/gauge": {
          "subtype": "round",
          "skin": "1",
          "components": {
            "ticks": {
              "inactive": false,
              "enabled": true
            },
            "labels": {
              "inactive": false,
              "enabled": true
            },
            "title": {
              "inactive": false,
              "enabled": true
            },
            "secondaryTitle": {
              "inactive": true,
              "enabled": true
            }
          }
        },
        "narration": {
          "enabled": false,
          "display": "above",
          "format": "bullets",
          "verbosity": "medium",
          "up_sentiment": "good",
          "aggregation": "sum",
          "labels": [
            {
              "id": "fund",
              "title": "Fund",
              "singular": "Fund",
              "plural": "Fund"
            },
            {
              "id": "mode_of_sale",
              "title": "Mode of Sale",
              "singular": "Mode of Sale",
              "plural": "Mode of Sale"
            }
          ]
        }
      },
      "instanceid": "856B8-38C8-AA",
      "queryStartTime": "2023-01-27T13:54:19",
      "drawing": true,
      "widgetTimingLoged": false,
      "continuousDates": false,
      "nullAsZero": false,
      "forcedRedraw": 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": "6048ed2ccd219d22ec856c36",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "disallowSelector": true,
        "triggersDomready": true,
        "autoUpdateOnEveryChange": true,
        "supportsHierarchies": false
      },
      "viewState": {
        "activeTab": "filters"
      },
      "canEditFilters": true
    }
  ],
  "hierarchies": []
}