{ "title": "SCT Cash Flow", "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": "FD13F-70DC-11", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "362px", "defaultWidth": 512, "widgetid": "6303e85644e8471bb8ccfaf3", "autoHeight": "362px" } ], "width": 100, "stretchable": false, "pxlWidth": 1352, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "450px", "defaultWidth": 512, "widgetid": "6303ec5344e8471bb8ccfb79", "autoHeight": "450px" } ], "width": 100, "stretchable": false, "pxlWidth": 1352, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "1460px", "defaultWidth": 512, "widgetid": "6303fa5044e8471bb8ccfe4e", "autoHeight": "1460px" } ], "width": 100, "stretchable": false, "pxlWidth": 1352, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "6317a8537ed0404bac6fa677" } ], "width": 100, "stretchable": false, "pxlWidth": 1352, "index": 0 } ] } ], "pxlWidth": 1352, "index": 0 } ], "container": {} }, "original": null, "oid": "6303e33844e8471bb8ccfa3e", "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance" }, "editing": true, "filters": [ { "jaql": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method", "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } } }, "instanceid": "DD20D-9E27-CE", "isCascading": false, "locked": false } ], "filterToDatasourceMapping": {}, "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": 420, "tzName": "America/Los_Angeles", "context": { "dashboardid": "6303e33844e8471bb8ccfa3e" }, "active": false, "executionPerDay": 1, "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false }, "subscribe": false }, "isPublic": null, "parentFolder": "645bb64caeeb0e3078dcaf2b", "migrated": true, "lastPublish": "2023-05-16T14:23:07.915Z", "allowChangeSubscription": false, "previewLayout": null, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "Income 5-year average by month", "type": "pivot", "subtype": "pivot", "oid": "6303e85644e8471bb8ccfaf3", "desc": null, "source": null, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "POST DATE", "column": "Fiscal Year", "dim": "[POST.Fiscal Year1]", "datatype": "numeric", "title": "Fiscal Year" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "POST DATE", "column": "Calendar Month Sort", "dim": "[POST.Calendar Month Sort1]", "datatype": "text", "merged": true, "title": "Calendar Month Sort" }, "field": { "id": "[POST.Calendar Month Sort1]", "index": 0 }, "format": { "subtotal": true }, "disabled": false }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign Category", "dim": "[CAMPAIGN.Campaign Category]", "datatype": "text", "merged": true, "title": "Campaign Category" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "GL ACCOUNT", "column": "GL Account Code", "dim": "[GL.GL Account Code1]", "datatype": "text", "merged": true, "title": "GL Account Code" }, "field": { "index": 1 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "([8B8AA-646],[1B8DE-B69])/5", "context": { "[1B8DE-B69]": { "table": "POST DATE", "column": "Fiscal Current Year Offset", "dim": "[POST DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1", "-2", "-3", "-4", "-5" ] }, "collapsed": false, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" } }, "[8B8AA-646]": { "table": "FINANCE VALUES", "column": "Transaction Amount", "dim": "[FINANCE VALUES.Transaction Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Transaction Amount" } }, "title": "Average of previous 5 FYs" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "([8B8AA-646],[1B8DE-B69])/5", "index": 1 }, "disabled": false }, { "jaql": { "table": "FINANCE VALUES", "column": "Transaction Amount", "dim": "[FINANCE VALUES.Transaction Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Transaction Amount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "([0722A-D31],[D894E-AB4])/3", "context": { "[D894E-AB4]": { "table": "POST DATE", "column": "Fiscal Current Year Offset", "dim": "[POST DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1", "-2", "-3" ] }, "collapsed": false, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" } }, "[0722A-D31]": { "table": "FINANCE VALUES", "column": "Transaction Amount", "dim": "[FINANCE VALUES.Transaction Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Transaction Amount" } }, "title": "Average of previous 3 FYs", "filter": { "doesntEqual": "0" }, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "disabled": true } ] } ] }, "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": "200", "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": "fiscal_year", "title": "Fiscal Year", "singular": "Fiscal Year", "plural": "Fiscal Year" }, { "id": "calendar_month_sort", "title": "Calendar Month Sort", "singular": "Calendar Month Sort", "plural": "Calendar Month Sort" }, { "id": "campaign_category", "title": "Campaign Category", "singular": "Campaign Category", "plural": "Campaign Category" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "gl_account_code", "title": "GL Account Code", "singular": "GL Account Code", "plural": "GL Account Code" } ] }, "rowsGrandTotal": true }, "instanceid": "34497-DCCA-9E", "queryStartTime": "2022-09-01T10:25:20", "widgetTimingLoged": false, "drawing": true, "canEditFilters": true, "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 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "6303e33844e8471bb8ccfa3e", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "script_old": null, "script": null }, { "title": "Open Pledges", "type": "pivot", "subtype": "pivot", "oid": "6303ec5344e8471bb8ccfb79", "desc": null, "source": null, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[PAYMENT.Payment Method1]" ], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "FINANCE DETAILS", "column": "Contribution Pledge Status", "dim": "[FINANCE DETAILS.Contribution Pledge Status]", "datatype": "text", "merged": true, "title": "Contribution Pledge Status" }, "field": { "id": "[FINANCE DETAILS.Contribution Pledge Status]", "index": 0 } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign]", "datatype": "text", "merged": true, "title": "Campaign" }, "field": { "id": "[CAMPAIGN.Campaign]", "index": 1 } }, { "jaql": { "table": "CONTRIBUTION DATE", "column": "Fiscal Year", "dim": "[CONTRIBUTION.Fiscal Year1]", "datatype": "numeric", "title": "Contribution Date" }, "field": { "id": "[CONTRIBUTION.Fiscal Year1]", "index": 2 } }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent Sort Name", "dim": "[CONSTITUENT.Constituent Sort Name]", "datatype": "text", "merged": true, "title": "Constituent Sort Name" }, "field": { "id": "[CONSTITUENT.Constituent Sort Name]", "index": 3 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "FINANCE VALUES", "column": "Contribution Balance Amount", "dim": "[FINANCE VALUES.Contribution Balance Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Contribution Balance Amount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[FINANCE VALUES.Contribution Balance Amount]_sum", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "POST DATE", "column": "Fiscal Current Year Offset", "dim": "[POST DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0", "-1", "-2", "-3" ] }, "collapsed": false, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" } }, "disabled": false }, { "jaql": { "table": "FINANCE DETAILS", "column": "Contribution Pledge Status", "dim": "[FINANCE DETAILS.Contribution Pledge Status]", "datatype": "text", "merged": true, "title": "Contribution Pledge Status", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Paid in Full", "(none)", "Written Off" ] } }, "collapsed": false, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" } }, "title": "Contribution Pledge Status" }, { "jaql": { "table": "FINANCE VALUES", "column": "Contribution Balance Amount", "dim": "[FINANCE VALUES.Contribution Balance Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Contribution Balance Amount", "filter": { "fromNotEqual": "0" }, "collapsed": false, "datasource": { "title": "SEAC-Finance", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Finance", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaFINANCE", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaFinance", "lastBuildTime": "2022-08-22T01:00:22" } }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "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": "100", "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": "contribution_pledge_status", "title": "Contribution Pledge Status", "singular": "Contribution Pledge Status", "plural": "Contribution Pledge Status" }, { "id": "contribution_date", "title": "Contribution Date", "singular": "Contribution Date", "plural": "Contribution Date" }, { "id": "constituent_sort_name", "title": "Constituent Sort Name", "singular": "Constituent Sort Name", "plural": "Constituent Sort Name" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" }, { "id": "fiscal_current_year_offset", "title": "Fiscal Current Year Offset", "singular": "Fiscal Current Year Offset", "plural": "Fiscal Current Year Offset" } ] } }, "instanceid": "28F44-A8C2-18", "queryStartTime": "2022-08-22T14:40:51", "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 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "6303e33844e8471bb8ccfa3e", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "script_old": null, "script": null }, { "title": "Unpaid Classes and Tickets by Fiscal Period of Class/Performance", "type": "pivot", "subtype": "pivot", "oid": "6303fa5044e8471bb8ccfe4e", "desc": null, "source": null, "datasource": { "title": "SEAC-Seats and Tickets", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Seats and Tickets", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaSEATSIAAaANDIAAaTICKETS", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2022-08-22T01:09:25" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Period", "dim": "[PERFORMANCE DATE.Fiscal Period]", "datatype": "numeric", "title": "Fiscal Period" }, "field": { "id": "[PERFORMANCE DATE.Fiscal Period]", "index": 0 }, "format": { "subtotal": true } }, { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season" }, "field": { "id": "[SEASON.Season]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Perf/Class date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 2 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Unpaid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Unpaid Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]_sum", "index": 3 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": true, "datasource": { "title": "SEAC-Seats and Tickets", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Seats and Tickets", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaSEATSIAAaANDIAAaTICKETS", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaSeatsIAAaandIAAaTickets" } } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Unpaid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Unpaid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Unpaid Amount", "filter": { "fromNotEqual": 0 }, "datasource": { "title": "SEAC-Seats and Tickets", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Seats and Tickets", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaSEATSIAAaANDIAAaTICKETS", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaSeatsIAAaandIAAaTickets" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "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": "100", "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": "fiscal_period", "title": "Fiscal Period", "singular": "Fiscal Period", "plural": "Fiscal Period" }, { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "season_fiscal_current_year_offset", "title": "Season Fiscal Current Year Offset", "singular": "Season Fiscal Current Year Offset", "plural": "Season Fiscal Current Year Offset" } ] } }, "instanceid": "A4D5E-EDF7-9D", "queryStartTime": "2022-08-22T14:52:26", "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 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "6303e33844e8471bb8ccfa3e", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true, "script_old": null, "script": null }, { "title": "Plan Worker Details", "type": "pivot", "subtype": "pivot", "oid": "6317a8537ed0404bac6fa677", "desc": null, "source": "62fb9240dce3e91f745feb51", "datasource": { "title": "SEAC-Plans", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Plans", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaPLANS", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaPlans", "lastBuildTime": "2022-09-06T00:52:52" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PLAN WORKER CONSTITUENT (!)", "column": "Plan Worker Sort Name", "dim": "[PLAN WORKER CONSTITUENT (!).Plan Worker Sort Name]", "datatype": "text", "merged": true, "title": "Plan Worker Name" }, "field": { "id": "[PLAN WORKER CONSTITUENT (!).Plan Worker Sort Name]", "index": 0 }, "format": { "subtotal": false } }, { "jaql": { "table": "PLAN & STEP DETAILS", "column": "Plan Status", "dim": "[PLAN & STEP DETAILS.Plan Status]", "datatype": "text", "merged": true, "title": "Plan Status" }, "field": { "id": "[PLAN & STEP DETAILS.Plan Status]", "index": 1 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[76F62-5AB]", "context": { "[76F62-5AB]": { "table": "PLAN & STEP VALUES", "column": "Plan Count", "dim": "[PLAN AND STEP.Plan Count1]", "datatype": "numeric", "agg": "sum", "title": "Total Plan Count" } }, "title": "# of Plans" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[76F62-5AB]", "index": 2 } }, { "jaql": { "type": "measure", "formula": "[27744-51D]", "context": { "[27744-51D]": { "table": "PLAN & STEP VALUES", "column": "Ask Amount", "dim": "[PLAN AND STEP.Ask Amount1]", "datatype": "numeric", "agg": "sum", "title": "Total Ask Amount" } }, "title": "Ask Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[27744-51D]", "index": 3 } }, { "jaql": { "type": "measure", "formula": "[11C9C-54E]", "context": { "[11C9C-54E]": { "table": "PLAN & STEP VALUES", "column": "Goal Amount", "dim": "[PLAN AND STEP.Goal Amount1]", "datatype": "numeric", "agg": "sum", "title": "Total Goal Amount" } }, "title": "Goal Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[11C9C-54E]", "index": 4 } }, { "jaql": { "type": "measure", "formula": "[330A2-3E2]", "context": { "[330A2-3E2]": { "table": "PLAN & STEP VALUES", "column": "Contribution Amount", "dim": "[PLAN AND STEP.Contribution Amount1]", "datatype": "numeric", "agg": "sum", "title": "Total Contribution Amount" } }, "title": "Contribution Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[330A2-3E2]", "index": 5 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PLAN WORKER LINK", "column": "Primary Flag", "dim": "[PLAN WORKER.Primary Flag1]", "datatype": "text", "merged": true, "title": "Primary Flag", "filter": { "equals": "Y" }, "collapsed": false } }, { "jaql": { "table": "PLAN & STEP DETAILS", "column": "Plan or Step", "dim": "[PLAN & STEP DETAILS.Plan or Step]", "datatype": "text", "merged": true, "title": "Plan or Step", "filter": { "equals": "Plan" }, "collapsed": false } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Current Year Offset", "dim": "[CAMPAIGN.Campaign Fiscal Current Year Offset]", "datatype": "numeric", "title": "Campaign Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "SEAC-Plans", "fullname": "USWE2UAPCUBE208.aws.tnhs.cloud/SEAC-Plans", "id": "aUSWE2UAPCUBE208LgAaAWSLgAaTNHSLgAaCLOUD_aSEACLQAaPLANS", "address": "USWE2UAPCUBE208.aws.tnhs.cloud", "database": "aSEACLQAaPlans", "lastBuildTime": "2022-09-06T00:52:52" } } } ] } ] }, "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": false, "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": "plan_worker_name", "title": "Plan Worker Name", "singular": "Plan Worker Name", "plural": "Plan Worker Name" }, { "id": "plan_status", "title": "Plan Status", "singular": "Plan Status", "plural": "Plan Status" }, { "id": "primary_flag", "title": "Primary Flag", "singular": "Primary Flag", "plural": "Primary Flag" }, { "id": "plan_or_step", "title": "Plan or Step", "singular": "Plan or Step", "plural": "Plan or Step" }, { "id": "campaign_fiscal_current_year_offset", "title": "Campaign Fiscal Current Year Offset", "singular": "Campaign Fiscal Current Year Offset", "plural": "Campaign Fiscal Current Year Offset" } ] }, "rowsGrandTotal": true }, "instanceid": "096D7-18F9-3B", "queryStartTime": "2022-09-06T13:10:20", "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": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "canEditFilters": true, "drilledDashboardDisplay": {}, "options": { "dashboardFiltersMode": "select", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false, "drillTarget": { "oid": "62fb923bdce3e91f745fe938", "caption": "_Fundraising Progress", "folder": "60fad2b5760ca02118779188" } }, "dashboardid": "6303e33844e8471bb8ccfa3e", "drawing": true, "viewState": { "activeTab": "filters" }, "script_old": null, "script": null } ], "hierarchies": [] }