{ "title": "Membership Migration", "oid": "5d10da0f7d63a136dc769b26", "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": "0191E-257C-2A", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": "508px", "defaultWidth": 512, "widgetid": "5d10da157d63a136dc769b36" } ], "width": 23.857623857623857, "stretchable": false, "pxlWidth": 496, "index": 0 }, { "elements": [ { "minHeight": 102, "maxHeight": 1024, "minWidth": 128, "maxWidth": 2048, "height": "508px", "defaultWidth": 512, "widgetid": "5d10da197d63a136dc769b3c" } ], "width": 25.97402597402597, "stretchable": false, "pxlWidth": 540, "index": 1 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d10db307d63a136dc769bad", "height": "508px" } ], "width": 50.16835016835019, "stretchable": false, "pxlWidth": 1539, "index": 2 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "656px", "defaultWidth": 512, "widgetid": "5d10da597d63a136dc769b69" } ], "width": 49.831649831649834, "stretchable": false, "pxlWidth": 1036, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d10dc5e7d63a136dc769bce", "height": "656px" } ], "width": 50.168350168350166, "stretchable": false, "pxlWidth": 1043, "index": 1 } ] } ], "pxlWidth": 2079, "index": 0 } ], "container": {} }, "original": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "editing": true, "filters": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "collapsed": true, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships", "lastBuildTime": "2019-06-24T02:23:17" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "AR Donor/Member Levels" ] } }, "instanceid": "60AFD-A5D4-21", "isCascading": false, "disabled": false } ], "filterToDatasourceMapping": {}, "widgets": [ { "title": "Membership Level Renewal Counts", "subtype": "sunburst", "oid": "5d10da157d63a136dc769b36", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level", "dim": "[MEMBERSHIP LEVEL.Membership Level]", "datatype": "text", "merged": true, "title": "Membership Level" }, "format": { "members": { "Alliance": { "color": "#4c687c", "title": "Alliance", "sortData": "Alliance", "cachedColor": "#4c687c", "total": 66, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Associate": { "color": "#5d7a8f", "title": "Associate", "sortData": "Associate", "cachedColor": "#5d7a8f", "total": 40, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Family One Year": { "color": "#547185", "title": "Family One Year", "sortData": "Family One Year", "cachedColor": "#547185", "total": 56, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Family Two Year": { "color": "#87a9c0", "title": "Family Two Year", "sortData": "Family Two Year", "cachedColor": "#87a9c0", "total": 6, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Gold Member": { "color": "#6e8da3", "title": "Gold Member", "sortData": "Gold Member", "cachedColor": "#6e8da3", "total": 13, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Individual One Year": { "color": "#3b5568", "title": "Individual One Year", "sortData": "Individual One Year", "cachedColor": "#3b5568", "total": 157, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Individual Two Year": { "color": "#7696ac", "title": "Individual Two Year", "sortData": "Individual Two Year", "cachedColor": "#7696ac", "total": 10, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Platinum Member": { "color": "#7fa0b6", "title": "Platinum Member", "sortData": "Platinum Member", "cachedColor": "#7fa0b6", "total": 6, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Silver Member": { "color": "#658499", "title": "Silver Member", "sortData": "Silver Member", "cachedColor": "#658499", "total": 23, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Angel": { "color": "#617f94", "title": "Angel", "sortData": "Angel", "cachedColor": "#617f94", "total": 28, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Donor": { "color": "#3b5568", "title": "Donor", "sortData": "Donor", "cachedColor": "#3b5568", "total": 93, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Bronze": { "color": "#6b8a9f", "title": "Patron's Circle Bronze", "sortData": "Patron's Circle Bronze", "cachedColor": "#6b8a9f", "total": 17, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Gold": { "color": "#587589", "title": "Patron's Circle Gold", "sortData": "Patron's Circle Gold", "cachedColor": "#587589", "total": 44, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Platinum": { "color": "#7494aa", "title": "Patron's Circle Platinum", "sortData": "Patron's Circle Platinum", "cachedColor": "#7494aa", "total": 15, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Supporter": { "color": "#4e6a7e", "title": "Supporter", "sortData": "Supporter", "cachedColor": "#4e6a7e", "total": 57, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron": { "color": "#7e9fb5", "title": "Patron", "sortData": "Patron", "cachedColor": "#7e9fb5", "total": 8, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Silver": { "color": "#87a9c0", "title": "Patron's Circle Silver", "sortData": "Patron's Circle Silver", "cachedColor": "#87a9c0", "total": 2, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true } } } }, { "jaql": { "table": "NEXT MEMBERSHIP RESULT", "column": "Next Membership Result", "dim": "[NEXT MEMBERSHIP.Next Membership Result]", "datatype": "text", "merged": true, "title": "Next Membership Result" }, "format": { "members": { "Did Not Renew": { "color": "#ffffff", "title": "Did Not Renew", "sortData": "Did Not Renew", "cachedColor": "#005f52", "total": 46, "colorIndex": 4, "colored": true, "inResultSetLength": 4 }, "Renewed": { "color": "#00b29a", "title": "Renewed", "sortData": "Renewed", "cachedColor": "#3d887e", "total": 18, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Reinstated": { "color": "#395365", "title": "Reinstated", "sortData": "Reinstated", "cachedColor": "#7ab0a9", "total": 5, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Late Renewal": { "color": "#005c50", "title": "Late Renewal", "sortData": "Late Renewal", "cachedColor": "#5c9c93", "total": 10, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Base Membership Is Current": { "color": "#953224", "title": "Base Membership Is Current", "sortData": "Base Membership Is Current", "cachedColor": "#297a6f", "total": 53, "colorIndex": 4, "colored": true, "inResultSetLength": 6, "inResultset": true }, "New": { "color": "#7ab0a9", "title": "New", "sortData": "New", "cachedColor": "#7ab0a9", "total": 2, "colorIndex": 4, "colored": true, "inResultSetLength": 5, "inResultset": true } } } }, { "jaql": { "table": "NEXT MEMBERSHIP", "column": "Next Macro Level Trend", "dim": "[NEXT MEMBERSHIP.Next Macro Level Trend]", "datatype": "text", "merged": true, "title": "Next Macro Level Trend" }, "format": { "members": { "(none)": { "color": "#ffffff", "title": "(none)", "sortData": "(none)", "cachedColor": "#ab6304", "total": 46, "colorIndex": 1, "colored": true, "inResultSetLength": 6, "inResultset": true }, "Decrease": { "color": "#f3daba", "title": "Decrease", "sortData": "Decrease", "cachedColor": "#f3daba", "total": 5, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Downgrade": { "color": "#dbb27d", "title": "Downgrade", "sortData": "Downgrade", "cachedColor": "#dbb27d", "total": 12, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Same": { "color": "#e7c69b", "title": "Same", "sortData": "Same", "cachedColor": "#e7c69b", "total": 8, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Upgrade": { "color": "#cf9f5f", "title": "Upgrade", "sortData": "Upgrade", "cachedColor": "#cf9f5f", "total": 14, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "New": { "color": "#c38b41", "title": "New", "sortData": "New", "cachedColor": "#c38b41", "total": 34, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Increase": { "color": "#ffeed8", "title": "Increase", "sortData": "Increase", "cachedColor": "#ffeed8", "total": 2, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true } } } }, { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "Next Membership Level" }, "format": { "members": { "(none)": { "color": "#ffffff", "title": "(none)", "sortData": "(none)", "cachedColor": "#993325", "total": 275, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Gold Member": { "color": "#e8a9a1", "title": "Gold Member", "sortData": "Gold Member", "cachedColor": "#e8a9a1", "total": 7, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Alliance": { "color": "#bb665a", "title": "Alliance", "sortData": "Alliance", "cachedColor": "#bb665a", "total": 21, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Associate": { "color": "#d2877d", "title": "Associate", "sortData": "Associate", "cachedColor": "#d2877d", "total": 10, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Family One Year": { "color": "#c6776c", "title": "Family One Year", "sortData": "Family One Year", "cachedColor": "#c6776c", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Individual One Year": { "color": "#b05548", "title": "Individual One Year", "sortData": "Individual One Year", "cachedColor": "#b05548", "total": 26, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Platinum Member": { "color": "#f4bab2", "title": "Platinum Member", "sortData": "Platinum Member", "cachedColor": "#f4bab2", "total": 4, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Silver Member": { "color": "#dd988f", "title": "Silver Member", "sortData": "Silver Member", "cachedColor": "#dd988f", "total": 9, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Family Two Year": { "color": "#ffcbc4", "title": "Family Two Year", "sortData": "Family Two Year", "cachedColor": "#ffcbc4", "total": 1, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Angel": { "color": "#dd988f", "title": "Angel", "sortData": "Angel", "cachedColor": "#dd988f", "total": 6, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Donor": { "color": "#b05548", "title": "Donor", "sortData": "Donor", "cachedColor": "#b05548", "total": 24, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Bronze": { "color": "#e8a9a1", "title": "Patron's Circle Bronze", "sortData": "Patron's Circle Bronze", "cachedColor": "#e8a9a1", "total": 5, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Gold": { "color": "#bb665a", "title": "Patron's Circle Gold", "sortData": "Patron's Circle Gold", "cachedColor": "#bb665a", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Platinum": { "color": "#d2877d", "title": "Patron's Circle Platinum", "sortData": "Patron's Circle Platinum", "cachedColor": "#d2877d", "total": 6, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Supporter": { "color": "#c6776c", "title": "Supporter", "sortData": "Supporter", "cachedColor": "#c6776c", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron": { "color": "#f4bab2", "title": "Patron", "sortData": "Patron", "cachedColor": "#f4bab2", "total": 2, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Silver": { "color": "#ffcbc4", "title": "Patron's Circle Silver", "sortData": "Patron's Circle Silver", "cachedColor": "#ffcbc4", "total": 2, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "filter": { "explicit": true, "multiSelection": true, "members": [ "AR Donor/Member Levels" ] }, "collapsed": true, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } }, "disabled": true }, { "jaql": { "table": "EXPIRATION DATE", "column": "Fiscal Year", "dim": "[EXPIRATION.Fiscal Year1]", "datatype": "numeric", "title": "Fiscal Year", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": true, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships", "lastBuildTime": "2019-02-13T14:03:41" } }, "disabled": true }, { "jaql": { "table": "NEXT MEMBERSHIP RESULT", "column": "Next Membership Result", "dim": "[NEXT MEMBERSHIP.Next Membership Result]", "datatype": "text", "merged": true, "title": "Next Membership Result", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Did Not Renew" ] } }, "collapsed": true, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } } } ] } ] }, "type": "sunburst", "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": { "center/value": true, "center/contribution": true, "center/contributionToParent": true, "tooltip/value": true, "tooltip/contribution": false, "legend/enabled": true, "legend/position": "bottom", "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "membership_level", "title": "Membership Level", "singular": "Membership Level", "plural": "Membership Level" }, { "id": "next_membership_result", "title": "Next Membership Result", "singular": "Next Membership Result", "plural": "Next Membership Result" }, { "id": "next_macro_level_trend", "title": "Next Macro Level Trend", "singular": "Next Macro Level Trend", "plural": "Next Macro Level Trend" }, { "id": "next_membership_level", "title": "Next Membership Level", "singular": "Next Membership Level", "plural": "Next Membership Level" }, { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" }, { "id": "fiscal_year", "title": "Fiscal Year", "singular": "Fiscal Year", "plural": "Fiscal Year" } ] }, "paletteName": "Tessitura" }, "instanceid": "73446-B5FC-3F", "queryStartTime": "2019-06-24T12:53:33", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "canEditFilters": true, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "5d10da0f7d63a136dc769b26", "drawing": true }, { "title": "Membership Level Current Levels Came From", "subtype": "sunburst", "oid": "5d10da197d63a136dc769b3c", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "NEXT MEMBERSHIP RESULT", "column": "Next Membership Result", "dim": "[NEXT MEMBERSHIP.Next Membership Result]", "datatype": "text", "merged": true, "title": "Next Membership Result" }, "format": { "members": { "Did Not Renew": { "color": "#ffffff", "title": "Did Not Renew", "sortData": "Did Not Renew", "cachedColor": "#005f52", "total": 46, "colorIndex": 4, "colored": true, "inResultSetLength": 4 }, "Renewed": { "color": "#00b29a", "title": "Renewed", "sortData": "Renewed", "cachedColor": "#3d887e", "total": 18, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Reinstated": { "color": "#008775", "title": "Reinstated", "sortData": "Reinstated", "cachedColor": "#7ab0a9", "total": 5, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Late Renewal": { "color": "#009d88", "title": "Late Renewal", "sortData": "Late Renewal", "cachedColor": "#5c9c93", "total": 10, "colorIndex": 4, "colored": true, "inResultSetLength": 4, "inResultset": true }, "Base Membership Is Current": { "color": "#005f52", "title": "Base Membership Is Current", "sortData": "Base Membership Is Current", "cachedColor": "#005f52", "total": 54, "colorIndex": 4, "colored": true, "inResultSetLength": 5, "inResultset": true }, "New": { "color": "#007162", "title": "New", "sortData": "New", "cachedColor": "#7ab0a9", "total": 1, "colorIndex": 4, "colored": true, "inResultSetLength": 5, "inResultset": true } } } }, { "jaql": { "table": "NEXT MEMBERSHIP", "column": "Next Macro Level Trend", "dim": "[NEXT MEMBERSHIP.Next Macro Level Trend]", "datatype": "text", "merged": true, "title": "Next Macro Level Trend" }, "format": { "members": { "(none)": { "color": "#ffffff", "title": "(none)", "sortData": "(none)", "cachedColor": "#ab6304", "total": 46, "colorIndex": 1, "colored": true, "inResultSetLength": 6, "inResultset": true }, "Decrease": { "color": "#953224", "title": "Decrease", "sortData": "Decrease", "cachedColor": "#f3daba", "total": 5, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Downgrade": { "color": "#db4935", "title": "Downgrade", "sortData": "Downgrade", "cachedColor": "#dbb27d", "total": 12, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Same": { "color": "#a66104", "title": "Same", "sortData": "Same", "cachedColor": "#e7c69b", "total": 8, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Upgrade": { "color": "#ffa62e", "title": "Upgrade", "sortData": "Upgrade", "cachedColor": "#cf9f5f", "total": 14, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "New": { "color": "#ff6752", "title": "New", "sortData": "New", "cachedColor": "#c38b41", "total": 34, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true }, "Increase": { "color": "#f48e06", "title": "Increase", "sortData": "Increase", "cachedColor": "#ffeed8", "total": 2, "colorIndex": 1, "colored": true, "inResultSetLength": 7, "inResultset": true } } } }, { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "Next Membership Level" }, "format": { "members": { "(none)": { "color": "#ffffff", "title": "(none)", "sortData": "(none)", "cachedColor": "#993325", "total": 275, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Gold Member": { "color": "#e8a9a1", "title": "Gold Member", "sortData": "Gold Member", "cachedColor": "#e8a9a1", "total": 7, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Alliance": { "color": "#bb665a", "title": "Alliance", "sortData": "Alliance", "cachedColor": "#bb665a", "total": 21, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Associate": { "color": "#d2877d", "title": "Associate", "sortData": "Associate", "cachedColor": "#d2877d", "total": 10, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Family One Year": { "color": "#c6776c", "title": "Family One Year", "sortData": "Family One Year", "cachedColor": "#c6776c", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Individual One Year": { "color": "#b05548", "title": "Individual One Year", "sortData": "Individual One Year", "cachedColor": "#b05548", "total": 26, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Platinum Member": { "color": "#f4bab2", "title": "Platinum Member", "sortData": "Platinum Member", "cachedColor": "#f4bab2", "total": 4, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Silver Member": { "color": "#dd988f", "title": "Silver Member", "sortData": "Silver Member", "cachedColor": "#dd988f", "total": 9, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Family Two Year": { "color": "#ffcbc4", "title": "Family Two Year", "sortData": "Family Two Year", "cachedColor": "#ffcbc4", "total": 1, "colorIndex": 2, "colored": true, "inResultSetLength": 9 }, "Angel": { "color": "#dd988f", "title": "Angel", "sortData": "Angel", "cachedColor": "#dd988f", "total": 6, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Donor": { "color": "#b05548", "title": "Donor", "sortData": "Donor", "cachedColor": "#b05548", "total": 24, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Bronze": { "color": "#e8a9a1", "title": "Patron's Circle Bronze", "sortData": "Patron's Circle Bronze", "cachedColor": "#e8a9a1", "total": 5, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Gold": { "color": "#c6776c", "title": "Patron's Circle Gold", "sortData": "Patron's Circle Gold", "cachedColor": "#c6776c", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Platinum": { "color": "#d2877d", "title": "Patron's Circle Platinum", "sortData": "Patron's Circle Platinum", "cachedColor": "#d2877d", "total": 6, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Supporter": { "color": "#bb665a", "title": "Supporter", "sortData": "Supporter", "cachedColor": "#bb665a", "total": 17, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron": { "color": "#f4bab2", "title": "Patron", "sortData": "Patron", "cachedColor": "#f4bab2", "total": 2, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true }, "Patron's Circle Silver": { "color": "#ffcbc4", "title": "Patron's Circle Silver", "sortData": "Patron's Circle Silver", "cachedColor": "#ffcbc4", "total": 2, "colorIndex": 2, "colored": true, "inResultSetLength": 9, "inResultset": true } } } }, { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level", "dim": "[MEMBERSHIP LEVEL.Membership Level]", "datatype": "text", "merged": true, "title": "Membership Level" }, "format": { "members": { "Alliance": { "color": "#4c687c", "title": "Alliance", "sortData": "Alliance", "cachedColor": "#4c687c", "total": 66, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Associate": { "color": "#5d7a8f", "title": "Associate", "sortData": "Associate", "cachedColor": "#5d7a8f", "total": 40, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Family One Year": { "color": "#547185", "title": "Family One Year", "sortData": "Family One Year", "cachedColor": "#547185", "total": 56, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Family Two Year": { "color": "#7fa0b6", "title": "Family Two Year", "sortData": "Family Two Year", "cachedColor": "#7fa0b6", "total": 6, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Gold Member": { "color": "#6e8da3", "title": "Gold Member", "sortData": "Gold Member", "cachedColor": "#6e8da3", "total": 13, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Individual One Year": { "color": "#3b5568", "title": "Individual One Year", "sortData": "Individual One Year", "cachedColor": "#3b5568", "total": 157, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Individual Two Year": { "color": "#7696ac", "title": "Individual Two Year", "sortData": "Individual Two Year", "cachedColor": "#7696ac", "total": 10, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Platinum Member": { "color": "#7fa0b6", "title": "Platinum Member", "sortData": "Platinum Member", "cachedColor": "#7fa0b6", "total": 6, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Silver Member": { "color": "#658499", "title": "Silver Member", "sortData": "Silver Member", "cachedColor": "#658499", "total": 23, "colorIndex": 0, "colored": true, "inResultSetLength": 9 }, "Angel": { "color": "#617f94", "title": "Angel", "sortData": "Angel", "cachedColor": "#617f94", "total": 22, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Donor": { "color": "#3b5568", "title": "Donor", "sortData": "Donor", "cachedColor": "#3b5568", "total": 79, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Bronze": { "color": "#6b8a9f", "title": "Patron's Circle Bronze", "sortData": "Patron's Circle Bronze", "cachedColor": "#6b8a9f", "total": 17, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Gold": { "color": "#587589", "title": "Patron's Circle Gold", "sortData": "Patron's Circle Gold", "cachedColor": "#587589", "total": 40, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Platinum": { "color": "#7e9fb5", "title": "Patron's Circle Platinum", "sortData": "Patron's Circle Platinum", "cachedColor": "#7e9fb5", "total": 6, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Supporter": { "color": "#4e6a7e", "title": "Supporter", "sortData": "Supporter", "cachedColor": "#4e6a7e", "total": 47, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron": { "color": "#6b8a9f", "title": "Patron", "sortData": "Patron", "cachedColor": "#6b8a9f", "total": 8, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true }, "Patron's Circle Silver": { "color": "#87a9c0", "title": "Patron's Circle Silver", "sortData": "Patron's Circle Silver", "cachedColor": "#87a9c0", "total": 2, "colorIndex": 0, "colored": true, "inResultSetLength": 8, "inResultset": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "table": "MEMBERSHIP VALUES", "column": "Membership Count", "dim": "[MEMBERSHIP VALUES.Membership Count]", "datatype": "numeric", "agg": "sum", "title": "Total Membership Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Organization", "dim": "[MEMBERSHIP LEVEL.Membership Organization]", "datatype": "text", "merged": true, "title": "Membership Organization", "filter": { "explicit": true, "multiSelection": true, "members": [ "AR Membership (AD)" ] }, "collapsed": true, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } }, "disabled": true }, { "jaql": { "table": "EXPIRATION DATE", "column": "Fiscal Year", "dim": "[EXPIRATION.Fiscal Year1]", "datatype": "numeric", "title": "Fiscal Year", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": true, "datasource": { "title": "Memberships", "fullname": "CWALLINGFORD-TN/Memberships", "id": "aCWALLINGFORDLQAaTN_aMEMBERSHIPS", "address": "CWALLINGFORD-TN", "database": "aMemberships", "lastBuildTime": "2019-02-13T14:03:41" } }, "disabled": true }, { "jaql": { "table": "NEXT MEMBERSHIP RESULT", "column": "Next Membership Result", "dim": "[NEXT MEMBERSHIP.Next Membership Result]", "datatype": "text", "merged": true, "title": "Next Membership Result", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Base Membership Is Current", "Did Not Renew" ] }, "filter": { "turnedOff": true, "exclude": { "members": [ "Base Membership Is Current" ] } } }, "collapsed": true, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } } } ] } ] }, "type": "sunburst", "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": { "center/value": true, "center/contribution": true, "center/contributionToParent": true, "tooltip/value": true, "tooltip/contribution": false, "legend/enabled": true, "legend/position": "bottom", "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "next_membership_result", "title": "Next Membership Result", "singular": "Next Membership Result", "plural": "Next Membership Result" }, { "id": "next_macro_level_trend", "title": "Next Macro Level Trend", "singular": "Next Macro Level Trend", "plural": "Next Macro Level Trend" }, { "id": "next_membership_level", "title": "Next Membership Level", "singular": "Next Membership Level", "plural": "Next Membership Level" }, { "id": "membership_level", "title": "Membership Level", "singular": "Membership Level", "plural": "Membership Level" }, { "id": "membership_organization", "title": "Membership Organization", "singular": "Membership Organization", "plural": "Membership Organization" }, { "id": "fiscal_year", "title": "Fiscal Year", "singular": "Fiscal Year", "plural": "Fiscal Year" } ] }, "paletteName": "Tessitura" }, "instanceid": "73446-B5FC-3F", "queryStartTime": "2019-06-24T12:53:02", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "canEditFilters": true, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "5d10da0f7d63a136dc769b26", "drawing": true }, { "title": "Pivot Table", "subtype": "pivot", "oid": "5d10da597d63a136dc769b69", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "EXPIRATION DATE", "column": "Fiscal Year", "dim": "[EXPIRATION.Fiscal Year1]", "datatype": "numeric", "title": "Fiscal Year" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level Rank", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level Rank]", "datatype": "numeric", "title": "n" }, "field": { "id": "[NEXT MEMBERSHIP LEVEL.Next Membership Level Rank]", "index": 0 }, "format": { "width": 36 } }, { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level" }, "field": { "id": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "index": 1 } }, { "jaql": { "table": "NEXT MEMBERSHIP", "column": "Next Macro Level Trend", "dim": "[NEXT MEMBERSHIP.Next Macro Level Trend]", "datatype": "text", "merged": true, "title": "Next Macro Level Trend" }, "field": { "id": "[NEXT MEMBERSHIP.Next Macro Level Trend]", "index": 2 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 5 } } ] }, { "name": "columns", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level Rank", "dim": "[MEMBERSHIP LEVEL.Membership Level Rank]", "datatype": "numeric", "title": "c" }, "field": { "id": "[MEMBERSHIP LEVEL.Membership Level Rank]", "index": 3 } }, { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level", "dim": "[MEMBERSHIP LEVEL.Membership Level]", "datatype": "text", "merged": true, "title": "From Level" }, "field": { "id": "[MEMBERSHIP LEVEL.Membership Level]", "index": 4 } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } } } ] } ] }, "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": "20", "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": "fiscal_year", "title": "Fiscal Year", "singular": "Fiscal Year", "plural": "Fiscal Year" }, { "id": "n", "title": "n", "singular": "n", "plural": "n" }, { "id": "to_level", "title": "To Level", "singular": "To Level", "plural": "To Level" }, { "id": "next_macro_level_trend", "title": "Next Macro Level Trend", "singular": "Next Macro Level Trend", "plural": "Next Macro Level Trend" }, { "id": "c", "title": "c", "singular": "c", "plural": "c" }, { "id": "from_level", "title": "From Level", "singular": "From Level", "plural": "From Level" } ] } }, "instanceid": "F1100-406D-DB", "queryStartTime": "2019-06-24T12:54:06", "widgetTimingLoged": false, "drawing": true, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5d10da0f7d63a136dc769b26", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true, "viewState": { "activeTab": "filters" } }, { "title": "Tree Chart w/Size=Constituents & Color=MembershipAmountVariance", "subtype": "treemap", "oid": "5d10db307d63a136dc769bad", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level", "dim": "[MEMBERSHIP LEVEL.Membership Level]", "datatype": "text", "merged": true, "title": "From Level" } }, { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level" }, "field": { "id": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "index": 1 } } ] }, { "name": "size", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "type": "color", "color": "transparent" } }, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 5 } } ] }, { "name": "color", "items": [ { "jaql": { "type": "measure", "formula": "[E171B-7F2]-[1512A-AE4]", "context": { "[E171B-7F2]": { "table": "NEXT MEMBERSHIP", "column": "Next Amount", "dim": "[NEXT MEMBERSHIP.Next Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Next Amount" }, "[1512A-AE4]": { "table": "MEMBERSHIP VALUES", "column": "Amount", "dim": "[MEMBERSHIP VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Membership Amount Variance" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "steps": 9, "min": "#ff6752", "max": "#009d88", "minvalue": null, "midvalue": null, "maxvalue": null, "minValueValid": true, "midValueValid": true, "maxValueValid": true, "type": "range", "rangeMode": "both" } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } } } ] } ] }, "type": "treemap", "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": { "title/1": true, "title/2": true, "title/3": true, "tooltip/value": true, "tooltip/contribution": false, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "from_level", "title": "From Level", "singular": "From Level", "plural": "From Level" }, { "id": "to_level", "title": "To Level", "singular": "To Level", "plural": "To Level" } ] } }, "instanceid": "0A0F6-7BBD-F6", "queryStartTime": "2019-06-24T13:33:26", "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": "5d10da0f7d63a136dc769b26", "options": { "dashboardFiltersMode": "select", "triggersDomready": true, "selector": true, "disallowSelector": false, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "drawing": true, "canEditFilters": true, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "design" } }, { "title": "Scatter Chart w/Size=Constituents & Color=MembershipAmountVariance", "subtype": "bubble/scatter", "oid": "5d10dc5e7d63a136dc769bce", "desc": null, "source": null, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level" }, "field": { "id": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "index": 1 } } ] }, { "name": "y-axis", "items": [ { "jaql": { "table": "MEMBERSHIP LEVEL", "column": "Membership Level", "dim": "[MEMBERSHIP LEVEL.Membership Level]", "datatype": "text", "merged": true, "title": "From Level" } } ] }, { "name": "point", "items": [] }, { "name": "Break By / Color", "items": [ { "jaql": { "type": "measure", "formula": "[392DA-E1E]-[80104-12A]", "context": { "[392DA-E1E]": { "table": "NEXT MEMBERSHIP", "column": "Next Amount", "dim": "[NEXT MEMBERSHIP.Next Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Next Amount" }, "[80104-12A]": { "table": "MEMBERSHIP VALUES", "column": "Amount", "dim": "[MEMBERSHIP VALUES.Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Amount" } }, "title": "Membership Amount Variance" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "steps": 5, "min": "#ff6752", "max": "#009d88", "minvalue": null, "midvalue": null, "maxvalue": null, "minValueValid": true, "midValueValid": true, "maxValueValid": true, "type": "range", "rangeMode": "both" } } } ] }, { "name": "size", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "agg": "count", "title": "# of unique Constituent ID" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "NEXT MEMBERSHIP LEVEL", "column": "Next Membership Level", "dim": "[NEXT MEMBERSHIP LEVEL.Next Membership Level]", "datatype": "text", "merged": true, "title": "To Level", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "SDNA-Memberships", "fullname": "NASCUBEBP900.KRIOSTESS.local/SDNA-Memberships", "id": "aNASCUBEBP900LgAaKRIOSTESSLgAaLOCAL_aSDNALQAaMEMBERSHIPS", "address": "NASCUBEBP900.KRIOSTESS.local", "database": "aSDNALQAaMemberships" } } } ] } ] }, "type": "chart/scatter", "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 }, "markerSize": { "isRange": true, "min": 12, "max": 48, "lowest": 10, "highest": 60, "step": 1, "defaultSize": 10 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false, "hideMinMax": true, "logarithmicOld": false }, "yAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "hideMinMax": true, "isIntervalEnabled": false, "logarithmicOld": false }, "dataLimits": { "categoriesCapacityX": 500, "categoriesCapacityY": 500, "seriesCapacity": 50 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "to_level", "title": "To Level", "singular": "To Level", "plural": "To Level" }, { "id": "from_level", "title": "From Level", "singular": "From Level", "plural": "From Level" } ] } }, "instanceid": "65FD1-8B9A-03", "queryStartTime": "2019-06-24T13:33:26", "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": "5d10da0f7d63a136dc769b26", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": -0.04364326375711575, "max": 7.0910815939278935 } }, "drawing": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 }, "viewState": { "activeTab": "filters" }, "canEditFilters": true } ], "hierarchies": [] }