{ "title": "At-a-Glance Contributions", "oid": "5c75ab13d132d21e30d79292", "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": "25D2C-8DC8-7F", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 1028, "height": 384, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5c75b22ad132d21e30d793a0" } ], "width": 31.733594515181196, "stretchable": false, "pxlWidth": 648, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5c76a557bf3bc54908fd7bde", "height": 384 } ], "width": 68.26640548481882, "stretchable": false, "pxlWidth": 1394, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5c76aaa0bf3bc54908fd7c8d", "height": "744px" } ], "width": 31.733594515181196, "stretchable": false, "pxlWidth": 648, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "744px", "defaultWidth": 512, "widgetid": "5c75ab5dd132d21e30d792ad" } ], "width": 68.2664054848188, "stretchable": false, "pxlWidth": 1394, "index": 1 } ] } ], "pxlWidth": 2042, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" }, "editing": true, "filters": [], "filterToDatasourceMapping": {}, "widgets": [ { "title": "By Campaign FY and Contribution Date", "subtype": "pivot", "oid": "5c75ab5dd132d21e30d792ad", "desc": null, "source": null, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONTRIBUTION DATE", "column": "Fiscal Week Of Year", "dim": "[CONTRIBUTION DATE.Fiscal Week Of Year]", "datatype": "numeric", "title": "Fiscal Week Of Year" }, "field": { "id": "[CONTRIBUTION DATE.Fiscal Week Of Year]", "index": 0 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "RSUM(([E6D4C-4FC] , [E9A37-572] , [B93EF-D3F]))", "context": { "[E9A37-572]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[48FFD-01B]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[B93EF-D3F]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[E6D4C-4FC]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Current FY" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([E6D4C-4FC] , [E9A37-572] , [B93EF-D3F]))", "index": 1 } }, { "jaql": { "type": "measure", "formula": "RSUM(([974B4-97B] , [50983-D64] , [F9412-346]))", "context": { "[50983-D64]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[F9412-346]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[52B25-01B]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 365, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[974B4-97B]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-1" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([974B4-97B] , [50983-D64] , [F9412-346]))", "index": 2 } }, { "jaql": { "type": "measure", "formula": "RSUM(([7566C-2B8] , [81255-2E5] , [EC041-059]))", "context": { "[81255-2E5]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[EC041-059]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 731 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[849B2-52E]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 731 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[7566C-2B8]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-2" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([7566C-2B8] , [81255-2E5] , [EC041-059]))", "index": 3 } }, { "jaql": { "type": "measure", "formula": "RSUM(([9A865-68D] , [C2BEA-4A4] , [49600-5F3]))", "context": { "[C2BEA-4A4]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[49600-5F3]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 1096 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[E4208-4DA]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1096 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[9A865-68D]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-3" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([9A865-68D] , [C2BEA-4A4] , [49600-5F3]))", "index": 4 } }, { "jaql": { "type": "measure", "formula": "RSUM(([B5358-AF3] , [4CE97-228] , [4E6C9-D36]))", "context": { "[4CE97-228]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2015" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[4E6C9-D36]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 1461 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[23E1B-65A]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1461 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[B5358-AF3]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-4" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([B5358-AF3] , [4CE97-228] , [4E6C9-D36]))", "index": 5 } }, { "jaql": { "type": "measure", "formula": "RSUM(([A4354-51C] , [9D091-600] , [C1370-872]))", "context": { "[9D091-600]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2014" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[C1370-872]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 1827 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[E0FDA-0A0]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1827 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[A4354-51C]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-5" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([A4354-51C] , [9D091-600] , [C1370-872]))", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "fiscal_week_of_year", "title": "Fiscal Week Of Year", "singular": "Fiscal Week Of Year", "plural": "Fiscal Week Of Year" } ] }, "rowsGrandTotal": true }, "instanceid": "FD1D2-0B4D-AE", "queryStartTime": "2019-02-27T10:46:06", "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": "design" }, "realTimeRefreshing": false, "dashboardid": "5c75ab13d132d21e30d79292", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true } }, { "title": "At-a-Glance Contributions Fiscal Year to Date by FY Offset and Contribution Date", "subtype": "indicator/numeric", "oid": "5c75b22ad132d21e30d793a0", "desc": null, "source": null, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "([25CCE-C83] , [D2303-F9C] , [8CB64-EF6]) - ([25CCE-C83] , [F5D95-6F6] , [1632D-9F9])", "context": { "[F5D95-6F6]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[D2303-F9C]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[8CB64-EF6]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[1632D-9F9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[25CCE-C83]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "LFYTD Variance" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "condition", "conditions": [ { "color": "#f48e06", "operator": "<", "expression": "0", "expressionValue": "0" }, { "color": "#008775", "operator": "≥", "expression": "0", "expressionValue": "0" } ] } } } ] }, { "name": "secondary", "items": [ { "jaql": { "type": "measure", "formula": "([24191-5A4] , [A51B8-15B] , [64884-5DF])", "context": { "[A51B8-15B]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[64884-5DF]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[24191-5A4]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Current FY Total Amount" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": 0, "number": { "separated": true } } } } ] }, { "name": "min", "items": [] }, { "name": "max", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "indicator", "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": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [] }, "indicator/numeric": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } }, "indicator/gauge": { "subtype": "round", "skin": "1", "components": { "ticks": { "inactive": false, "enabled": true }, "labels": { "inactive": false, "enabled": true }, "title": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } } }, "instanceid": "DA6C6-743C-CD", "queryStartTime": "2019-02-27T09:59:27", "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 }, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "realTimeRefreshing": false, "dashboardid": "5c75ab13d132d21e30d79292", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false } }, { "title": "By FY Offset and Contribution Date", "subtype": "pivot", "oid": "5c76a557bf3bc54908fd7bde", "desc": null, "source": null, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONTRIBUTION DATE", "column": "Fiscal Week Of Year", "dim": "[CONTRIBUTION DATE.Fiscal Week Of Year]", "datatype": "numeric", "title": "Fiscal Week Of Year" }, "field": { "id": "[CONTRIBUTION DATE.Fiscal Week Of Year]", "index": 0 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "RSUM(([D2F20-DF3] , [40601-AE3] , [9AB0F-58A]))", "context": { "[40601-AE3]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[9AB0F-58A]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[BE297-FA9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "[D2F20-DF3]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Current FY" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([D2F20-DF3] , [40601-AE3] , [9AB0F-58A]))", "index": 1 } }, { "jaql": { "type": "measure", "formula": "RSUM(([9F2B2-DE3] , [0BFE0-346] , [6A178-B4B]))", "context": { "[0BFE0-346]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[6A178-B4B]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 365, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[9F2B2-DE3]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-1" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([9F2B2-DE3] , [0BFE0-346] , [6A178-B4B]))", "index": 2 } }, { "jaql": { "type": "measure", "formula": "RSUM(([FDEDE-055] , [918C9-AE4] , [E3659-768]))", "context": { "[918C9-AE4]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[E3659-768]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 731 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[FDEDE-055]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-2" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([FDEDE-055] , [918C9-AE4] , [E3659-768]))", "index": 3 } }, { "jaql": { "type": "measure", "formula": "RSUM(([68F79-57B] , [4D381-2A4] , [29838-8D3]))", "context": { "[4D381-2A4]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-3" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[29838-8D3]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1096 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[68F79-57B]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-3" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([68F79-57B] , [4D381-2A4] , [29838-8D3]))", "index": 4 } }, { "jaql": { "type": "measure", "formula": "RSUM(([C2640-582] , [5E774-559] , [8956A-062]))", "context": { "[5E774-559]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-4" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[8956A-062]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1461 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[C2640-582]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-4" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([C2640-582] , [5E774-559] , [8956A-062]))", "index": 5 } }, { "jaql": { "type": "measure", "formula": "RSUM(([D7F80-3FB] , [953A6-931] , [A58EC-DF4]))", "context": { "[953A6-931]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "-5" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[A58EC-DF4]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 1827 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:56" } }, "[D7F80-3FB]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "-5" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RSUM(([D7F80-3FB] , [953A6-931] , [A58EC-DF4]))", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "fiscal_week_of_year", "title": "Fiscal Week Of Year", "singular": "Fiscal Week Of Year", "plural": "Fiscal Week Of Year" } ] }, "rowsGrandTotal": true }, "instanceid": "FD1D2-0B4D-AE", "queryStartTime": "2019-02-27T10:26:28", "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": "design" }, "realTimeRefreshing": false, "dashboardid": "5c75ab13d132d21e30d79292", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "drawing": true }, { "title": "At-a-Glance Contributions Fiscal Year to Date by Campaign FY and Contribution Date", "subtype": "indicator/numeric", "oid": "5c76aaa0bf3bc54908fd7c8d", "desc": null, "source": null, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "([8F71D-5C0] , [82A1C-722] , [74359-965]) - ([8F71D-5C0] , [BC0BB-A6B] , [DD982-352])", "context": { "[BC0BB-A6B]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[82A1C-722]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[7DCC2-A11]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[DD982-352]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 366 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[74359-965]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[8F71D-5C0]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "LFYTD Variance" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "condition", "conditions": [ { "color": "#f48e06", "operator": "<", "expression": "0", "expressionValue": "0" }, { "color": "#008775", "operator": "≥", "expression": "0", "expressionValue": "0" } ] } } } ] }, { "name": "secondary", "items": [ { "jaql": { "type": "measure", "formula": "([F795D-1A2] , [C441F-8A6] , [58D6C-7A0]) ", "context": { "[DE851-830]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[C441F-8A6]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019" ] }, "collapsed": false, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[58D6C-7A0]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 720, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions" } }, "[165CA-DBD]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 366, "offset": 0 }, "custom": true }, "datasource": { "title": "Contributions", "fullname": "CWALLINGFORD-TN/Contributions", "id": "aCWALLINGFORDLQAaTN_aCONTRIBUTIONS", "address": "CWALLINGFORD-TN", "database": "aContributions", "lastBuildTime": "2019-02-20T13:31:00" } }, "[F795D-1A2]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Current FY Total Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } } } } ] }, { "name": "min", "items": [] }, { "name": "max", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "indicator", "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": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [] }, "indicator/numeric": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } }, "indicator/gauge": { "subtype": "round", "skin": "1", "components": { "ticks": { "inactive": false, "enabled": true }, "labels": { "inactive": false, "enabled": true }, "title": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } } }, "instanceid": "DA6C6-743C-CD", "queryStartTime": "2019-02-27T10:23:23", "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 }, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "realTimeRefreshing": false, "dashboardid": "5c75ab13d132d21e30d79292", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "drawing": true } ], "hierarchies": [] }