{
  "title": "Complete Orders Containing a Specific Price Type",
  "oid": "620ff69608d6e3191caa1331",
  "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": "D81DC-856E-3A",
    "type": "columnar",
    "columns": [
      {
        "width": 100,
        "cells": [
          {
            "subcells": [
              {
                "elements": [
                  {
                    "minHeight": 128,
                    "maxHeight": 2048,
                    "minWidth": 128,
                    "maxWidth": 2048,
                    "height": 384,
                    "defaultWidth": 512,
                    "widgetid": "620ff72908d6e3191caa1364"
                  }
                ]
              }
            ]
          }
        ]
      }
    ],
    "container": {}
  },
  "original": null,
  "datasource": {
    "title": "SDNA-Seats and Tickets",
    "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
    "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
    "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
    "database": "aSDNALQAaSeatsIAAaandIAAaTickets"
  },
  "editing": true,
  "filters": [
    {
      "jaql": {
        "table": "SEASON",
        "column": "Season",
        "dim": "[SEASON.Season]",
        "datatype": "text",
        "merged": true,
        "title": "Season",
        "filter": {
          "explicit": true,
          "multiSelection": true,
          "members": [
            "2021 Concert Series"
          ]
        },
        "datasource": {
          "title": "SDNA-Seats and Tickets",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaSeatsIAAaandIAAaTickets",
          "lastBuildTime": "2022-02-18T13:32:54"
        },
        "collapsed": true
      },
      "instanceid": "69051-CD0D-C0",
      "isCascading": false
    },
    {
      "jaql": {
        "table": "ORDER DETAILS",
        "column": "Order ID",
        "dim": "[ORDER DETAILS.Order ID]",
        "datatype": "numeric",
        "title": "Order ID",
        "filter": {
          "top": 10000,
          "by": {
            "type": "measure",
            "formula": "( [77CF5-BBC] , [E986D-16D] )",
            "context": {
              "[E986D-16D]": {
                "table": "PERFORMANCE PRICING",
                "column": "Price Type",
                "dim": "[PERFORMANCE PRICING.Price Type]",
                "datatype": "text",
                "merged": true,
                "title": "Orders Containing this Price Type",
                "filter": {
                  "explicit": true,
                  "multiSelection": true,
                  "members": [
                    "Chaperone"
                  ]
                },
                "datasource": {
                  "title": "SDNA-Seats and Tickets",
                  "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
                  "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
                  "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
                  "database": "aSDNALQAaSeatsIAAaandIAAaTickets",
                  "lastBuildTime": "2022-02-18T13:32:54"
                }
              },
              "[77CF5-BBC]": {
                "table": "SEAT & TICKET VALUES",
                "column": "Ticket Count",
                "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                "datatype": "numeric",
                "agg": "sum",
                "title": "Total Ticket Count"
              },
              "[07DE2-BD7]": {
                "table": "PERFORMANCE PRICING",
                "column": "Price Type",
                "dim": "[PERFORMANCE PRICING.Price Type]",
                "datatype": "text",
                "merged": true,
                "title": "Price Type",
                "filter": {
                  "explicit": true,
                  "multiSelection": true,
                  "members": [
                    "Chaperone"
                  ]
                },
                "datasource": {
                  "title": "SDNA-Seats and Tickets",
                  "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
                  "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
                  "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
                  "database": "aSDNALQAaSeatsIAAaandIAAaTickets",
                  "lastBuildTime": "2022-02-18T13:32:54"
                }
              }
            },
            "title": "Formula"
          }
        },
        "datasource": {
          "title": "SDNA-Seats and Tickets",
          "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
          "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
          "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
          "database": "aSDNALQAaSeatsIAAaandIAAaTickets",
          "lastBuildTime": "2022-02-18T13:32:54"
        },
        "collapsed": false
      },
      "instanceid": "E7259-A798-CB",
      "isCascading": false
    }
  ],
  "filterToDatasourceMapping": {},
  "widgets": [
    {
      "title": "",
      "subtype": "pivot",
      "oid": "620ff72908d6e3191caa1364",
      "desc": null,
      "source": null,
      "datasource": {
        "title": "SDNA-Seats and Tickets",
        "fullname": "USEA2SAPCUBE400.aws.tnhs.cloud/SDNA-Seats and Tickets",
        "id": "aUSEA2SAPCUBE400LgAaAWSLgAaTNHSLgAaCLOUD_aSDNALQAaSEATSIAAaANDIAAaTICKETS",
        "address": "USEA2SAPCUBE400.aws.tnhs.cloud",
        "database": "aSDNALQAaSeatsIAAaandIAAaTickets",
        "lastBuildTime": "2022-02-18T13:32:54"
      },
      "selection": null,
      "metadata": {
        "ignore": {
          "dimensions": [],
          "all": false
        },
        "panels": [
          {
            "name": "rows",
            "items": [
              {
                "jaql": {
                  "table": "ORDER DETAILS",
                  "column": "Order ID",
                  "dim": "[ORDER DETAILS.Order ID]",
                  "datatype": "numeric",
                  "title": "Order ID"
                },
                "field": {
                  "id": "[ORDER DETAILS.Order ID]",
                  "index": 0
                }
              },
              {
                "jaql": {
                  "table": "PERFORMANCE PRICING",
                  "column": "Price Type",
                  "dim": "[PERFORMANCE PRICING.Price Type]",
                  "datatype": "text",
                  "merged": true,
                  "title": "Price Type"
                },
                "field": {
                  "id": "[PERFORMANCE PRICING.Price Type]",
                  "index": 1
                }
              }
            ]
          },
          {
            "name": "values",
            "items": [
              {
                "jaql": {
                  "table": "SEAT & TICKET VALUES",
                  "column": "Ticket Count",
                  "dim": "[SEAT & TICKET VALUES.Ticket Count]",
                  "datatype": "numeric",
                  "agg": "sum",
                  "title": "Total Ticket Count"
                },
                "format": {
                  "color": {
                    "type": "color",
                    "color": "transparent"
                  },
                  "mask": {
                    "type": "number",
                    "t": true,
                    "b": true,
                    "separated": true,
                    "decimals": "auto",
                    "isdefault": true
                  }
                },
                "field": {
                  "id": "[SEAT & TICKET VALUES.Ticket Count]_sum",
                  "index": 2
                }
              }
            ]
          },
          {
            "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": "1AC85-1402-B7",
      "queryStartTime": "2022-02-18T14:44:36",
      "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": "620ff69608d6e3191caa1331",
      "options": {
        "dashboardFiltersMode": "filter",
        "selector": false,
        "triggersDomready": true,
        "drillToAnywhere": true
      }
    }
  ],
  "hierarchies": []
}