{ "title": "#LYBNT? 1.11.22", "oid": "61dda38d705418458c10caac", "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": "CC11A-D92C-F0", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61ddb2ad705418458c10cd03", "height": 384 } ], "width": 100, "stretchable": false, "pxlWidth": 1180, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61ddc540705418458c10cfc7", "height": 384 } ], "width": 100, "stretchable": false, "pxlWidth": 719, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61ddc5d8705418458c10d007", "height": 384 } ], "width": 100, "stretchable": false, "pxlWidth": 1180, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "61ddabfd705418458c10cc1b" } ], "width": 100, "stretchable": false, "pxlWidth": 1180, "index": 0 } ] } ], "pxlWidth": 1180, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" }, "editing": true, "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": 300, "tzName": "America/New_York", "context": { "dashboardid": "61dda38d705418458c10caac" }, "active": false, "executionPerDay": 1, "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false } }, "isPublic": null, "parentFolder": "607da087b022da03a4369bdd", "widgets": [ { "title": "LYBNT 2021 (wallingford)", "subtype": "pivot", "oid": "61ddabfd705418458c10cc1b", "desc": null, "source": null, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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 }, "disabled": false }, { "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": 1 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [09497-C7B] , [17C08-B3F] , [F0529-986] ) > 0 \n \n \n AND ISNULL ( ( [09497-C7B] , [A4BA7-F87] , [F0529-986] ) ) \n \n \n , ( [09497-C7B] , [17C08-B3F] , [F0529-986] ) \n \n \n , NULL\n \n )", "context": { "[F0529-986]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[09497-C7B]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[A4BA7-F87]": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "2021", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[17C08-B3F]": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "2020", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "title": "2021 Lybnt", "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true } }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF ( \n \n ( [09497-C7B] , [17C08-B3F] , [F0529-986] ) > 0 \n \n \n AND ISNULL ( ( [09497-C7B] , [A4BA7-F87] , [F0529-986] ) ) \n \n \n , ( [09497-C7B] , [17C08-B3F] , [F0529-986] ) \n \n \n , NULL\n \n )", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "collapsed": true }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([E818B-B20] , [EF946-758] ) > 0) \n \n AND \n \n ( ([E818B-B20] , [42A07-050] ) = 0) , \n \n \n ([E818B-B20] , [EF946-758] ) , NULL\t\n \n \n )", "context": { "[E818B-B20]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[42A07-050]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[EF946-758]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "Last year > 0, this year = 0 -> this year", "filter": { "fromNotEqual": "0" }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } }, "disabled": true }, { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [B5EF5-622] , [A763E-303] , [20231-A20] ) > 0 \n \n \n AND ISNULL ( ( [B5EF5-622] , [02E05-10F] , [20231-A20] ) ) \n \n \n , ( [B5EF5-622] , [A763E-303] , [20231-A20] ) \n \n \n , NULL\n \n )", "context": { "[20231-A20]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[2031A-F74]": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[B5EF5-622]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[A763E-303]": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "2020", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[02E05-10F]": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "2021", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "title": "2021 Lybnt", "filter": { "fromNotEqual": "0" }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" }, { "id": "fund", "title": "Fund", "singular": "Fund", "plural": "Fund" } ] } }, "instanceid": "65A91-240C-70", "queryStartTime": "2022-01-12T10:08:35", "currentPage": 1583, "widgetTimingLoged": false, "drawing": true, "canEditFilters": true, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "drilledDashboardDisplay": {}, "realTimeRefreshing": false, "dashboardid": "61dda38d705418458c10caac", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5ea8698042ba532104075f90", "caption": "_Constituents", "folder": "607d881eb022da03a4364439" } } }, { "title": "LYBNT Last Year v2", "subtype": "pivot", "oid": "61ddb2ad705418458c10cd03", "desc": null, "source": null, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONTRIBUTION DATE", "column": "Calendar Year", "dim": "[CONTRIBUTION.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "field": { "index": 0 }, "format": { "subtotal": true }, "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": 0 }, "disabled": false }, { "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": 1 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": " IF (\n \n ([8C4C7-289] = 0), [10337-7C4] , NULL\t\n \n \n )", "context": { "[10337-7C4]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[8C4C7-289]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( [AA4B1-D3C] = 0) AND ( [AF434-E26] > 0) , [AF434-E26] , NULL\t\n \n \n )", "context": { "[AF434-E26]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[AA4B1-D3C]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0 AND 2020 > 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([18C95-C9E] , [CFB92-FE0] , [6094B-96A] ) > 0) \n \n AND \n \n ( ([18C95-C9E] , [CFB92-FE0] , [47D55-3E8] ) = 0) , \n \n \n ([18C95-C9E], [CFB92-FE0] , [6094B-96A] ) , NULL\t\n \n \n )", "context": { "[CFB92-FE0]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[18C95-C9E]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[47D55-3E8]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[6094B-96A]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 346 }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([E818B-B20] , [EF946-758] ) > 0) \n \n AND \n \n ( ([E818B-B20] , [42A07-050] ) = 0) , \n \n \n ([E818B-B20] , [EF946-758] ) , NULL\t\n \n \n )", "context": { "[E818B-B20]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[42A07-050]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[EF946-758]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "Last year > 0, this year = 0 -> this year" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([5B991-2FE] , [C9FC0-1B7] , [4696F-36E] ) > 0) \n \n AND \n \n ( ([5B991-2FE] , [C9FC0-1B7] , [CD4EE-6EA] ) = 0) \n \n , \n \n ([5B991-2FE], [C9FC0-1B7] , [4696F-36E] ) , NULL\t\n \n \n )", "context": { "[C9FC0-1B7]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[5B991-2FE]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[CD4EE-6EA]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[4696F-36E]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem (1)" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 346, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [D5F82-7C6] , [86417-2F6] , [BE710-878] ) > 0 \n \n \n AND ISNULL ( ( [D5F82-7C6] , [7120A-3E7] , [BE710-878] ) ) \n \n \n , ( [D5F82-7C6] , [A88F6-104] , [BE710-878] ) \n \n \n , NULL\n \n )\n ", "context": { "[BE710-878]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[D5F82-7C6]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[A88F6-104]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "offset =1", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[86417-2F6]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset -1", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[7120A-3E7]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "offset 0", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "sort": "asc", "sortDetails": { "field": 2, "dir": "asc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "LYBNT nonMEM Wallignford 1.11.22" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 262, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF ( \n \n ( [D5F82-7C6] , [86417-2F6] , [BE710-878] ) > 0 \n \n \n AND ISNULL ( ( [D5F82-7C6] , [7120A-3E7] , [BE710-878] ) ) \n \n \n , ( [D5F82-7C6] , [A88F6-104] , [BE710-878] ) \n \n \n , NULL\n \n )\n ", "index": 2 }, "disabled": false } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [FB714-FCB] , [CAF78-90F] , [3FE6A-3EA] ) > 0 \n \n AND ISNULL ( ( [FB714-FCB] , [B54AD-3FD] , [3FE6A-3EA] ) ) \n \n , ( [FB714-FCB] , [CAF78-90F] , [3FE6A-3EA] ) \n \n , NULL\n \n )\n ", "context": { "[B54AD-3FD]": { "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": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[CAF78-90F]": { "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": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[3FE6A-3EA]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[FB714-FCB]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "LYBNT nonMEM Wallignford 1.11.22", "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "filter": { "fromNotEqual": "0" }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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": "calendar_year", "title": "Calendar Year", "singular": "Calendar Year", "plural": "Calendar Year" }, { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" } ] }, "rowsGrandTotal": true }, "instanceid": "65A91-240C-70", "queryStartTime": "2022-01-14T12:24:04", "currentPage": 1583, "widgetTimingLoged": false, "canEditFilters": true, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "drilledDashboardDisplay": {}, "realTimeRefreshing": false, "dashboardid": "61dda38d705418458c10caac", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5ea8698042ba532104075f90", "caption": "_Constituents", "folder": "607d881eb022da03a4364439" } }, "drawing": true }, { "title": "SYBNT 2021 (-2 to -5)", "subtype": "pivot", "oid": "61ddc540705418458c10cfc7", "desc": null, "source": null, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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 }, "disabled": false }, { "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": 1 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": " IF (\n \n ([8C4C7-289] = 0), [10337-7C4] , NULL\t\n \n \n )", "context": { "[10337-7C4]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[8C4C7-289]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( [AA4B1-D3C] = 0) AND ( [AF434-E26] > 0) , [AF434-E26] , NULL\t\n \n \n )", "context": { "[AF434-E26]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[AA4B1-D3C]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0 AND 2020 > 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([18C95-C9E] , [CFB92-FE0] , [6094B-96A] ) > 0) \n \n AND \n \n ( ([18C95-C9E] , [CFB92-FE0] , [47D55-3E8] ) = 0) , \n \n \n ([18C95-C9E], [CFB92-FE0] , [6094B-96A] ) , NULL\t\n \n \n )", "context": { "[CFB92-FE0]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[18C95-C9E]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[47D55-3E8]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[6094B-96A]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 346 }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([E818B-B20] , [EF946-758] ) > 0) \n \n AND \n \n ( ([E818B-B20] , [42A07-050] ) = 0) , \n \n \n ([E818B-B20] , [EF946-758] ) , NULL\t\n \n \n )", "context": { "[E818B-B20]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[42A07-050]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[EF946-758]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "Last year > 0, this year = 0 -> this year" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([5B991-2FE] , [C9FC0-1B7] , [4696F-36E] ) > 0) \n \n AND \n \n ( ([5B991-2FE] , [C9FC0-1B7] , [CD4EE-6EA] ) = 0) \n \n , \n \n ([5B991-2FE], [C9FC0-1B7] , [4696F-36E] ) , NULL\t\n \n \n )", "context": { "[C9FC0-1B7]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[5B991-2FE]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[CD4EE-6EA]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[4696F-36E]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem (1)" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 346, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) > 0 \n \n \n AND ISNULL ( ( [21E5B-9D5] , [17154-4B6] , [E005A-B09] ) ) \n \n \n , ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) \n \n \n , NULL\n \n )\n ", "context": { "[2C5A3-712]": { "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": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[E005A-B09]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[AF81E-990]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset -2 to -5", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2", "-3", "-4", "-5" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[21E5B-9D5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[17154-4B6]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset 0", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "SYBNT nonMEM Wallignford 1.11.22" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 262, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF ( \n \n ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) > 0 \n \n \n AND ISNULL ( ( [21E5B-9D5] , [17154-4B6] , [E005A-B09] ) ) \n \n \n , ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) \n \n \n , NULL\n \n )\n ", "index": 2 }, "disabled": false } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) > 0 \n \n \n AND ISNULL ( ( [21E5B-9D5] , [17154-4B6] , [E005A-B09] ) ) \n \n \n , ( [21E5B-9D5] , [AF81E-990] , [E005A-B09] ) \n \n \n , NULL\n \n )\n ", "context": { "[2C5A3-712]": { "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": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } }, "[E005A-B09]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[AF81E-990]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset -2 to -5", "filter": { "explicit": true, "multiSelection": true, "members": [ "-2", "-3", "-4", "-5" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[21E5B-9D5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[17154-4B6]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset 0", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "title": "SYBNT nonMEM Wallignford 1.11.22", "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "filter": { "fromNotEqual": "0" }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" } ] } }, "instanceid": "65A91-240C-70", "queryStartTime": "2022-01-12T10:00:14", "widgetTimingLoged": false, "canEditFilters": true, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "drilledDashboardDisplay": {}, "realTimeRefreshing": false, "dashboardid": "61dda38d705418458c10caac", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5ea8698042ba532104075f90", "caption": "_Constituents", "folder": "607d881eb022da03a4364439" } }, "drawing": true }, { "title": "Never-BNT 2021 (-6 and below)", "subtype": "pivot", "oid": "61ddc5d8705418458c10d007", "desc": null, "source": null, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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 }, "disabled": false }, { "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": 1 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": " IF (\n \n ([8C4C7-289] = 0), [10337-7C4] , NULL\t\n \n \n )", "context": { "[10337-7C4]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[8C4C7-289]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( [AA4B1-D3C] = 0) AND ( [AF434-E26] > 0) , [AF434-E26] , NULL\t\n \n \n )", "context": { "[AF434-E26]": { "type": "measure", "formula": "( sum([A84AE-1B9]) , [369B9-8ED] )", "context": { "[369B9-8ED]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[A84AE-1B9]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2020 Contributions" }, "[AA4B1-D3C]": { "type": "measure", "formula": "( sum([9C618-6F5]) , [1747A-DE9] )", "context": { "[1747A-DE9]": { "table": "CONTRIBUTION DATE", "column": "Date", "dim": "[CONTRIBUTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Years in Date", "level": "years", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions" } }, "[9C618-6F5]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount" } }, "title": "2021 Contributions" } }, "title": "If 2021 = 0 AND 2020 > 0, 2020, NULL" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([18C95-C9E] , [CFB92-FE0] , [6094B-96A] ) > 0) \n \n AND \n \n ( ([18C95-C9E] , [CFB92-FE0] , [47D55-3E8] ) = 0) , \n \n \n ([18C95-C9E], [CFB92-FE0] , [6094B-96A] ) , NULL\t\n \n \n )", "context": { "[CFB92-FE0]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[18C95-C9E]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[47D55-3E8]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[6094B-96A]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 346 }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([E818B-B20] , [EF946-758] ) > 0) \n \n AND \n \n ( ([E818B-B20] , [42A07-050] ) = 0) , \n \n \n ([E818B-B20] , [EF946-758] ) , NULL\t\n \n \n )", "context": { "[E818B-B20]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[42A07-050]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[EF946-758]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "Last year > 0, this year = 0 -> this year" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": " IF (\n \n ( ([5B991-2FE] , [C9FC0-1B7] , [4696F-36E] ) > 0) \n \n AND \n \n ( ([5B991-2FE] , [C9FC0-1B7] , [CD4EE-6EA] ) = 0) \n \n , \n \n ([5B991-2FE], [C9FC0-1B7] , [4696F-36E] ) , NULL\t\n \n \n )", "context": { "[C9FC0-1B7]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT member", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[5B991-2FE]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[CD4EE-6EA]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "This year", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[4696F-36E]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Last year", "filter": { "explicit": true, "multiSelection": true, "members": [ "-1" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } } }, "title": "Last Year non mem > 0, last year non mem = 0 -> Last year non mem (1)" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 346, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) > 0 \n \n \n AND ISNULL ( ( [F3410-5B8] , [6AEA2-82E] , [54811-3FD] ) ) \n \n \n , ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) \n \n \n , NULL\n \n )\n ", "context": { "[54811-3FD]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[AAB32-EC4]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset <= -6", "filter": { "to": "-6" }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[F3410-5B8]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[6AEA2-82E]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset 0", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "title": "nondonors nonMEM Wallignford 1.11.22" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "width": 262, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF ( \n \n ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) > 0 \n \n \n AND ISNULL ( ( [F3410-5B8] , [6AEA2-82E] , [54811-3FD] ) ) \n \n \n , ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) \n \n \n , NULL\n \n )\n ", "index": 2 }, "disabled": false } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "IF ( \n \n ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) > 0 \n \n \n AND ISNULL ( ( [F3410-5B8] , [6AEA2-82E] , [54811-3FD] ) ) \n \n \n , ( [F3410-5B8] , [AAB32-EC4] , [54811-3FD] ) \n \n \n , NULL\n \n )\n ", "context": { "[54811-3FD]": { "table": "FUND", "column": "Fund", "dim": "[FUND.Fund]", "datatype": "text", "merged": true, "title": "Fund NOT mem | 1.11.22", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Membership", "Not Used Member Bird Pass" ] } }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[AAB32-EC4]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset <= -6", "filter": { "to": "-6" }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:00" } }, "[F3410-5B8]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" }, "[6AEA2-82E]": { "table": "CONTRIBUTION DATE", "column": "Fiscal Current Year Offset", "dim": "[CONTRIBUTION DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Offset 0", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" } } }, "title": "nondonors nonMEM Wallignford 1.11.22", "sort": "desc", "sortDetails": { "field": 2, "dir": "desc", "measurePath": null, "sortingLastDimension": true, "initialized": true }, "filter": { "fromNotEqual": "0" }, "datasource": { "title": "MYST-Contributions", "fullname": "USEA1RAPCUBE018.aws.tnhs.cloud/MYST-Contributions", "id": "aUSEA1RAPCUBE018LgAaAWSLgAaTNHSLgAaCLOUD_aMYSTLQAaCONTRIBUTIONS", "address": "USEA1RAPCUBE018.aws.tnhs.cloud", "database": "aMYSTLQAaContributions", "lastBuildTime": "2022-01-10T23:29:45" }, "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" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" } ] } }, "instanceid": "65A91-240C-70", "queryStartTime": "2022-01-11T14:08:34", "widgetTimingLoged": false, "canEditFilters": true, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "drilledDashboardDisplay": {}, "realTimeRefreshing": false, "dashboardid": "61dda38d705418458c10caac", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5ea8698042ba532104075f90", "caption": "_Constituents", "folder": "607d881eb022da03a4364439" } }, "drawing": true, "currentPage": 0 } ], "hierarchies": [] }