{ "title": "21 AF Giving Pyramid", "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": "454ED-F6FB-D9", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbca", "height": 384 } ], "width": 50.04739336492891, "stretchable": false, "pxlWidth": 528, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbc9", "height": 384 } ], "width": 49.95260663507108, "stretchable": false, "pxlWidth": 527, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbc5", "height": 384 } ], "width": 50, "stretchable": false, "pxlWidth": 527, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbc8", "height": 384 } ], "width": 50, "stretchable": false, "pxlWidth": 528, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbc6", "height": 384 } ], "width": 50, "stretchable": false, "pxlWidth": 527, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5f217ce004e59a17fcd9cbc7", "height": 384 } ], "width": 50, "stretchable": false, "pxlWidth": 528, "index": 1 } ] } ], "pxlWidth": 1055, "index": 0 } ], "container": {} }, "original": null, "oid": "5f217ce004e59a17fcd9cbc4", "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "editing": true, "parentFolder": "5d7934eb7b34b83b644c55c6", "filters": [ { "instanceid": "0FEF3-1D2E-CF", "isCascading": true, "levels": [ { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "collapsed": true, "panel": "scope", "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "21 DEV Individual Annual" ] } }, { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "collapsed": true, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Indiv Annual Fund" ] } } ], "model": { "instanceid": "2324B-DF6E-3E", "__store": [ "[CAMPAIGN.Campaign1]", "[FUND.Fund]" ] }, "disabled": false }, { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount", "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } } }, "instanceid": "DBD11-5688-ED", "isCascading": false, "disabled": false }, { "jaql": { "datatype": "text", "dim": "[CONSTITUENT.Current FY Giving Range]", "title": "Current FY Giving Range", "column": "Current FY Giving Range", "table": "CONSTITUENT", "filter": { "explicit": false, "multiSelection": true, "all": true }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "collapsed": true }, "instanceid": "D3311-4CE2-70", "isCascading": false }, { "jaql": { "datatype": "text", "dim": "[CONSTITUENT.Last FY Giving Range]", "title": "Last FY Giving Range", "column": "Last FY Giving Range", "table": "CONSTITUENT", "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "collapsed": true, "merged": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "98C47-B376-E6", "isCascading": false, "disabled": false }, { "jaql": { "table": "CONTRIBUTION DATE", "column": "Calendar Month", "dim": "[CONTRIBUTION DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month", "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions", "lastBuildTime": "2021-01-18T23:53:04" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "7", "8", "9", "10", "11", "12" ] } }, "instanceid": "8797E-2B14-CE", "isCascading": false, "disabled": true } ], "filterToDatasourceMapping": {}, "isPublic": null, "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": 240, "tzName": "America/New_York", "context": { "dashboardid": "5f217ce004e59a17fcd9cbc4" }, "active": false, "executionPerDay": 1, "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false } }, "widgets": [ { "title": "Current FY Ranges", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Current FY Giving Range", "dim": "[CONSTITUENT.Current FY Giving Range]", "datatype": "text", "merged": true, "title": "Current FY Giving Range" }, "format": { "members": { " %360": { "color": "#547A94", "title": " $0", "sortData": " $0", "inResultset": true }, " %361-99": { "color": "#F48E06", "title": " $1-99", "sortData": " $1-99", "inResultset": true }, " %36100-%36499": { "color": "#DB4935", "title": " $100-$499", "sortData": " $100-$499", "inResultset": true }, " %36500-%36999": { "color": "#333333", "title": " $500-$999", "sortData": " $500-$999", "inResultset": true }, " %361,000-%362,499": { "color": "#008775", "title": " $1,000-$2,499", "sortData": " $1,000-$2,499", "inResultset": true }, " %362,500-%364,999": { "color": "#618caa", "title": " $2,500-$4,999", "sortData": " $2,500-$4,999", "inResultset": true }, " %365,000-%369,999": { "color": "#ff9b16", "title": " $5,000-$9,999", "sortData": " $5,000-$9,999", "inResultset": true }, " %3610,000-%3624,999": { "color": "#fc543d", "title": " $10,000-$24,999", "sortData": " $10,000-$24,999", "inResultset": true }, " %3625,000-%3649,999": { "color": "#3b3b3b", "title": " $25,000-$49,999", "sortData": " $25,000-$49,999", "inResultset": true }, " %36250,000-%36499,999": { "color": "#009b87", "title": " $250,000-$499,999", "sortData": " $250,000-$499,999", "inResultset": true } } }, "field": { "id": "[CONSTITUENT.Current FY Giving Range]", "index": 0 }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "field": { "index": 1 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# Constituents" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" }, "color": { "type": "color", "color": "transparent" } }, "disabled": false, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 1 } }, { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONTRIBUTION VALUES.Amount]_sum", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "type": "pivot", "oid": "5f217ce004e59a17fcd9cbc5", "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": "current_fy_giving_range", "title": "Current FY Giving Range", "singular": "Current FY Giving Range", "plural": "Current FY Giving Range" }, { "id": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "type", "title": "Type", "singular": "Type", "plural": "Type" } ] }, "rowsGrandTotal": true }, "instanceid": "AF71D-E644-51", "queryStartTime": "2020-02-19T09:57:01", "disableSelctor": false, "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": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5c812008c4a432155c8d38ce", "caption": "_ConstituentsContrib", "folder": null }, "selectorLocked": false }, "drawing": true, "canEditFilters": true, "viewState": { "activeTab": "filters" } }, { "title": "LYBUNT", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CAMPAIGN.Campaign1]", "[FUND.Fund]" ], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "field": { "id": "[CONSTITUENT.Last FY Giving Range]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "(count([93C03-910]), [CD1B2-353])", "context": { "[93C03-910]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[2EE34-801]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "19 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } }, "[CD1B2-353]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, "title": "# Constituents" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" }, "color": { "type": "color", "color": "transparent" } }, "disabled": false, "field": { "id": "(count([93C03-910]), [CD1B2-353])", "index": 1 } }, { "jaql": { "type": "measure", "formula": "[F086A-261]", "context": { "[F086A-261]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "FY20 Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[F086A-261]", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Lists", "dim": "[CONSTITUENT.Lists]", "datatype": "text", "merged": true, "title": "Lists", "filter": { "contains": ",8902," }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP003.kriostess.local/CSTA-Contributions", "id": "aNARCUBEBP003LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP003.kriostess.local", "database": "aCSTALQAaContributions", "lastBuildTime": "2019-04-15T01:40:16" }, "collapsed": false } }, { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "filter": { "explicit": true, "multiSelection": true, "members": [ "Indiv Annual Fund" ] }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "collapsed": true, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "type": "pivot", "oid": "5f217ce004e59a17fcd9cbc6", "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": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "lists", "title": "Lists", "singular": "Lists", "plural": "Lists" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" } ] }, "rowsGrandTotal": true }, "instanceid": "AF71D-E644-51", "queryStartTime": "2020-07-29T09:51:37", "disableSelctor": false, "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": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5c812008c4a432155c8d38ce", "caption": "_ConstituentsContrib", "folder": null } }, "drawing": true, "viewState": { "activeTab": "filters" }, "canEditFilters": true }, { "title": "LYBUNT", "subtype": "bar/classic", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CAMPAIGN.Campaign1]", "[FUND.Fund]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "field": { "id": "[CONSTITUENT.Last FY Giving Range]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "(count([CC7F1-7F3]), [44147-739])", "context": { "[CC7F1-7F3]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[AA595-3E1]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "19 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } }, "[44147-739]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, "title": "# Constituents" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } }, "disabled": false, "field": { "id": "(count([2D504-4E1]), [A9AD6-588])", "index": 1 }, "y2": true }, { "jaql": { "type": "measure", "formula": "[66501-057]", "context": { "[66501-057]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "FY20 Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "(sum([ED95D-CC4]), [891AB-2E8])", "index": 2 }, "singleSeriesType": "line" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Lists", "dim": "[CONSTITUENT.Lists]", "datatype": "text", "merged": true, "title": "Lists", "filter": { "contains": ",8902," }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP003.kriostess.local/CSTA-Contributions", "id": "aNARCUBEBP003LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP003.kriostess.local", "database": "aCSTALQAaContributions", "lastBuildTime": "2019-04-15T01:40:16" }, "collapsed": false } }, { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "filter": { "explicit": true, "multiSelection": true, "members": [ "Indiv Annual Fund" ] }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "collapsed": true, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "type": "chart/bar", "oid": "5f217ce004e59a17fcd9cbc7", "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": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "templateMainYHasGridLines": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "lists", "title": "Lists", "singular": "Lists", "plural": "Lists" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" } ] } }, "instanceid": "F28EA-07B3-61", "queryStartTime": "2021-01-19T15:50:43", "disableSelctor": false, "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 }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "drawing": true }, { "title": "FY20 Final", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CAMPAIGN.Campaign1]", "[FUND.Fund]" ], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "field": { "id": "[CONSTITUENT.Last FY Giving Range]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "(count([ADE7C-E32]), [39475-2C6])", "context": { "[ADE7C-E32]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[93941-C80]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "19 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } }, "[39475-2C6]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, "title": "# Constituents" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" }, "color": { "type": "color", "color": "transparent" } }, "disabled": false, "field": { "id": "(count([ADE7C-E32]), [39475-2C6])", "index": 1 } }, { "jaql": { "type": "measure", "formula": "[72541-E68]", "context": { "[72541-E68]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "FY20 Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[72541-E68]", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "filter": { "explicit": true, "multiSelection": true, "members": [ "Indiv Annual Fund" ] }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "collapsed": true, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "oid": "5f217ce004e59a17fcd9cbc8", "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": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" } ] }, "rowsGrandTotal": true }, "instanceid": "AF71D-E644-51", "queryStartTime": "2020-07-29T09:45:18", "disableSelctor": false, "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": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5c812008c4a432155c8d38ce", "caption": "_ConstituentsContrib", "folder": null } }, "drawing": true }, { "title": "FY20 Final", "subtype": "bar/classic", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[CAMPAIGN.Campaign1]", "[FUND.Fund]" ], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "field": { "id": "[CONSTITUENT.Last FY Giving Range]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "(count([FEED5-60F]), [BEDF3-DC8])", "context": { "[FEED5-60F]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[81756-785]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "19 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } }, "[BEDF3-DC8]": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, "title": "# Constituents" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } }, "disabled": false, "field": { "id": "(count([2D504-4E1]), [A9AD6-588])", "index": 1 }, "y2": true }, { "jaql": { "type": "measure", "formula": "[BCB89-DF2]", "context": { "[BCB89-DF2]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "FY20 Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "(sum([ED95D-CC4]), [891AB-2E8])", "index": 2 }, "singleSeriesType": "line" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "filter": { "explicit": true, "multiSelection": true, "members": [ "Indiv Annual Fund" ] }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign1]", "datatype": "text", "merged": true, "title": "Campaign", "filter": { "explicit": true, "multiSelection": true, "members": [ "20 DEV Individual Annual" ] }, "collapsed": true, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "oid": "5f217ce004e59a17fcd9cbc9", "type": "chart/bar", "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": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "templateMainYHasGridLines": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" } ] } }, "instanceid": "AAE6F-58C7-42", "queryStartTime": "2021-01-19T15:50:43", "disableSelctor": false, "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 }, "chart": { "0": {}, "context": {}, "length": 1 }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "drawing": true }, { "title": "Current FY Ranges", "subtype": "bar/classic", "desc": null, "source": null, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Current FY Giving Range", "dim": "[CONSTITUENT.Current FY Giving Range]", "datatype": "text", "merged": true, "title": "Current FY Giving Range" }, "format": { "members": { " %360": { "color": "#547A94", "title": " $0", "sortData": " $0" }, " %361-99": { "color": "#F48E06", "title": " $1-99", "sortData": " $1-99" }, " %36100-%36499": { "color": "#DB4935", "title": " $100-$499", "sortData": " $100-$499" }, " %36500-%36999": { "color": "#333333", "title": " $500-$999", "sortData": " $500-$999" }, " %361,000-%362,499": { "color": "#008775", "title": " $1,000-$2,499", "sortData": " $1,000-$2,499" }, " %362,500-%364,999": { "color": "#618caa", "title": " $2,500-$4,999", "sortData": " $2,500-$4,999" }, " %365,000-%369,999": { "color": "#ff9b16", "title": " $5,000-$9,999", "sortData": " $5,000-$9,999" }, " %3610,000-%3624,999": { "color": "#fc543d", "title": " $10,000-$24,999", "sortData": " $10,000-$24,999" }, " %3625,000-%3649,999": { "color": "#3b3b3b", "title": " $25,000-$49,999", "sortData": " $25,000-$49,999" }, " %36250,000-%36499,999": { "color": "#009b87", "title": " $250,000-$499,999", "sortData": " $250,000-$499,999" }, " %361-99": { "color": "#6897b7", "title": " $1-99", "sortData": " $1-99" }, " %36100-%36249": { "color": "#ffa022", "title": " $100-$249", "sortData": " $100-$249" }, " %36250-%36499": { "color": "#ff5d47", "title": " $250-$499", "sortData": " $250-$499" }, " %360": { "color": "#3f3f3f", "title": " $0", "sortData": " $0" }, " %3650,000-%3699,999": { "color": "#00a790", "title": " $50,000-$99,999", "sortData": " $50,000-$99,999" }, " %361-%36100": { "color": "#6fa1c3", "title": " $1-$100", "sortData": " $1-$100" }, " %36100-%36250": { "color": "#ffa62e", "title": " $100-$250", "sortData": " $100-$250" }, " %36250-%36500": { "color": "#ff6752", "title": " $250-$500", "sortData": " $250-$500" }, " %36500-%361,000": { "color": "#434343", "title": " $500-$1,000", "sortData": " $500-$1,000" }, " %361,000-%362,500": { "color": "#00b29a", "title": " $1,000-$2,500", "sortData": " $1,000-$2,500" }, " %362,500-%365,000": { "color": "#74a9cd", "title": " $2,500-$5,000", "sortData": " $2,500-$5,000", "inResultset": true }, " %365,000-%3610,000": { "color": "#ffaa38", "title": " $5,000-$10,000", "sortData": " $5,000-$10,000", "inResultset": true }, " %3610,000-%3625,000": { "color": "#ff6f5b", "title": " $10,000-$25,000", "sortData": " $10,000-$25,000", "inResultset": true }, " %3625,000-%3650,000": { "color": "#474747", "title": " $25,000-$50,000", "sortData": " $25,000-$50,000", "inResultset": true }, " %3650,000-%36100,000": { "color": "#00bba2", "title": " $50,000-$100,000", "sortData": " $50,000-$100,000", "inResultset": true }, " %361-%36100": { "color": "#79afd5", "title": " $1-$100", "sortData": " $1-$100", "inResultset": true }, " %36100-%36250": { "color": "#ffad3f", "title": " $100-$250", "sortData": " $100-$250", "inResultset": true }, " %36250-%36500": { "color": "#ff7461", "title": " $250-$500", "sortData": " $250-$500", "inResultset": true }, " %36500-%361,000": { "color": "#494949", "title": " $500-$1,000", "sortData": " $500-$1,000", "inResultset": true }, " %361,000-%361,500": { "color": "#00c2a8", "title": " $1,000-$1,500", "sortData": " $1,000-$1,500", "inResultset": true }, " %361,500-%362,500": { "color": "#7cb4db", "title": " $1,500-$2,500", "sortData": " $1,500-$2,500", "inResultset": true }, " %36100,000-%36250,000": { "color": "#ffaf45", "title": " $100,000-$250,000", "sortData": " $100,000-$250,000" }, " %360": { "color": "#ff7966", "title": " $0", "sortData": " $0" } } }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Last FY Giving Range", "dim": "[CONSTITUENT.Last FY Giving Range]", "datatype": "text", "merged": true, "title": "Last FY Giving Range" }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# Constituents" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" }, "color": { "color": "#547A94", "type": "color" } }, "disabled": false, "y2": true }, { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "color": "#F48E06", "type": "color" } }, "singleSeriesType": "line", "y2": false } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "CSTA-Contributions", "fullname": "NARCUBEBP010.KRIOSTESS.local/CSTA-Contributions", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aCSTALQAaCONTRIBUTIONS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aCSTALQAaContributions" } } } ] } ] }, "oid": "5f217ce004e59a17fcd9cbca", "type": "chart/bar", "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": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "templateMainYHasGridLines": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "current_fy_giving_range", "title": "Current FY Giving Range", "singular": "Current FY Giving Range", "plural": "Current FY Giving Range" }, { "id": "last_fy_giving_range", "title": "Last FY Giving Range", "singular": "Last FY Giving Range", "plural": "Last FY Giving Range" }, { "id": "type", "title": "Type", "singular": "Type", "plural": "Type" } ] } }, "instanceid": "15EA0-D41F-C3", "queryStartTime": "2021-01-19T15:50:43", "disableSelctor": false, "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 }, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "drilledDashboardDisplay": {}, "canEditFilters": true, "dashboardid": "5f217ce004e59a17fcd9cbc4", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "drawing": true } ], "hierarchies": [] }