{ "title": "pulling-pledge-payments", "oid": "6012e35d9b3eba12b07e0df2", "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": "BBBBE-E1C7-AF", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "164px", "defaultWidth": 512, "widgetid": "6012e7549b3eba12b07e0e5b" } ], "width": 100, "stretchable": false, "pxlWidth": 100, "index": 0 } ] } ], "pxlWidth": 100, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance" }, "editing": true, "filters": [ { "jaql": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Transaction Date", "level": "years", "collapsed": true, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:18" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] } }, "instanceid": "1A0D7-6D76-F2", "isCascading": false, "disabled": false }, { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type", "collapsed": true, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:18" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Adjustment to Payment", "Adjustment to Pledge", "Pledge", "Pledge Payment Received", "Adjustment to Gift", "Gift", "Gift Change" ], "filter": { "turnedOff": true, "exclude": { "members": [ "Adjustment to Gift", "Gift", "Gift Change" ] } } } }, "instanceid": "7BF67-3E8A-D5", "isCascading": false, "disabled": false } ], "filterToDatasourceMapping": {}, "widgets": [ { "title": "", "subtype": "pivot", "oid": "6012e7549b3eba12b07e0e5b", "desc": null, "source": null, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:18" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent Display Name", "dim": "[CONSTITUENT.Constituent Display Name]", "datatype": "text", "merged": true, "title": "Constituent Display Name" }, "field": { "id": "[CONSTITUENT.Constituent Display Name]", "index": 0 }, "format": { "subtotal": false, "width": 191 }, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 1 }, "format": { "members": { "2": { "color": "#474747", "title": "2", "sortData": 2, "inResultset": true }, "7": { "color": "#7cb4db", "title": "7", "sortData": 7, "inResultset": true }, "34": { "color": "#00c7ad", "title": "34", "sortData": 34, "inResultset": true }, "127": { "color": "#618caa", "title": "127", "sortData": 127, "inResultset": true }, "200": { "color": "#ff7d6b", "title": "200", "sortData": 200, "inResultset": true }, "214": { "color": "#00b29a", "title": "214", "sortData": 214, "inResultset": true }, "35578": { "color": "#81bce4", "title": "35578", "sortData": 35578, "inResultset": true }, "35618": { "color": "#6897b7", "title": "35618", "sortData": 35618, "inResultset": true }, "35648": { "color": "#4e4e4e", "title": "35648", "sortData": 35648, "inResultset": true }, "35672": { "color": "#ffa022", "title": "35672", "sortData": 35672, "inResultset": true }, "35810": { "color": "#00bba2", "title": "35810", "sortData": 35810, "inResultset": true }, "35864": { "color": "#ffb552", "title": "35864", "sortData": 35864, "inResultset": true }, "35869": { "color": "#ff9b16", "title": "35869", "sortData": 35869, "inResultset": true }, "35939": { "color": "#00d0b4", "title": "35939", "sortData": 35939, "inResultset": true }, "35971": { "color": "#434343", "title": "35971", "sortData": 35971, "inResultset": true }, "36012": { "color": "#6fa1c3", "title": "36012", "sortData": 36012, "inResultset": true }, "36050": { "color": "#008775", "title": "36050", "sortData": 36050, "inResultset": true }, "36440": { "color": "#505050", "title": "36440", "sortData": 36440, "inResultset": true }, "36443": { "color": "#333333", "title": "36443", "sortData": 36443, "inResultset": true }, "36497": { "color": "#ffaf45", "title": "36497", "sortData": 36497, "inResultset": true }, "36533": { "color": "#ff6752", "title": "36533", "sortData": 36533, "inResultset": true }, "36683": { "color": "#ff7461", "title": "36683", "sortData": 36683, "inResultset": true }, "36862": { "color": "#00ccb1", "title": "36862", "sortData": 36862, "inResultset": true }, "37154": { "color": "#ff5d47", "title": "37154", "sortData": 37154, "inResultset": true }, "37183": { "color": "#ffb14a", "title": "37183", "sortData": 37183, "inResultset": true }, "37238": { "color": "#ffa62e", "title": "37238", "sortData": 37238, "inResultset": true }, "37266": { "color": "#547A94", "title": "37266", "sortData": 37266, "inResultset": true }, "37315": { "color": "#494949", "title": "37315", "sortData": 37315, "inResultset": true }, "37444": { "color": "#83bfe7", "title": "37444", "sortData": 37444, "inResultset": true }, "37526": { "color": "#4d4d4d", "title": "37526", "sortData": 37526, "inResultset": true }, "37558": { "color": "#ff8372", "title": "37558", "sortData": 37558, "inResultset": true }, "37644": { "color": "#ff6f5b", "title": "37644", "sortData": 37644, "inResultset": true }, "37767": { "color": "#ffad3f", "title": "37767", "sortData": 37767, "inResultset": true }, "37768": { "color": "#74a9cd", "title": "37768", "sortData": 37768, "inResultset": true }, "37779": { "color": "#F48E06", "title": "37779", "sortData": 37779, "inResultset": true }, "37810": { "color": "#3b3b3b", "title": "37810", "sortData": 37810, "inResultset": true }, "37832": { "color": "#00a790", "title": "37832", "sortData": 37832, "inResultset": true }, "37920": { "color": "#ffaa38", "title": "37920", "sortData": 37920, "inResultset": true }, "37928": { "color": "#ff806f", "title": "37928", "sortData": 37928, "inResultset": true }, "37956": { "color": "#fc543d", "title": "37956", "sortData": 37956, "inResultset": true }, "37974": { "color": "#ffb34e", "title": "37974", "sortData": 37974, "inResultset": true }, "37980": { "color": "#DB4935", "title": "37980", "sortData": 37980, "inResultset": true }, "37981": { "color": "#009b87", "title": "37981", "sortData": 37981, "inResultset": true }, "37982": { "color": "#7fb8df", "title": "37982", "sortData": 37982, "inResultset": true }, "37983": { "color": "#3f3f3f", "title": "37983", "sortData": 37983, "inResultset": true }, "38005": { "color": "#79afd5", "title": "38005", "sortData": 38005, "inResultset": true }, "38006": { "color": "#00c2a8", "title": "38006", "sortData": 38006, "inResultset": true }, "38097": { "color": "#4b4b4b", "title": "38097", "sortData": 38097, "inResultset": true }, "38149": { "color": "#ff7966", "title": "38149", "sortData": 38149, "inResultset": true } }, "subtotal": false } }, { "jaql": { "table": "FINANCE DETAILS", "column": "Contribution ID", "dim": "[FINANCE DETAILS.Contribution ID]", "datatype": "numeric", "title": "Contribution ID" }, "field": { "id": "[FINANCE DETAILS.Contribution ID]", "index": 2 }, "format": { "subtotal": true }, "disabled": false }, { "jaql": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION.Date1 (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Contribution Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true }, "subtotal": false }, "field": { "id": "[CONTRIBUTION.Date1 (Calendar)]_days", "index": 3 }, "hierarchies": [ "calendar", "calendar - weeks" ] }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign", "dim": "[CAMPAIGN.Campaign]", "datatype": "text", "merged": true, "title": "Campaign" }, "field": { "id": "[CAMPAIGN.Campaign]", "index": 4 }, "disabled": false }, { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund" }, "field": { "id": "[FUND.Fund]", "index": 5 }, "disabled": false }, { "jaql": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Transaction Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "field": { "id": "[TRANSACTION DATE.Date (Calendar)]_days", "index": 6 }, "hierarchies": [ "calendar", "calendar - weeks" ] }, { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type" }, "field": { "id": "[FINANCE DETAILS.Transaction Type]", "index": 7 }, "disabled": false }, { "jaql": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method" }, "field": { "id": "[PAYMENT.Payment Method1]", "index": 8 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "FINANCE VALUES", "column": "Contribution Received Amount", "dim": "[FINANCE VALUES.Contribution Received Amount]", "datatype": "numeric", "agg": "sum", "title": "Payment" }, "format": { "color": { "type": "color", "color": "transparent" }, "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } } }, "field": { "id": "[FINANCE VALUES.Contribution Received Amount]_sum", "index": 9 } }, { "jaql": { "type": "measure", "formula": "IF ( \n ( \n ( COUNT ( [9BC09-2A9] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) ) = 1\n \t\tAND ( COUNT ( [7094A-036] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) , [A711D-286] ) = 1\n \t\tAND ( COUNT ( [03E99-E9C] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) , [A711D-286] ) = 1\n )\n OR COUNT ( [9BC09-2A9] ) > 1\n OR COUNT ( [7094A-036] ) > 1\n OR COUNT ( [03E99-E9C] ) > 1\n, ( sum([7BDB0-62D]) , ALL([9BC09-2A9]) , ALL([14963-DB1]) , ALL([03E99-E9C]) , ALL([7094A-036]) )\n, NULL )", "context": { "[7BDB0-62D]": { "table": "FINANCE VALUES", "column": "Contribution Amount", "dim": "[FINANCE VALUES.Contribution Amount]", "datatype": "numeric", "title": "Contribution Amount" }, "[03E99-E9C]": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type" }, "[A711D-286]": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:00" } }, "[7094A-036]": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method" }, "[14963-DB1]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "years", "title": "Years in Date" }, "[9BC09-2A9]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Pledged" }, "field": { "id": "IF ( \n ( \n ( COUNT ( [9BC09-2A9] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) ) = 1\n \t\tAND ( COUNT ( [7094A-036] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) , [A711D-286] ) = 1\n \t\tAND ( COUNT ( [03E99-E9C] ) , ALL([9BC09-2A9]) , ALL([03E99-E9C]) , [A711D-286] ) = 1\n )\n OR COUNT ( [9BC09-2A9] ) > 1\n OR COUNT ( [7094A-036] ) > 1\n OR COUNT ( [03E99-E9C] ) > 1\n, ( sum([7BDB0-62D]) , ALL([9BC09-2A9]) , ALL([14963-DB1]) , ALL([03E99-E9C]) , ALL([7094A-036]) )\n, NULL )", "index": 10 }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } } }, { "jaql": { "type": "measure", "formula": "IF ( \n ( \n ( COUNT ( [D173E-905] ) , ALL([D173E-905]) , ALL([746F9-DF5]) ) = 1\n \t\tAND ( COUNT ( [893C2-C5C] ) , ALL([D173E-905]) , ALL([746F9-DF5]) , [E0709-1C4] ) = 1\n \t\tAND ( COUNT ( [746F9-DF5] ) , ALL([D173E-905]) , ALL([746F9-DF5]) , [E0709-1C4] ) = 1\n )\n OR COUNT ( [D173E-905] ) > 1\n OR COUNT ( [893C2-C5C] ) > 1\n OR COUNT ( [746F9-DF5] ) > 1\n, ( sum([99353-BE1]) , ALL([D173E-905]) , ALL([94264-E73]) , ALL([746F9-DF5]) , ALL([893C2-C5C]) )\n, NULL )", "context": { "[99353-BE1]": { "table": "FINANCE VALUES", "column": "Contribution Balance Amount", "dim": "[FINANCE VALUES.Contribution Balance Amount]", "datatype": "numeric", "title": "Contribution Balance Amount" }, "[746F9-DF5]": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type" }, "[E0709-1C4]": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:00" } }, "[893C2-C5C]": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method" }, "[94264-E73]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "years", "title": "Years in Date" }, "[D173E-905]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Balance" }, "field": { "id": "IF ( \n ( \n ( COUNT ( [D173E-905] ) , ALL([D173E-905]) , ALL([746F9-DF5]) ) = 1\n \t\tAND ( COUNT ( [893C2-C5C] ) , ALL([D173E-905]) , ALL([746F9-DF5]) , [E0709-1C4] ) = 1\n \t\tAND ( COUNT ( [746F9-DF5] ) , ALL([D173E-905]) , ALL([746F9-DF5]) , [E0709-1C4] ) = 1\n )\n OR COUNT ( [D173E-905] ) > 1\n OR COUNT ( [893C2-C5C] ) > 1\n OR COUNT ( [746F9-DF5] ) > 1\n, ( sum([99353-BE1]) , ALL([D173E-905]) , ALL([94264-E73]) , ALL([746F9-DF5]) , ALL([893C2-C5C]) )\n, NULL )", "index": 11 }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "filter": { "equals": "35810" }, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:18" }, "collapsed": false }, "disabled": true }, { "jaql": { "table": "PAYMENT METHOD", "column": "Payment Method", "dim": "[PAYMENT.Payment Method1]", "datatype": "text", "merged": true, "title": "Payment Method", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": true, "datasource": { "title": "BRCH-Finance", "fullname": "CWALLINGFORD-VM/BRCH-Finance", "id": "aCWALLINGFORDLQAaVM_aBRCHLQAaFINANCE", "address": "CWALLINGFORD-VM", "database": "aBRCHLQAaFinance", "lastBuildTime": "2021-01-28T11:02:18" } }, "disabled": 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": "26", "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_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" }, { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "contribution_id", "title": "Contribution ID", "singular": "Contribution ID", "plural": "Contribution ID" }, { "id": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "campaign", "title": "Campaign", "singular": "Campaign", "plural": "Campaign" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" }, { "id": "transaction_type", "title": "Transaction Type", "singular": "Transaction Type", "plural": "Transaction Type" }, { "id": "payment_method", "title": "Payment Method", "singular": "Payment Method", "plural": "Payment Method" } ] } }, "instanceid": "1AA10-323D-06", "queryStartTime": "2021-01-28T14:10:49", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "6012e35d9b3eba12b07e0df2", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "canEditFilters": true, "currentPage": 2 } ], "hierarchies": [] }