{ "title": "3 Year Contributers w/Increases", "oid": "613fc778f29d041bc45407ab", "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": "E130E-2034-94", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "613fc788f29d041bc45407c2" } ], "width": 29.618979151689434, "stretchable": false, "pxlWidth": 412, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6144dc2f378c412090f457e8", "height": 384 } ], "width": 27.31847591660676, "stretchable": false, "pxlWidth": 380, "index": 1 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6144dcda378c412090f45805", "height": 384 } ], "width": 43.06254493170381, "stretchable": false, "pxlWidth": 1011, "index": 2 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "6144ddfd378c412090f45854" } ] } ] } ], "pxlWidth": 1391, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions" }, "editing": true, "filters": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Current Year Offset", "dim": "[CAMPAIGN.Campaign Fiscal Current Year Offset]", "datatype": "numeric", "title": "Campaign Fiscal Current Year Offset", "collapsed": true, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-17T00:51:41" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "0", "-1", "-2" ] } }, "instanceid": "40C6D-7D24-A0", "isCascading": false } ], "filterToDatasourceMapping": {}, "widgets": [ { "title": "All Contributers over 3 Years", "subtype": "pivot", "oid": "613fc788f29d041bc45407c2", "desc": null, "source": null, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "color": { "type": "color", "color": "transparent" }, "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "field": { "id": "[CONTRIBUTION VALUES.Amount]_sum", "index": 2 } } ] }, { "name": "columns", "items": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year" }, "field": { "id": "[CAMPAIGN.Campaign Fiscal Year]", "index": 1 } } ] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": "5", "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": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "campaign_fiscal_year", "title": "Campaign Fiscal Year", "singular": "Campaign Fiscal Year", "plural": "Campaign Fiscal Year" } ] } }, "instanceid": "5F3D1-DA6F-8C", "queryStartTime": "2021-09-17T14:25:37", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "613fc778f29d041bc45407ab", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "viewState": { "activeTab": "design" } }, { "title": "3 Year Contributers w/Increases", "subtype": "pivot", "oid": "6144dc2f378c412090f457e8", "desc": null, "source": null, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "color": { "type": "color", "color": "transparent" }, "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "field": { "id": "[CONTRIBUTION VALUES.Amount]_sum", "index": 1 } }, { "jaql": { "type": "measure", "formula": "IF(\n ( [63BCB-8D0] , [4DF39-4C0] ) > 0\n AND\n ([63BCB-8D0] , [4DF39-4C0]) < ([63BCB-8D0] , [F81A7-81D])\n AND\n ([63BCB-8D0] , [F81A7-81D]) < ([63BCB-8D0] , [45EE5-CE6])\n , 1\n , NULL\n )", "context": { "[45EE5-CE6]": { "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": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[F81A7-81D]": { "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": [ "-1" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[4DF39-4C0]": { "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": [ "-2" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[63BCB-8D0]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "3yrGivingInc Flag" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF(\n ( [63BCB-8D0] , [4DF39-4C0] ) > 0\n AND\n ([63BCB-8D0] , [4DF39-4C0]) < ([63BCB-8D0] , [F81A7-81D])\n AND\n ([63BCB-8D0] , [F81A7-81D]) < ([63BCB-8D0] , [45EE5-CE6])\n , 1\n , NULL\n )", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "IF(\n ( [63BCB-8D0] , [4DF39-4C0] ) > 0\n AND\n ([63BCB-8D0] , [4DF39-4C0]) < ([63BCB-8D0] , [F81A7-81D])\n AND\n ([63BCB-8D0] , [F81A7-81D]) < ([63BCB-8D0] , [45EE5-CE6])\n , 1\n , NULL\n )", "context": { "[45EE5-CE6]": { "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": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[F81A7-81D]": { "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": [ "-1" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[4DF39-4C0]": { "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": [ "-2" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[63BCB-8D0]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "3yrGivingInc Flag", "filter": { "equals": 1 }, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "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": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" } ] } }, "instanceid": "5F3D1-DA6F-8C", "queryStartTime": "2021-09-17T14:21:54", "widgetTimingLoged": 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 }, "realTimeRefreshing": false, "viewState": { "activeTab": "filters" }, "dashboardid": "613fc778f29d041bc45407ab", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true, "drawing": true }, { "title": "3 Year Contributers w/Increases and Giving", "subtype": "pivot", "oid": "6144dcda378c412090f45805", "desc": null, "source": null, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "color": { "type": "color", "color": "transparent" }, "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "field": { "id": "[CONTRIBUTION VALUES.Amount]_sum", "index": 2 } }, { "jaql": { "type": "measure", "formula": "IF(\n ( [63BCB-8D0] , [4DF39-4C0] ) > 0\n AND\n ([63BCB-8D0] , [4DF39-4C0]) < ([63BCB-8D0] , [F81A7-81D])\n AND\n ([63BCB-8D0] , [F81A7-81D]) < ([63BCB-8D0] , [45EE5-CE6])\n , 1\n , NULL\n )", "context": { "[45EE5-CE6]": { "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": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[F81A7-81D]": { "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": [ "-1" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[4DF39-4C0]": { "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": [ "-2" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[63BCB-8D0]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "3yrGivingInc Flag" }, "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": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year" }, "field": { "id": "[CAMPAIGN.Campaign Fiscal Year]", "index": 1 } } ] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "IF(\n ( [63BCB-8D0] , [4DF39-4C0] ) > 0\n AND\n ([63BCB-8D0] , [4DF39-4C0]) < ([63BCB-8D0] , [F81A7-81D])\n AND\n ([63BCB-8D0] , [F81A7-81D]) < ([63BCB-8D0] , [45EE5-CE6])\n , 1\n , NULL\n )", "context": { "[45EE5-CE6]": { "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": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[F81A7-81D]": { "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": [ "-1" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[4DF39-4C0]": { "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": [ "-2" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[63BCB-8D0]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "3yrGivingInc Flag", "filter": { "equals": 1 }, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "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": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "campaign_fiscal_year", "title": "Campaign Fiscal Year", "singular": "Campaign Fiscal Year", "plural": "Campaign Fiscal Year" } ] }, "rowsGrandTotal": false, "columnsGrandTotal": true }, "instanceid": "5F3D1-DA6F-8C", "queryStartTime": "2021-09-17T14:22:54", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "viewState": { "activeTab": "design" }, "canEditFilters": true, "dashboardid": "613fc778f29d041bc45407ab", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "drawing": true }, { "title": "Attempted Constituent ID widget filter on 3YearInc Flag", "subtype": "pivot", "oid": "6144ddfd378c412090f45854", "desc": null, "source": null, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONTRIBUTION VALUES.Amount]_sum", "index": 2 } } ] }, { "name": "columns", "items": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year" }, "field": { "id": "[CAMPAIGN.Campaign Fiscal Year]", "index": 1 } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "filter": { "top": 10, "by": { "type": "measure", "formula": "IF(\n ( [4A242-872] , [74B63-A4C] ) > 0\n AND\n ([4A242-872] , [74B63-A4C]) < ([4A242-872] , [096CD-B63])\n AND\n ([4A242-872] , [096CD-B63]) < ([4A242-872] , [DDDAB-838])\n , 1\n , NULL\n )", "context": { "[DDDAB-838]": { "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": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[096CD-B63]": { "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": [ "-1" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[74B63-A4C]": { "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": [ "-2" ] }, "collapsed": false, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions", "lastBuildTime": "2021-09-13T00:50:04" } }, "[4A242-872]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Formula" } }, "datasource": { "title": "SDNA-Contributions", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Contributions", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaCONTRIBUTIONS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaContributions" }, "collapsed": false } } ] } ] }, "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": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "campaign_fiscal_year", "title": "Campaign Fiscal Year", "singular": "Campaign Fiscal Year", "plural": "Campaign Fiscal Year" } ] } }, "instanceid": "421A6-1573-FC", "queryStartTime": "2021-09-17T14:26:36", "widgetTimingLoged": false, "drawing": 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": "613fc778f29d041bc45407ab", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true } } ], "hierarchies": [] }