{ "title": "Repeat Cycle", "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": "87256-EF62-38", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 2048, "minWidth": 64, "maxWidth": 2048, "height": "52px", "defaultWidth": 128, "widgetid": "65553f8e82658e4b981e6b66" } ], "width": 100, "stretchable": false, "pxlWidth": 1826, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "667px", "defaultWidth": 512, "widgetid": "6543f27b7a3a9a2b50113ff3", "autoHeight": "635px" } ], "width": 25.206301575393848, "stretchable": false, "pxlWidth": 460.266, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6543fd5e7a3a9a2b50113ff7", "height": "667px", "autoHeight": "397px" } ], "width": 25.506376594148538, "stretchable": false, "pxlWidth": 465.734, "index": 1 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6552849fbe547b2698047494", "height": "667px", "autoHeight": "667px" } ], "width": 49.287321830457614, "stretchable": false, "pxlWidth": 899.984, "index": 2 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "655285f3be547b2698047498", "height": "340px", "autoHeight": "320px" } ], "width": 65.19246519246519, "stretchable": false, "pxlWidth": 796, "index": 0 }, { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "6553eaf93e29dea750358bfd", "height": "340px" } ], "width": 34.80753480753481, "stretchable": false, "pxlWidth": 425, "index": 1 } ] } ], "pxlWidth": 1826, "index": 0 } ], "container": { "sizzle1706623846083": { "undefined": { "parentNode": [ 1765.1122349732057, 97, true ] } } } }, "original": null, "oid": "6543f128ad1fd0346c470cc7", "dataExploration": false, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "filters": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent Display Name", "dim": "[CONSTITUENT.Constituent Display Name]", "datatype": "text", "merged": true, "title": "Constituent Display Name", "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true, "filter": { "explicit": true, "userMultiSelect": false, "multiSelection": false, "members": [ "Adriane Brown" ] } }, "instanceid": "97CB3-D4B0-17", "isCascading": false, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public", "(none)" ] } } }, "instanceid": "BA85B-AC75-21", "isCascading": false, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Current Season Buyers", "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "filter": { "top": 100000, "by": { "type": "measure", "formula": "([AFBC0-86C],[AA107-039])", "context": { "[AA107-039]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0", "-1" ] }, "collapsed": false, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "[8F790-92B]": { "table": "SEASON", "column": "Season Fiscal Current Year Offset", "dim": "[SEASON.Season Fiscal Current Year Offset]", "datatype": "numeric", "title": "Season Fiscal Current Year Offset", "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] }, "collapsed": false, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-11-14T17:47:40.817Z" } }, "[AFBC0-86C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "Formula" } } }, "instanceid": "3DC7C-06C8-08", "isCascading": false, "disabled": false } ], "editing": true, "parentFolder": null, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "defaultFilters": null, "widgets": [ { "title": "All Visits Ranked", "type": "pivot", "subtype": "pivot", "oid": "6543f27b7a3a9a2b50113ff3", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "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 } }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Attended Date", "sortDetails": { "field": 1, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "field": { "id": "[ATTENDED DATE.Date (Calendar)]_days", "index": 1 }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "RANK(\n MAX([6019B-DBD]*10000+[74944-1D2]*100+[35A09-FBA])\n ,\"DESC\",\"1223\",[52C1C-14B]\n )", "context": { "[35A09-FBA]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[74944-1D2]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[52C1C-14B]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[6019B-DBD]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "Rank" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RANK(\n MAX([6019B-DBD]*10000+[74944-1D2]*100+[35A09-FBA])\n ,\"DESC\",\"1223\",[52C1C-14B]\n )", "index": 2 } }, { "jaql": { "type": "measure", "formula": "ORDERING(\n -1*MAX([02689-3C4]*10000+[3E376-870]*100+[2BD72-AC4])\n )", "context": { "[2BD72-AC4]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[3E376-870]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[02689-3C4]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "Ordering" }, "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": [] }, { "name": "filters", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "years", "title": "Attended Date", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900-01-01T00:00:00" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "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": "attended_date", "title": "Attended Date", "singular": "Attended Date", "plural": "Attended Date" } ] } }, "instanceid": "40042-4E5E-9A", "queryStartTime": "2023-11-03T06:58:10", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "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, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "canEditFilters": true, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6543f128ad1fd0346c470cc7", "script_old": null, "script": null }, { "title": "Last 2 Visits Only", "type": "pivot", "subtype": "pivot", "oid": "6543fd5e7a3a9a2b50113ff7", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "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 } }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Attended Date", "sortDetails": { "field": 1, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "field": { "id": "[ATTENDED DATE.Date (Calendar)]_days", "index": 1 }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "RANK(\n MAX([6019B-DBD]*10000+[74944-1D2]*100+[35A09-FBA])\n ,\"DESC\",\"1223\",[52C1C-14B]\n )", "context": { "[35A09-FBA]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[74944-1D2]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[52C1C-14B]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[6019B-DBD]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "Rank" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RANK(\n MAX([6019B-DBD]*10000+[74944-1D2]*100+[35A09-FBA])\n ,\"DESC\",\"1223\",[52C1C-14B]\n )", "index": 2 } }, { "jaql": { "type": "measure", "formula": "(MAX([3CE58-EAA]*356+[FABA9-17D]),ALL([BAACD-8FA]))\n-\n(MIN([3CE58-EAA]*356+[FABA9-17D]),ALL([BAACD-8FA]))", "context": { "[FABA9-17D]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[3CE58-EAA]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[BAACD-8FA]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": true }, { "jaql": { "type": "measure", "formula": "MAX([DDD81-DAB]*356+[1ABF6-E13])\n-\nMIN([DDD81-DAB]*356+[1ABF6-E13])", "context": { "[1ABF6-E13]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[DDD81-DAB]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[14573-585]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula (1)" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": true, "field": { "index": 3 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "type": "measure", "formula": "RANK(\n MAX([6019B-DBD]*10000+[74944-1D2]*100+[35A09-FBA])\n ,\"DESC\",\"1223\",[52C1C-14B]\n )", "context": { "[35A09-FBA]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[74944-1D2]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[52C1C-14B]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[6019B-DBD]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "Rank", "filter": { "to": 2 }, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } }, { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Attended Date Year", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } } } ] } ] }, "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": "attended_date", "title": "Attended Date", "singular": "Attended Date", "plural": "Attended Date" }, { "id": "attended_date_year", "title": "Attended Date Year", "singular": "Attended Date Year", "plural": "Attended Date Year" } ] } }, "instanceid": "40042-4E5E-9A", "queryStartTime": "2023-11-14T16:36:30", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "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, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "canEditFilters": true, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6543f128ad1fd0346c470cc7", "drawing": true, "script_old": null, "script": null }, { "title": "Last 2 Visits Flagged", "type": "pivot", "subtype": "pivot", "oid": "6552849fbe547b2698047494", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Constituent Display Name", "dim": "[CONSTITUENT.Constituent Display Name]", "datatype": "text", "merged": true, "title": "Constituent Display Name" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 } }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Attended Date", "sortDetails": { "field": 1, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "field": { "id": "[ATTENDED DATE.Date (Calendar)]_days", "index": 1 }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "RANK(\n MAX([922AE-554]*10000+[92AAC-991]*100+[5324A-04D])\n ,\"DESC\",\"1223\",[304D4-2B1]\n )", "context": { "[5324A-04D]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[92AAC-991]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[304D4-2B1]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[922AE-554]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "Rank" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "RANK(\n MAX([922AE-554]*10000+[92AAC-991]*100+[5324A-04D])\n ,\"DESC\",\"1223\",[304D4-2B1]\n )", "index": 2 } }, { "jaql": { "type": "measure", "formula": " IF(\n RANK(\n MAX([48088-7EC] * 10000 + [CBA7B-C79] * 100 + [A655A-C68]), \"DESC\", \"1223\", [12347-431]\n ) = 1, 1, NULL\n )", "context": { "[A655A-C68]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[12347-431]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[CBA7B-C79]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[48088-7EC]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "IF Rank = 1" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": " IF(\n RANK(\n MAX([48088-7EC] * 10000 + [CBA7B-C79] * 100 + [A655A-C68]), \"DESC\", \"1223\", [12347-431]\n ) = 1, 1, NULL\n )", "index": 3 } }, { "jaql": { "type": "measure", "formula": " IF(\n RANK(\n MAX([AD75E-166] * 10000 + [1F873-DE0] * 100 + [49B7B-DD6]), \"DESC\", \"1223\", [F2BB7-3CF]\n ) = 2, 2, NULL\n )", "context": { "[49B7B-DD6]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Month", "dim": "[ATTENDED DATE.Calendar Day Of Month]", "datatype": "numeric", "title": "Calendar Day Of Month" }, "[F2BB7-3CF]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[1F873-DE0]": { "table": "ATTENDED DATE", "column": "Calendar Month", "dim": "[ATTENDED DATE.Calendar Month]", "datatype": "numeric", "title": "Calendar Month" }, "[AD75E-166]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "IF Rank = 2" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": " IF(\n RANK(\n MAX([AD75E-166] * 10000 + [1F873-DE0] * 100 + [49B7B-DD6]), \"DESC\", \"1223\", [F2BB7-3CF]\n ) = 2, 2, NULL\n )", "index": 4 } }, { "jaql": { "type": "measure", "formula": "IF(\n RANK(\n MAX([81BDC-2C4] * 365 + [2BB5A-5DA]),\n \"DESC\", \"1223\", [76DBA-ECB]\n ) = 1,\n MAX([81BDC-2C4] * 365 + [2BB5A-5DA]),\n NULL\n)", "context": { "[2BB5A-5DA]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[76DBA-ECB]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[81BDC-2C4]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "IF Rank = 1 Date" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF(\n RANK(\n MAX([81BDC-2C4] * 365 + [2BB5A-5DA]),\n \"DESC\", \"1223\", [76DBA-ECB]\n ) = 1,\n MAX([81BDC-2C4] * 365 + [2BB5A-5DA]),\n NULL\n)", "index": 5 } }, { "jaql": { "type": "measure", "formula": "IF(\n RANK(\n MAX([DBC12-F06] * 365 + [CC6D7-813]),\n \"DESC\", \"1223\", [433A9-C61]\n ) = 2,\n MAX([DBC12-F06] * 365 + [CC6D7-813]),\n NULL\n)", "context": { "[CC6D7-813]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[433A9-C61]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[DBC12-F06]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" } }, "title": "IF Rank = Date" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF(\n RANK(\n MAX([DBC12-F06] * 365 + [CC6D7-813]),\n \"DESC\", \"1223\", [433A9-C61]\n ) = 2,\n MAX([DBC12-F06] * 365 + [CC6D7-813]),\n NULL\n)", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Attended Date Year", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false } ] } ] }, "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_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" }, { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "attended_date", "title": "Attended Date", "singular": "Attended Date", "plural": "Attended Date" }, { "id": "attended_date_year", "title": "Attended Date Year", "singular": "Attended Date Year", "plural": "Attended Date Year" }, { "id": "type", "title": "Type", "singular": "Type", "plural": "Type" } ] } }, "instanceid": "40042-4E5E-9A", "queryStartTime": "2023-11-14T16:36:30", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "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, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "canEditFilters": true, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "dashboardid": "6543f128ad1fd0346c470cc7", "drawing": true, "script_old": null, "script": null }, { "title": "Average Days Between Last 2 Visits", "type": "pivot", "subtype": "pivot", "oid": "655285f3be547b2698047498", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "CONSTITUENT", "column": "Division", "dim": "[CONSTITUENT.Division]", "datatype": "text", "merged": true, "title": "Division" }, "format": { "subtotal": false }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "field": { "id": "[CONSTITUENT.Constituent ID]", "index": 0 }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent Display Name", "dim": "[CONSTITUENT.Constituent Display Name]", "datatype": "text", "merged": true, "title": "Constituent Display Name" }, "field": { "id": "[CONSTITUENT.Constituent Display Name]", "index": 1 }, "disabled": false, "format": { "subtotal": true } }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Attended Date", "sortDetails": { "field": 2, "dir": "desc", "sortingLastDimension": true, "measurePath": null, "initialized": true }, "sort": "desc" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "field": { "index": 2 }, "hierarchies": [ "calendar", "calendar - weeks" ], "disabled": true } ] }, { "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": 2 } }, { "jaql": { "type": "measure", "formula": "SUM([BC25D-5D3],\n IF(\n MAX([73ECB-6C6],\n IF(\n RANK(\n MAX([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 2, MAX([94A91-4AB] * 365 + [5C4EC-EDF]),\n NULL\n )\n ) > 0,\n MIN([73ECB-6C6],\n IF(\n RANK(\n MIN([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 1, MIN([94A91-4AB] * 365 + [5C4EC-EDF]), NULL\n )\n ) -\n MIN([73ECB-6C6],\n IF(\n RANK(\n MIN([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 2, MIN([94A91-4AB] * 365 + [5C4EC-EDF]), NULL\n )\n )\n , NULL\n )\n)", "context": { "[5C4EC-EDF]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[BC25D-5D3]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[94A91-4AB]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[73ECB-6C6]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Rank Days Btwn" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "SUM([BC25D-5D3],\n IF(\n MAX([73ECB-6C6],\n IF(\n RANK(\n MAX([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 2, MAX([94A91-4AB] * 365 + [5C4EC-EDF]),\n NULL\n )\n ) > 0,\n MIN([73ECB-6C6],\n IF(\n RANK(\n MIN([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 1, MIN([94A91-4AB] * 365 + [5C4EC-EDF]), NULL\n )\n ) -\n MIN([73ECB-6C6],\n IF(\n RANK(\n MIN([94A91-4AB] * 365 + [5C4EC-EDF]),\n \"DESC\", \"1223\", [BC25D-5D3]\n ) = 2, MIN([94A91-4AB] * 365 + [5C4EC-EDF]), NULL\n )\n )\n , NULL\n )\n)", "index": 3 }, "disabled": false }, { "jaql": { "type": "measure", "formula": " SUM([A4842-85E],\n MIN([F9CC0-1DC],\n IF(\n RANK(\n MIN([31A19-556] * 365 + [CFEC6-E55]),\n \"DESC\", \"1223\", [A4842-85E]\n ) = 1, MIN([31A19-556] * 365 + [CFEC6-E55]), NULL\n )\n ) -\n MIN([F9CC0-1DC],\n IF(\n RANK(\n MIN([31A19-556] * 365 + [CFEC6-E55]),\n \"DESC\", \"1223\", [A4842-85E]\n ) = 2, MIN([31A19-556] * 365 + [CFEC6-E55]), NULL\n )\n )\n ) /\nCOUNT([A4842-85E])", "context": { "[CFEC6-E55]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[A4842-85E]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[31A19-556]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[F9CC0-1DC]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Avg Rank Days Btwn (some 1 visit)" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": true }, { "jaql": { "type": "measure", "formula": " SUM([8C60D-2F4],\n IF(\n MAX([03421-EA0],\n IF(\n RANK(\n MAX([D789A-9DA] * 365 + [C4EA7-4B9]),\n \"DESC\", \"1223\", [8C60D-2F4]\n ) = 2, MAX([D789A-9DA] * 365 + [C4EA7-4B9]),\n NULL\n )\n ) > 0,\n MIN([03421-EA0],\n IF(\n RANK(\n MIN([D789A-9DA] * 365 + [C4EA7-4B9]),\n \"DESC\", \"1223\", [8C60D-2F4]\n ) = 1, MIN([D789A-9DA] * 365 + [C4EA7-4B9]), NULL\n )\n ) -\n MIN([03421-EA0],\n IF(\n RANK(\n MIN([D789A-9DA] * 365 + [C4EA7-4B9]),\n \"DESC\", \"1223\", [8C60D-2F4]\n ) = 2, MIN([D789A-9DA] * 365 + [C4EA7-4B9]), NULL\n )\n ), NULL\n )\n ) /\nCOUNT([8C60D-2F4])", "context": { "[C4EA7-4B9]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[8C60D-2F4]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[D789A-9DA]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[03421-EA0]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Avg Rank Days Btwn (zeros)" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": true, "field": { "index": 4 } }, { "jaql": { "type": "measure", "formula": "IF(\n SUM([ADB6A-EBB],\n IF(\n MAX([C9C6B-F2B],\n IF(\n RANK(\n MAX([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 2, MAX([0010A-5E5] * 365 + [3E753-6E2]),\n NULL\n )\n ) > 0,\n MIN([C9C6B-F2B],\n IF(\n RANK(\n MIN([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 1, MIN([0010A-5E5] * 365 + [3E753-6E2]), NULL\n )\n ) -\n MIN([C9C6B-F2B],\n IF(\n RANK(\n MIN([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 2, MIN([0010A-5E5] * 365 + [3E753-6E2]), NULL\n )\n ), NULL\n )\n ) > 0,\n SUM([ADB6A-EBB],\n IF(\n MAX([C9C6B-F2B],\n IF(\n RANK(\n MAX([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 2, MAX([0010A-5E5] * 365 + [3E753-6E2]),\n NULL\n )\n ) > 0,\n MIN([C9C6B-F2B],\n IF(\n RANK(\n MIN([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 1, MIN([0010A-5E5] * 365 + [3E753-6E2]), NULL\n )\n ) -\n MIN([C9C6B-F2B],\n IF(\n RANK(\n MIN([0010A-5E5] * 365 + [3E753-6E2]),\n \"DESC\", \"1223\", [ADB6A-EBB]\n ) = 2, MIN([0010A-5E5] * 365 + [3E753-6E2]), NULL\n )\n ), NULL\n )\n ) /\nCOUNT([ADB6A-EBB])\n, NULL\n)", "context": { "[3E753-6E2]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[ADB6A-EBB]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[0010A-5E5]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[C9C6B-F2B]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Avg Rank Days Btwn (blanks)" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 5 }, "disabled": true }, { "jaql": { "type": "measure", "formula": "IF(\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0,\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 1, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ) -\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ), NULL\n )\n ) > 0,\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0,\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 1, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ) -\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ), NULL\n )\n ) /\n\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0, 1, NULL\n )\n ), NULL\n)", "context": { "[764CC-E4B]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[A5A3F-907]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[941EF-B9F]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[59B1E-A30]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Avg Rank Days Btwn" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "IF(\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0,\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 1, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ) -\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ), NULL\n )\n ) > 0,\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0,\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 1, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ) -\n MIN([59B1E-A30],\n IF(\n RANK(\n MIN([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MIN([941EF-B9F] * 365 + [764CC-E4B]), NULL\n )\n ), NULL\n )\n ) /\n\n SUM([A5A3F-907],\n IF(\n MAX([59B1E-A30],\n IF(\n RANK(\n MAX([941EF-B9F] * 365 + [764CC-E4B]),\n \"DESC\", \"1223\", [A5A3F-907]\n ) = 2, MAX([941EF-B9F] * 365 + [764CC-E4B]),\n NULL\n )\n ) > 0, 1, NULL\n )\n ), NULL\n)", "index": 4 }, "disabled": false } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Attended Date Year", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false } ] } ] }, "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": "division", "title": "Division", "singular": "Division", "plural": "Division" }, { "id": "constituent_id", "title": "Constituent ID", "singular": "Constituent ID", "plural": "Constituent ID" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" }, { "id": "attended_date", "title": "Attended Date", "singular": "Attended Date", "plural": "Attended Date" }, { "id": "attended_date_year", "title": "Attended Date Year", "singular": "Attended Date Year", "plural": "Attended Date Year" }, { "id": "type", "title": "Type", "singular": "Type", "plural": "Type" } ] }, "rowsGrandTotal": true }, "instanceid": "40042-4E5E-9A", "queryStartTime": "2024-01-30T09:46:59", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "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, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "dashboardid": "6543f128ad1fd0346c470cc7", "drawing": true, "canEditFilters": true, "script_old": null, "script": null }, { "title": "Average Days Between Last 2 Visits", "type": "indicator", "subtype": "indicator/numeric", "oid": "6553eaf93e29dea750358bfd", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "IF(\n SUM([4DC1C-5F7],\n IF(\n MAX([79297-162],\n IF(\n RANK(\n MAX([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 2, MAX([270D3-E4A] * 365 + [2B386-547]),\n NULL\n )\n ) > 0,\n MIN([79297-162],\n IF(\n RANK(\n MIN([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 1, MIN([270D3-E4A] * 365 + [2B386-547]), NULL\n )\n ) -\n MIN([79297-162],\n IF(\n RANK(\n MIN([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 2, MIN([270D3-E4A] * 365 + [2B386-547]), NULL\n )\n ), NULL\n )\n ) > 0,\n SUM([4DC1C-5F7],\n IF(\n MAX([79297-162],\n IF(\n RANK(\n MAX([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 2, MAX([270D3-E4A] * 365 + [2B386-547]),\n NULL\n )\n ) > 0,\n MIN([79297-162],\n IF(\n RANK(\n MIN([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 1, MIN([270D3-E4A] * 365 + [2B386-547]), NULL\n )\n ) -\n MIN([79297-162],\n IF(\n RANK(\n MIN([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 2, MIN([270D3-E4A] * 365 + [2B386-547]), NULL\n )\n ), NULL\n )\n ) \n /\n SUM([4DC1C-5F7],\n IF(\n MAX([79297-162],\n IF(\n RANK(\n MAX([270D3-E4A] * 365 + [2B386-547]),\n \"DESC\", \"1223\", [4DC1C-5F7]\n ) = 2, MAX([270D3-E4A] * 365 + [2B386-547]),\n NULL\n )\n ) > 0, 1, NULL\n )\n ), NULL\n)", "context": { "[2B386-547]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[4DC1C-5F7]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[270D3-E4A]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[79297-162]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Avg Rank Days Btwn" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": 0, "number": { "separated": true } }, "color": { "color": "#547A94", "type": "color" } }, "field": { "id": "SUM([60978-47E],\n IF(\n MAX([408F3-68A],\n IF(\n RANK(\n MAX([80E94-6C9] * 365 + [AACCF-DEF]),\n \"DESC\", \"1223\", [60978-47E]\n ) = 2, MAX([80E94-6C9] * 365 + [AACCF-DEF]),\n NULL\n )\n ) > 0,\n MIN([408F3-68A],\n IF(\n RANK(\n MIN([80E94-6C9] * 365 + [AACCF-DEF]),\n \"DESC\", \"1223\", [60978-47E]\n ) = 1, MIN([80E94-6C9] * 365 + [AACCF-DEF]), NULL\n )\n ) -\n MIN([408F3-68A],\n IF(\n RANK(\n MIN([80E94-6C9] * 365 + [AACCF-DEF]),\n \"DESC\", \"1223\", [60978-47E]\n ) = 2, MIN([80E94-6C9] * 365 + [AACCF-DEF]), NULL\n )\n )\n , NULL\n )\n) / COUNT([60978-47E])", "index": 2 }, "disabled": false } ] }, { "name": "secondary", "items": [ { "jaql": { "type": "measure", "formula": " SUM([74DC6-B12],\n IF(\n MAX([589D6-C28],\n IF(\n RANK(\n MAX([85F1C-828] * 365 + [5C476-446]),\n \"DESC\", \"1223\", [74DC6-B12]\n ) = 2, MAX([85F1C-828] * 365 + [5C476-446]),\n NULL\n )\n ) > 0, 1, NULL\n )\n )", "context": { "[5C476-446]": { "table": "ATTENDED DATE", "column": "Calendar Day Of Year", "dim": "[ATTENDED DATE.Calendar Day Of Year]", "datatype": "numeric", "title": "Calendar Day Of Year" }, "[74DC6-B12]": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID" }, "[85F1C-828]": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "[589D6-C28]": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Constituents w2 Visits" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true } }, "field": { "id": "[CONSTITUENT.Constituent ID]_count", "index": 1 } } ] }, { "name": "min", "items": [] }, { "name": "max", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Attended Date Year", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1900" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Type", "dim": "[CONSTITUENT.Type]", "datatype": "text", "merged": true, "title": "Type", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "General Public" ] } }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent Display Name", "dim": "[CONSTITUENT.Constituent Display Name]", "datatype": "text", "merged": true, "title": "Constituent Display Name", "filter": { "explicit": true, "multiSelection": true, "members": [ "Adriane Brown" ] }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" } }, "disabled": 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": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "attended_date_year", "title": "Attended Date Year", "singular": "Attended Date Year", "plural": "Attended Date Year" }, { "id": "type", "title": "Type", "singular": "Type", "plural": "Type" }, { "id": "constituent_display_name", "title": "Constituent Display Name", "singular": "Constituent Display Name", "plural": "Constituent Display Name" } ] }, "indicator/numeric": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } }, "indicator/gauge": { "subtype": "round", "skin": "1", "components": { "ticks": { "inactive": false, "enabled": true }, "labels": { "inactive": false, "enabled": true }, "title": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } } }, "instanceid": "423BA-93C2-E1", "queryStartTime": "2024-01-30T09:10:46", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": false, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 3, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": true }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "6543f128ad1fd0346c470cc7", "canEditFilters": true, "drawing": true }, { "title": "RICHTEXT_MAIN.TITLE", "type": "richtexteditor", "subtype": "richtexteditor", "oid": "65553f8e82658e4b981e6b66", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CEW-TN-3660/TNHS-Seats and Tickets", "id": "aCEWLQAaTNLQAa3660_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CEW-TN-3660", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [] }, "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": { "content": { "html": "Repeat Cycle - Reporting & Analytics - Forums - Tessitura Network", "vAlign": "valign-middle", "bgColor": "#FFFFFF", "textAlign": "center" } }, "instanceid": "A3956-3D30-C4", "widgetTimingLoged": false, "drawing": true, "realTimeRefreshing": false, "options": { "triggersDomready": true, "hideFromWidgetList": true, "disableExportToCSV": true, "disableExportToImage": true, "toolbarButton": { "css": "add-rich-text", "tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON" }, "selector": false, "disallowSelector": true, "disallowWidgetTitle": true, "supportsHierarchies": false, "dashboardFiltersMode": "filter" }, "dashboardid": "6543f128ad1fd0346c470cc7" } ], "hierarchies": [] }