{ "title": "COVID-19 Returns by TICKETS example", "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": "36F0A-1A7C-1E", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5ec5342f27733b0ffc345339", "height": "104px" } ], "width": 74.36399217221134, "stretchable": false, "pxlWidth": 1063, "index": 0 }, { "elements": [ { "minHeight": 64, "maxHeight": 1028, "height": "104px", "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5ec5342f27733b0ffc34533a" } ], "width": 25.63600782778866, "stretchable": false, "pxlWidth": 367, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5ec5342f27733b0ffc345337", "height": 512 } ], "width": 100, "stretchable": false, "pxlWidth": 1430, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5ec5342f27733b0ffc345341", "height": 512 } ], "width": 51.60839160839161, "stretchable": false, "pxlWidth": 738, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 512, "defaultWidth": 512, "widgetid": "5ec5342f27733b0ffc345334" } ], "width": 50, "stretchable": false, "pxlWidth": 715, "index": 1 } ] } ], "pxlWidth": 1430, "index": 0 } ], "container": {} }, "original": null, "oid": "5ec5342f27733b0ffc34532f", "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance" }, "editing": true, "isPublic": null, "filters": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-25T11:57:47" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Miwa Matreyek FY20", "American Classics FY20", "Russian National Ballet FY20", "Las Cafeteras FY20", "Bravo, Britain FY20", "Queens of Soul FY20", "Blue Man Group FY20", "Celtic Woman FY20", "Beach Boys FY21", "Bach Birthday Bash FY20", "Lewis Black FY21", "Nate Bargatze FY20", "Baby Shark Live FY20", "The Snowy Day FY20", "New York Phil String Qrt FY20", "Baby Shark Live FY21", "Baby Shark VIP UPGRADE FY21", "Bach Birthday Bash FY21", "ICE FY20", "Requiem Electric Chair FY20", "Verdi's Requiem SUN FY20", "Verdi's Requiem TUES FY20", "Classic Broadway FY20", "Superhero Symphony FY20", "Nate Bargatze FY21", "The Flying Dutchman FY22", "Shen Yun FY21", "Chicago FY20", "Lyle Lovett/John Hiatt FY20", "Music of John Williams FY20", "Brahms' Fourth FY20", "Alan Cumming Ari Shapiro FY21", "Kevin James FY20", "Alan Cumming Ari Shapiro FY22", "Kevin James FY21" ] } }, "instanceid": "DDDFF-58DD-E6", "isCascading": false, "disabled": false }, { "jaql": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date - from first day of returns", "level": "days", "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-25T11:57:47" }, "collapsed": true, "filter": { "from": "2020-03-13" } }, "instanceid": "A03E6-746B-0A", "isCascading": false, "disabled": false }, { "jaql": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount", "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-25T11:57:47" }, "collapsed": false, "filter": { "toNotEqual": "0" } }, "instanceid": "EC90E-8E29-A7", "isCascading": false, "disabled": false }, { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type", "collapsed": false, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-25T23:19:23" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticket Change", "Ticket Refund" ] } }, "instanceid": "441F8-54EA-DE", "isCascading": false, "disabled": false } ], "filterToDatasourceMapping": {}, "parentFolder": "5e7cfcd9645d2321b063997b", "widgets": [ { "title": "Tickets remaining in cancelled shows", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "PTIX-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-05-18T23:52:05" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "field": { "id": "[PERFORMANCE DETAIL.Production Season]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 1 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Count]_sum", "index": 2 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "Celtic Woman FY20", "American Classics FY20", "Queens of Soul FY20", "Bravo, Britain FY20", "Miwa Matreyek FY20", "The Snowy Day FY20", "Las Cafeteras FY20", "Russian National Ballet FY20", "Blue Man Group FY20", "New York Phil String Qrt FY20", "ICE FY20", "Requiem Electric Chair FY20", "Verdi's Requiem SUN FY20", "Verdi's Requiem TUES FY20", "Classic Broadway FY20", "Superhero Symphony FY20", "Lyle Lovett/John Hiatt FY20", "Music of John Williams FY20", "Brahms' Fourth FY20", "Chicago FY20" ] }, "collapsed": true, "datasource": { "title": "PTIX-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-05-04T23:57:03" } } } ] } ] }, "oid": "5ec5342f27733b0ffc345334", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" } ] }, "rowsGrandTotal": true }, "instanceid": "3FE8C-398F-85", "queryStartTime": "2020-05-19T08:34:35", "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 }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "5ec5342f27733b0ffc34532f", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "canEditFilters": true }, { "title": "Progress so far (by $) - CANCELLED ONLY", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-22T23:42:56" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "field": { "index": 0 }, "disabled": true }, { "jaql": { "table": "BATCH", "column": "Batch Type", "dim": "[BATCH.Batch Type]", "datatype": "text", "merged": true, "title": "Batch Type" }, "field": { "id": "[BATCH.Batch Type]", "index": 0 }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "1148606.8", "context": {}, "title": "Original Ticket Amt" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" }, "width": 109 }, "field": { "id": "1148606.8", "index": 1 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "sum([CCD0C-2EC])", "context": { "[CCD0C-2EC]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Ticket Paid Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "#ffffff" }, "width": 112 }, "field": { "id": "sum([CCD0C-2EC])", "index": 2 } }, { "jaql": { "type": "measure", "formula": "(1148606.8-(1148606.8+(sum([DD8C6-98C]))))/1148606.8", "context": { "[DD8C6-98C]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Percent processed" }, "format": { "mask": { "decimals": 2, "percent": true }, "width": 98, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(1148606.8-(1148606.8+(sum([DD8C6-98C]))))/1148606.8", "index": 3 } }, { "jaql": { "type": "measure", "formula": "1148606.8+(sum([ED313-3B5]))", "context": { "[ED313-3B5]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Amt remaining to process" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "width": 108, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "1148606.8+(sum([ED313-3B5]))", "index": 4 } }, { "jaql": { "type": "measure", "formula": "(sum([DA64D-9E5]))/([DD27E-30E])-((sum([DA64D-9E5]))/([DD27E-30E]-1)*2)", "context": { "[DD27E-30E]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "agg": "count", "title": "# of unique Days in Date" }, "[DA64D-9E5]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Avg. amt processed per day" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "width": 100, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([DA64D-9E5]))/([DD27E-30E])-((sum([DA64D-9E5]))/([DD27E-30E]-1)*2)", "index": 5 } }, { "jaql": { "type": "measure", "formula": "(1148606.8+(sum([AD29B-F21])))/((sum([AD29B-F21]))/([EA6B8-CEA])-((sum([AD29B-F21]))/([EA6B8-CEA]-1)*2))", "context": { "[EA6B8-CEA]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "agg": "count", "title": "# of unique Days in Date" }, "[AD29B-F21]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Est. Days to process remainder" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "number": { "separated": true } }, "width": 96, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(1148606.8+(sum([AD29B-F21])))/((sum([AD29B-F21]))/([EA6B8-CEA])-((sum([AD29B-F21]))/([EA6B8-CEA]-1)*2))", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "American Classics FY20", "Miwa Matreyek FY20", "Las Cafeteras FY20", "Russian National Ballet FY20", "Queens of Soul FY20", "Bravo, Britain FY20", "Blue Man Group FY20", "The Snowy Day FY20", "Celtic Woman FY20", "Lewis Black FY21", "Nate Bargatze FY20", "New York Phil String Qrt FY20", "ICE FY20", "Requiem Electric Chair FY20", "Verdi's Requiem TUES FY20", "Verdi's Requiem SUN FY20", "Classic Broadway FY20", "Superhero Symphony FY20", "Music of John Williams FY20", "Brahms' Fourth FY20", "Lyle Lovett/John Hiatt FY20", "Chicago FY20" ], "filter": { "turnedOff": true, "exclude": { "members": [ "Lewis Black FY21", "Nate Bargatze FY20", "ICE FY20", "Requiem Electric Chair FY20" ] } } }, "collapsed": true, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-22T23:42:56" } } } ] } ] }, "oid": "5ec5342f27733b0ffc345337", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" }, { "id": "batch_type", "title": "Batch Type", "singular": "Batch Type", "plural": "Batch Type" } ] }, "rowsGrandTotal": true }, "instanceid": "C41D2-C3E8-C6", "queryStartTime": "2020-05-05T11:53:40", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": 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, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5ec5342f27733b0ffc34532f", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "Progress so far (by # tix) - Cancelled only (AVG per day & Est. Days remaining is MANUAL # days)", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "PTIX-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-03-25T23:27:27" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year" }, "field": { "id": "[SEASON.Season Fiscal Year]", "index": 0 }, "format": { "width": 100 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "field": { "index": 1 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "21586", "context": {}, "title": "Original # of tix" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 97 }, "field": { "id": "21586", "index": 1 } }, { "jaql": { "type": "measure", "formula": "21586-([8BD66-ECB])", "context": { "[8BD66-ECB]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" } }, "title": "# tix processed" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 118 }, "field": { "id": "21586-([8BD66-ECB])", "index": 2 } }, { "jaql": { "type": "measure", "formula": "sum([392D1-87C])", "context": { "[392D1-87C]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "title": "Ticket Paid Count" } }, "title": "# tickets remaining" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 103 }, "field": { "id": "sum([392D1-87C])", "index": 3 } }, { "jaql": { "type": "measure", "formula": "(21586-([5291B-B50]))/21586", "context": { "[5291B-B50]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" } }, "title": "% processed" }, "format": { "mask": { "decimals": 2, "percent": true }, "width": 108, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(21586-([5291B-B50]))/21586", "index": 4 } }, { "jaql": { "type": "measure", "formula": "(21586-([9123D-1B9]))/51", "context": { "[9123D-1B9]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" } }, "title": "Avg tix per day -51 DAYS" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "width": 118, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(21586-([9123D-1B9]))/51", "index": 5 } }, { "jaql": { "type": "measure", "formula": "(sum([B89D7-7EA]))/((21586-([724C6-1D9]))/51)", "context": { "[724C6-1D9]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "[B89D7-7EA]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "title": "Ticket Paid Count" } }, "title": "Est. days remaining -51 DAYS" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "width": 103, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([B89D7-7EA]))/((21586-([724C6-1D9]))/51)", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "Celtic Woman FY20", "American Classics FY20", "Queens of Soul FY20", "Bravo, Britain FY20", "Miwa Matreyek FY20", "The Snowy Day FY20", "Las Cafeteras FY20", "Russian National Ballet FY20", "Blue Man Group FY20", "New York Phil String Qrt FY20", "ICE FY20", "Requiem Electric Chair FY20", "Verdi's Requiem SUN FY20", "Verdi's Requiem TUES FY20", "Classic Broadway FY20", "Superhero Symphony FY20", "Lyle Lovett/John Hiatt FY20", "Music of John Williams FY20", "Brahms' Fourth FY20", "Chicago FY20" ], "filter": { "turnedOff": true, "exclude": { "members": [ "ICE FY20", "Requiem Electric Chair FY20" ] } } }, "collapsed": true, "datasource": { "title": "PTIX-Seats and Tickets", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Seats and Tickets", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaSEATSIAAaANDIAAaTICKETS", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2020-03-25T23:27:27" } } } ] } ] }, "oid": "5ec5342f27733b0ffc345339", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "season_fiscal_year", "title": "Season Fiscal Year", "singular": "Season Fiscal Year", "plural": "Season Fiscal Year" }, { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" } ] }, "rowsGrandTotal": true }, "instanceid": "3FE8C-398F-85", "queryStartTime": "2020-05-20T08:48:50", "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "canEditFilters": true, "dashboardid": "5ec5342f27733b0ffc34532f", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true }, { "title": "", "subtype": "indicator/numeric", "desc": null, "source": null, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-25T23:19:23" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "count([032BF-918])-1", "context": { "[032BF-918]": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "#days so far" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#547A94", "type": "color" } }, "hierarchies": [] } ] }, { "name": "secondary", "items": [] }, { "name": "min", "items": [] }, { "name": "max", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "5ec5342f27733b0ffc34533a", "type": "indicator", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } }, "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 } } }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [] } }, "instanceid": "40AAB-52C3-F0", "queryStartTime": "2020-04-02T08:39:47", "drawing": true, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": 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": "5ec5342f27733b0ffc34532f", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false } }, { "title": "Percent progress returned by (by $ - same concept could be used for tickets)", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-22T23:42:56" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type" }, "field": { "id": "[SEASON.Season Type]", "index": 0 }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season" }, "field": { "id": "[PERFORMANCE DETAIL.Production Season]", "index": 1 }, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season ID", "dim": "[PERFORMANCE DETAIL.Production Season ID]", "datatype": "numeric", "title": "Production Season ID" }, "field": { "index": 2 }, "disabled": true } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "CASE \nWHEN [C8C5C-D58]=900 THEN 73723.70\nWHEN [C8C5C-D58]=981 THEN 161808\nWHEN [C8C5C-D58]=905 THEN 66737.2\nWHEN [C8C5C-D58]=1101 THEN 48957.1\nWHEN [C8C5C-D58]=1331 THEN 98380\nWHEN [C8C5C-D58]=1000 THEN 1653.40\nWHEN [C8C5C-D58]=938 THEN 2640.00\nWHEN [C8C5C-D58]=901 THEN 66637.50\nWHEN [C8C5C-D58]=902 THEN 60552.10\nWHEN [C8C5C-D58]=1014 THEN 1774.50\nWHEN [C8C5C-D58]=894 THEN 71428.10\nWHEN [C8C5C-D58]=979 THEN 214384.50\nWHEN [C8C5C-D58]=904 THEN 64401.20\nWHEN [C8C5C-D58]=1209 THEN 67146\nWHEN [C8C5C-D58]=997 THEN 5950.50\nWHEN [C8C5C-D58]=995 THEN 3787.50\nWHEN [C8C5C-D58]=999 THEN 10874.20\nWHEN [C8C5C-D58]=893 THEN 85132.00\nWHEN [C8C5C-D58]=996 THEN 36956.50\nWHEN [C8C5C-D58]=998 THEN 8863.50\nELSE 0\nEND", "context": { "[C8C5C-D58]": { "table": "PERFORMANCE DETAIL", "column": "Production Season ID", "dim": "[PERFORMANCE DETAIL.Production Season ID]", "datatype": "numeric", "agg": "max", "title": "Max Production Season ID" } }, "title": "Original Amt" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "CASE \nWHEN [C8C5C-D58]=900 THEN 73723.70\nWHEN [C8C5C-D58]=981 THEN 161808\nWHEN [C8C5C-D58]=905 THEN 66737.2\nWHEN [C8C5C-D58]=1101 THEN 48957.1\nWHEN [C8C5C-D58]=1331 THEN 98380\nWHEN [C8C5C-D58]=1000 THEN 1653.40\nWHEN [C8C5C-D58]=938 THEN 2640.00\nWHEN [C8C5C-D58]=901 THEN 66637.50\nWHEN [C8C5C-D58]=902 THEN 60552.10\nWHEN [C8C5C-D58]=1014 THEN 1774.50\nWHEN [C8C5C-D58]=894 THEN 71428.10\nWHEN [C8C5C-D58]=979 THEN 214384.50\nWHEN [C8C5C-D58]=904 THEN 64401.20\nWHEN [C8C5C-D58]=1209 THEN 67146\nWHEN [C8C5C-D58]=997 THEN 5950.50\nWHEN [C8C5C-D58]=995 THEN 3787.50\nWHEN [C8C5C-D58]=999 THEN 10874.20\nWHEN [C8C5C-D58]=893 THEN 85132.00\nWHEN [C8C5C-D58]=996 THEN 36956.50\nWHEN [C8C5C-D58]=998 THEN 8863.50\nELSE 0\nEND", "index": 2 } }, { "jaql": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Returned Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "#e6e6e6" }, "width": 116 }, "field": { "id": "[FINANCE VALUES.Ticket Paid Amount]_sum", "index": 3 } }, { "jaql": { "type": "measure", "formula": "((CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)-((CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)+[395C8-01B]))/(CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)", "context": { "[395C8-01B]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[65218-D96]": { "table": "PERFORMANCE DETAIL", "column": "Production Season ID", "dim": "[PERFORMANCE DETAIL.Production Season ID]", "datatype": "numeric", "agg": "max", "title": "Max Production Season ID" } }, "title": "Percent returned" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" }, "width": 87 }, "field": { "id": "((CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)-((CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)+[395C8-01B]))/(CASE \nWHEN [65218-D96]=900 THEN 73723.70\nWHEN [65218-D96]=905 THEN 66737.2\nWHEN [65218-D96]=1101 THEN 48957.1\nWHEN [65218-D96]=1331 THEN 98380\nWHEN [65218-D96]=1000 THEN 1653.40\nWHEN [65218-D96]=981 THEN 161808\nWHEN [65218-D96]=938 THEN 2640.00\nWHEN [65218-D96]=901 THEN 66637.50\nWHEN [65218-D96]=902 THEN 60552.10\nWHEN [65218-D96]=1014 THEN 1774.50\nWHEN [65218-D96]=894 THEN 71428.10\nWHEN [65218-D96]=979 THEN 214384.50\nWHEN [65218-D96]=904 THEN 64401.20\nWHEN [65218-D96]=1209 THEN 67146\nWHEN [65218-D96]=997 THEN 5950.50\nWHEN [65218-D96]=995 THEN 3787.50\nWHEN [65218-D96]=999 THEN 10874.20\nWHEN [65218-D96]=893 THEN 85132.00\nWHEN [65218-D96]=996 THEN 36956.50\nWHEN [65218-D96]=998 THEN 8863.50\nELSE 0\nEND)", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "American Classics FY20", "Blue Man Group FY20", "Bravo, Britain FY20", "Celtic Woman FY20", "Las Cafeteras FY20", "Miwa Matreyek FY20", "New York Phil String Qrt FY20", "Queens of Soul FY20", "Russian National Ballet FY20", "The Snowy Day FY20", "ICE FY20", "Requiem Electric Chair FY20", "Verdi's Requiem SUN FY20", "Verdi's Requiem TUES FY20", "Classic Broadway FY20", "Superhero Symphony FY20", "Lyle Lovett/John Hiatt FY20", "Music of John Williams FY20", "Brahms' Fourth FY20", "Chicago FY20" ], "filter": { "turnedOff": true, "exclude": { "members": [ "ICE FY20", "Requiem Electric Chair FY20" ] } } }, "collapsed": true, "datasource": { "title": "PTIX-Finance", "fullname": "NARCUBEBP010.KRIOSTESS.local/PTIX-Finance", "id": "aNARCUBEBP010LgAaKRIOSTESSLgAaLOCAL_aPTIXLQAaFINANCE", "address": "NARCUBEBP010.KRIOSTESS.local", "database": "aPTIXLQAaFinance", "lastBuildTime": "2020-03-22T23:42:56" } } } ] } ] }, "oid": "5ec5342f27733b0ffc345341", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "season_type", "title": "Season Type", "singular": "Season Type", "plural": "Season Type" }, { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" }, { "id": "production_season_id", "title": "Production Season ID", "singular": "Production Season ID", "plural": "Production Season ID" } ] }, "rowsGrandTotal": false }, "instanceid": "C41D2-C3E8-C6", "queryStartTime": "2020-05-20T08:44:18", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": 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, "viewState": { "activeTab": "filters" }, "canEditFilters": true, "dashboardid": "5ec5342f27733b0ffc34532f", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "selectorLocked": false }, "drawing": true } ], "hierarchies": [] }