{ "title": "consecutive-years-of-giving COPY (1)", "desc": "", "source": "6340732e3de04c2144795415", "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "2608A-8456-D8", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "649px", "defaultWidth": 512, "widgetid": "634f039fd598a523d0174b09", "autoHeight": "649px" } ], "width": 100, "stretchable": false, "pxlWidth": 790, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "672px", "defaultWidth": 512, "widgetid": "634f039fd598a523d0174b08", "autoHeight": "672px" } ], "width": 100, "stretchable": false, "pxlWidth": 790, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "634f039fd598a523d0174b0b", "height": "732px" } ], "width": 100, "stretchable": false, "pxlWidth": 790, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "634f039fd598a523d0174b0a", "height": "732px" } ], "width": 100, "stretchable": false, "pxlWidth": 790, "index": 0 } ] } ], "pxlWidth": 790, "index": 0 } ], "container": {} }, "original": null, "oid": "634f039fd598a523d0174b07", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "editing": false, "filters": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [], "all": true } }, "instanceid": "5CC58-563C-3D", "isCascading": false, "disabled": false }, { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "collapsed": false, "filter": { "fromNotEqual": 0 } }, "instanceid": "117E8-83C7-7D", "isCascading": false, "disabled": false }, { "jaql": { "table": "MEMBERSHIP", "column": "Membership Organization", "dim": "[MEMBERSHIP.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "AR Membership (AD)", "AR Donor/Member Levels" ] } }, "instanceid": "4B789-389F-A7", "isCascading": false, "disabled": true }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign Category", "dim": "[CAMPAIGN.Campaign Category]", "datatype": "text", "merged": true, "title": "Campaign Category", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Membership" ] } }, "instanceid": "8051B-FFD7-43", "isCascading": false, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public" ] } } }, "instanceid": "BCB57-F339-1D", "isCascading": false, "locked": true } ], "filterToDatasourceMapping": {}, "parentFolder": null, "isPublic": null, "defaultFilters": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2023" ] } }, "instanceid": "5CC58-563C-3D", "isCascading": false, "disabled": false }, { "jaql": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "title": "Amount", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "collapsed": false, "filter": { "fromNotEqual": 0 } }, "instanceid": "117E8-83C7-7D", "isCascading": false, "disabled": false }, { "jaql": { "table": "MEMBERSHIP", "column": "Membership Organization", "dim": "[MEMBERSHIP.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "AR Membership (AD)", "AR Donor/Member Levels" ] } }, "instanceid": "4B789-389F-A7", "isCascading": false, "disabled": true }, { "jaql": { "table": "CAMPAIGN", "column": "Campaign Category", "dim": "[CAMPAIGN.Campaign Category]", "datatype": "text", "merged": true, "title": "Campaign Category", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Membership" ] } }, "instanceid": "8051B-FFD7-43", "isCascading": false, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public" ] } } }, "instanceid": "BCB57-F339-1D", "isCascading": false, "locked": true } ], "migrated": true, "lastPublish": "2023-09-27T06:37:17.332Z", "subscription": { "active": false, "context": { "dashboardId": "634f039fd598a523d0174b07" }, "emailSettings": { "isEmail": true, "isPdf": false }, "executionPerDay": 1, "isDataChange": true, "reportType": { "inline": true }, "schedule": "* * * * * *", "type": "onUpdate", "subscribe": false }, "previewLayout": null, "allowChangeSubscription": false, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "", "type": "pivot", "subtype": "pivot", "oid": "634f039fd598a523d0174b08", "desc": null, "source": "6340732e3de04c214479541a", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "SUM(\n CASE WHEN ( [CA2DB-DF6] , [28DFC-B54] ) = 5 THEN 5\n WHEN ( [CA2DB-DF6] , [2EC33-09D] ) = 4 THEN 4 \n WHEN ( [CA2DB-DF6] , [61845-1BB] ) = 3 THEN 3 \n WHEN ( [CA2DB-DF6] , [FA224-AA5] ) = 2 THEN 2 \n WHEN ( [CA2DB-DF6] , [7B287-43E] ) = 1 THEN 1 \n ELSE NULL END\n )", "context": { "[CA2DB-DF6]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[FA224-AA5]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[61845-1BB]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[2EC33-09D]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[28DFC-B54]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[DCA3A-981]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[7B287-43E]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } } }, "title": "Consecutive Years", "sortDetails": { "field": 1, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "SUM(\n CASE WHEN ( [CA2DB-DF6] , [28DFC-B54] ) = 5 THEN 5\n WHEN ( [CA2DB-DF6] , [2EC33-09D] ) = 4 THEN 4 \n WHEN ( [CA2DB-DF6] , [61845-1BB] ) = 3 THEN 3 \n WHEN ( [CA2DB-DF6] , [FA224-AA5] ) = 2 THEN 2 \n WHEN ( [CA2DB-DF6] , [7B287-43E] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" } ] }, "rowsGrandTotal": true }, "instanceid": "58523-23E1-55", "queryStartTime": "2022-10-07T13:46:43", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "634f039fd598a523d0174b07", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "drillTarget": { "oid": "5ea8698042ba532104075f90", "caption": "_Constituents", "folder": "5f6377e2f96a8e0f302c116a" } }, "drilledDashboardDisplay": {}, "currentPage": 3, "script_old": null, "script": null }, { "title": "", "type": "pivot", "subtype": "pivot", "oid": "634f039fd598a523d0174b09", "desc": null, "source": "6340732e3de04c214479541b", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[5D872-5A4]", "context": { "[5D872-5A4]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "[Total Amount]", "sortDetails": { "field": 2, "dir": "desc", "sortingLastDimension": true, "measurePath": { "1": "2023" }, "initialized": true }, "sort": "desc" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "type": "condition", "conditions": [ { "color": "#F48E06", "operator": ">", "expression": "0" } ] } }, "field": { "id": "[5D872-5A4]", "index": 2 } }, { "jaql": { "type": "measure", "formula": "([FB5CC-B82],[ED8F8-844])", "context": { "[ED8F8-844]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[68EBF-4D3]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[FB5CC-B82]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "([Total Amount],[Campaign Fiscal Year1])" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 3 }, "disabled": true } ] }, { "name": "columns", "items": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year" }, "field": { "id": "[CAMPAIGN.Campaign Fiscal Year]", "index": 1 } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "from": "2013", "to": "2023" }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" } }, "title": "Campaign Fiscal Year" }, { "jaql": { "type": "measure", "formula": "([FB5CC-B82],[ED8F8-844])", "context": { "[ED8F8-844]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[68EBF-4D3]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[FB5CC-B82]": { "table": "CONTRIBUTION VALUES", "column": "Amount", "dim": "[CONTRIBUTION VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "([Total Amount],[Campaign Fiscal Year1])", "filter": { "fromNotEqual": 0 }, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } } ] } ] }, "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "campaign_fiscal_year", "title": "Campaign Fiscal Year", "singular": "Campaign Fiscal Year", "plural": "Campaign Fiscal Year" } ] } }, "instanceid": "47ACB-A7E0-79", "queryStartTime": "2023-08-30T11:33:59", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "634f039fd598a523d0174b07", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "canEditFilters": true, "viewState": { "activeTab": "filters" }, "script_old": null, "script": null }, { "title": "Consecutive Years' Constituents", "type": "chart/column", "subtype": "column/stackedcolumn", "oid": "634f039fd598a523d0174b0a", "desc": null, "source": "6340732e3de04c214479541c", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "SUM( [56C52-937] , \n IF ( ( [F7A14-58F] , [4A5C4-A1B] ) = 5 , 1 , NULL )\n )", "context": { "[F7A14-58F]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[4A5C4-A1B]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[3B503-EB5]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[56C52-937]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "5 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [B1AA3-E9F] , \n IF ( ( [0485E-474] , [2A8A8-349] ) = 4 , 1 , NULL )\n )", "context": { "[0485E-474]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[2A8A8-349]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[91DB3-A4F]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[B1AA3-E9F]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "4 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [BDEAF-420] , \n IF ( ( [F9202-C06] , [2EC1C-325] ) = 3 , 1 , NULL )\n )", "context": { "[F9202-C06]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[2EC1C-325]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[287F4-AC8]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[BDEAF-420]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "3 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#DB4935", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [64CED-A85] , \n IF ( ( [85AA0-9EC] , [7C663-A9E] ) = 2 , 1 , NULL )\n )", "context": { "[85AA0-9EC]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[7C663-A9E]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[9471B-D86]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[64CED-A85]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "2 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#333333", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [6D54D-7CD] , \n IF ( ( [F99AE-987] , [C337A-35C] ) = 1 , 1 , NULL )\n )", "context": { "[F99AE-987]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[C337A-35C]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[56872-A40]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[6D54D-7CD]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "1 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#008775", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "campaign_fiscal_year", "title": "Campaign Fiscal Year", "singular": "Campaign Fiscal Year", "plural": "Campaign Fiscal Year" } ] } }, "instanceid": "47140-F07F-A5", "queryStartTime": "2023-08-30T11:31:08", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 }, "dashboardid": "634f039fd598a523d0174b07", "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 20 }, "selectorLocked": false }, "drawing": true }, { "title": "Consecutive Years' Constituents", "type": "chart/bar", "subtype": "bar/classic", "oid": "634f039fd598a523d0174b0b", "desc": null, "source": "6340732e3de04c214479541d", "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "SUM( [56C52-937] , \n IF ( ( [F7A14-58F] , [4A5C4-A1B] ) = 5 , 1 , NULL )\n )", "context": { "[F7A14-58F]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[4A5C4-A1B]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2017", "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[3B503-EB5]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[56C52-937]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "5 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [B1AA3-E9F] , \n IF ( ( [0485E-474] , [2A8A8-349] ) = 4 , 1 , NULL )\n )", "context": { "[0485E-474]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[2A8A8-349]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2018", "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[91DB3-A4F]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[B1AA3-E9F]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "4 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#F48E06", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [BDEAF-420] , \n IF ( ( [F9202-C06] , [2EC1C-325] ) = 3 , 1 , NULL )\n )", "context": { "[F9202-C06]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[2EC1C-325]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2019", "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[287F4-AC8]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[BDEAF-420]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "3 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#DB4935", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [64CED-A85] , \n IF ( ( [85AA0-9EC] , [7C663-A9E] ) = 2 , 1 , NULL )\n )", "context": { "[85AA0-9EC]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[7C663-A9E]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2020", "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[9471B-D86]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[64CED-A85]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "2 Years" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#333333", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } }, { "jaql": { "type": "measure", "formula": "SUM( [6D54D-7CD] , \n IF ( ( [F99AE-987] , [C337A-35C] ) = 1 , 1 , NULL )\n )", "context": { "[F99AE-987]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "agg": "count", "title": "# of unique Campaign Fiscal Year" }, "[C337A-35C]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[56872-A40]": { "table": "CAMPAIGN", "column": "Campaign Fiscal Year", "dim": "[CAMPAIGN.Campaign Fiscal Year]", "datatype": "numeric", "title": "Campaign Fiscal Year", "filter": { "explicit": true, "multiSelection": true, "members": [ "2016", "2017", "2018", "2019", "2020" ] }, "collapsed": false, "datasource": { "title": "KCCO-Contributions", "fullname": "USEA2SAPCUBE210.aws.tnhs.cloud/KCCO-Contributions", "id": "aUSEA2SAPCUBE210LgAaAWSLgAaTNHSLgAaCLOUD_aKCCOLQAaCONTRIBUTIONS", "address": "USEA2SAPCUBE210.aws.tnhs.cloud", "database": "aKCCOLQAaContributions", "lastBuildTime": "2021-01-22T08:20:28" } }, "[6D54D-7CD]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" } }, "title": "1 Year" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#008775", "type": "color" } }, "field": { "id": "SUM(\n CASE WHEN ( [D5CDB-939] , [660B0-F88] ) = 5 THEN 5\n WHEN ( [D5CDB-939] , [C0DC4-74A] ) = 4 THEN 4 \n WHEN ( [D5CDB-939] , [B2C24-ED3] ) = 3 THEN 3 \n WHEN ( [D5CDB-939] , [C1077-FBD] ) = 2 THEN 2 \n WHEN ( [D5CDB-939] , [B34CA-0A7] ) = 1 THEN 1 \n ELSE NULL END\n )", "index": 1 } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [] } }, "instanceid": "A5196-ED70-8F", "queryStartTime": "2023-08-30T11:31:08", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 }, "dashboardid": "634f039fd598a523d0174b07", "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 4 }, "drillTarget": { "oid": "61b82490808411194c3ef228", "caption": "_Constituents", "folder": "633d3cce1325ab30b8302f04" } }, "drawing": true, "drilledDashboardDisplay": {} } ], "hierarchies": [] }