{ "title": "COVID-19 Returns Budget Impact", "desc": "", "source": "5e693c8d448663025c974c3e", "type": "dashboard", "style": { "name": "vivid", "palette": { "_id": "5c34f334bda9c409103dfb2e", "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "isDefault": true, "sortOrder": 0 } }, "layout": { "instanceid": "39F9D-9ADB-23", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "672px", "defaultWidth": 512, "widgetid": "5e6bc213448663025c97664f" } ], "width": 100, "stretchable": false, "pxlWidth": 1414, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5e6bc213448663025c976650", "height": "544px" } ], "width": 100, "stretchable": false, "pxlWidth": 1414, "index": 0 } ] } ], "pxlWidth": 1414, "index": 0 } ], "container": {} }, "original": null, "oid": "5e6bc213448663025c97664e", "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance" }, "editing": false, "parentFolder": null, "isPublic": null, "defaultFilters": null, "widgets": [ { "title": "Budget Impact: Ticket Returns", "subtype": "pivot", "desc": null, "source": "5e693c8d448663025c974c3f", "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE.Date1 (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Event Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true }, "subtotal": false }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE.Date1 (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Event" }, "field": { "id": "[PERFORMANCE DETAIL.Production Season]", "index": 1 }, "format": { "members": { "Gary Younge 19-20": { "color": "#547A94", "title": "Gary Younge 19-20", "sortData": "Gary Younge 19-20", "inResultset": true }, "Academy of St Martin 19-20": { "color": "#F48E06", "title": "Academy of St Martin 19-20", "sortData": "Academy of St Martin 19-20", "inResultset": true }, "San Francisco Symphony 19-20": { "color": "#DB4935", "title": "San Francisco Symphony 19-20", "sortData": "San Francisco Symphony 19-20", "inResultset": true }, "Melissa Aldana Quartet 19-20": { "color": "#333333", "title": "Melissa Aldana Quartet 19-20", "sortData": "Melissa Aldana Quartet 19-20", "inResultset": true }, "Sharon Shannon 19-20": { "color": "#008775", "title": "Sharon Shannon 19-20", "sortData": "Sharon Shannon 19-20", "inResultset": true }, "Guy, Vaughan, Musselwhite": { "color": "#618caa", "title": "Guy, Vaughan, Musselwhite", "sortData": "Guy, Vaughan, Musselwhite", "inResultset": true }, "Lara Downes and Judy Collins": { "color": "#ff9b16", "title": "Lara Downes and Judy Collins", "sortData": "Lara Downes and Judy Collins", "inResultset": true }, "Tania Perez-Salas 19-20": { "color": "#fc543d", "title": "Tania Perez-Salas 19-20", "sortData": "Tania Perez-Salas 19-20", "inResultset": true }, "Malpaso Dance Company 19-20": { "color": "#3b3b3b", "title": "Malpaso Dance Company 19-20", "sortData": "Malpaso Dance Company 19-20", "inResultset": true }, "Yumi Kurosawa 19-20": { "color": "#009b87", "title": "Yumi Kurosawa 19-20", "sortData": "Yumi Kurosawa 19-20", "inResultset": true }, "Les Ballets Trockadero 19-20": { "color": "#6897b7", "title": "Les Ballets Trockadero 19-20", "sortData": "Les Ballets Trockadero 19-20", "inResultset": true }, "Mnozil Brass 19-20": { "color": "#ffa022", "title": "Mnozil Brass 19-20", "sortData": "Mnozil Brass 19-20", "inResultset": true }, "Cécile McLorin Salvant 19-20": { "color": "#ff5d47", "title": "Cécile McLorin Salvant 19-20", "sortData": "Cécile McLorin Salvant 19-20", "inResultset": true }, "Dreamers' Circus 19-20": { "color": "#3f3f3f", "title": "Dreamers' Circus 19-20", "sortData": "Dreamers' Circus 19-20", "inResultset": true }, "Alfredo Rodriquez 19-20": { "color": "#00a790", "title": "Alfredo Rodriquez 19-20", "sortData": "Alfredo Rodriquez 19-20", "inResultset": true }, "Maggie Haberman 19-20": { "color": "#6fa1c3", "title": "Maggie Haberman 19-20", "sortData": "Maggie Haberman 19-20", "inResultset": true }, "Cho-Liang Lin 19-20": { "color": "#ffa62e", "title": "Cho-Liang Lin 19-20", "sortData": "Cho-Liang Lin 19-20", "inResultset": true }, "Sandbox Percussion 19-20": { "color": "#ff6752", "title": "Sandbox Percussion 19-20", "sortData": "Sandbox Percussion 19-20", "inResultset": true }, "Rosie Kay Dance Company 19-20": { "color": "#434343", "title": "Rosie Kay Dance Company 19-20", "sortData": "Rosie Kay Dance Company 19-20", "inResultset": true }, "Vladimir Feltsman 19-20": { "color": "#00b29a", "title": "Vladimir Feltsman 19-20", "sortData": "Vladimir Feltsman 19-20", "inResultset": true }, "Bokante 19-20": { "color": "#74a9cd", "title": "Bokante 19-20", "sortData": "Bokante 19-20", "inResultset": true }, "Yamato 19-20": { "color": "#ffaa38", "title": "Yamato 19-20", "sortData": "Yamato 19-20", "inResultset": true }, "Vera Quartet - Sensory 19-20": { "color": "#ff6f5b", "title": "Vera Quartet - Sensory 19-20", "sortData": "Vera Quartet - Sensory 19-20", "inResultset": true }, "Alexander String Quartet 19-20": { "color": "#474747", "title": "Alexander String Quartet 19-20", "sortData": "Alexander String Quartet 19-20", "inResultset": true }, "Ladysmith - Sensory 19-20": { "color": "#00bba2", "title": "Ladysmith - Sensory 19-20", "sortData": "Ladysmith - Sensory 19-20", "inResultset": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "sum([E2DBA-F62]) ", "context": { "[E2DBA-F62]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Ticket Returns", "subtotalAgg": "sum" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([E2DBA-F62]) ", "index": 2 } }, { "jaql": { "type": "measure", "formula": "sum([63E39-400])", "context": { "[63E39-400]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "title": "Budget Amount" } }, "title": "Budget Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 0, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([63E39-400])", "index": 3 } }, { "jaql": { "type": "measure", "formula": "ABS(sum([5C008-604])) /([9FE24-77A])", "context": { "[5C008-604]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" }, "[9FE24-77A]": { "table": "PERFORMANCE DETAIL", "column": "Budget Amount", "dim": "[PERFORMANCE DETAIL.Budget Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Budget Amount" } }, "title": "% Loss of Budget" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "ABS(sum([5C008-604])) /([9FE24-77A])", "index": 4 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "19-20 Mondavi Center" ] }, "collapsed": false, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" } } }, { "jaql": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-02-27", "to": "2020-06-30" }, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } }, { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticket Refund", "Ticket Change", "Zero Adjustment" ] }, "collapsed": false, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" } }, "title": "Transaction Type" } ] } ] }, "oid": "5e6bc213448663025c97664f", "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": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "event", "title": "Event", "singular": "Event", "plural": "Event" }, { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "transaction_type", "title": "Transaction Type", "singular": "Transaction Type", "plural": "Transaction Type" } ] }, "rowsGrandTotal": true }, "instanceid": "7E483-06B8-8D", "queryStartTime": "2020-03-11T18:14:06", "currentPage": 0, "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5e6bc213448663025c97664e", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true }, { "title": "Refunds by Performance", "subtype": "bar/classic", "desc": null, "source": "5e693c8d448663025c974c40", "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "sum([E2DBA-F62]) ", "context": { "[E2DBA-F62]": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Ticket $" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } }, "field": { "id": "sum([E2DBA-F62]) ", "index": 5 } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type" }, "format": { "members": { "Ticket Change": { "color": "#547A94", "title": "Ticket Change", "sortData": "Ticket Change", "inResultset": true }, "Ticket Refund": { "color": "#F48E06", "title": "Ticket Refund", "sortData": "Ticket Refund", "inResultset": true } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "SEASON", "column": "Season", "dim": "[SEASON.Season]", "datatype": "text", "merged": true, "title": "Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "19-20 Mondavi Center" ] }, "collapsed": false, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" } } }, { "jaql": { "table": "TRANSACTION DATE", "column": "Date", "dim": "[TRANSACTION DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2020-02-27", "to": "2020-06-30" }, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" }, "collapsed": true }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } }, { "jaql": { "table": "FINANCE DETAILS", "column": "Transaction Type", "dim": "[FINANCE DETAILS.Transaction Type]", "datatype": "text", "merged": true, "title": "Transaction Type", "filter": { "explicit": true, "multiSelection": true, "members": [ "Ticket Refund", "Ticket Change", "Zero Adjustment" ] }, "collapsed": false, "datasource": { "title": "UCDA-Finance", "fullname": "nauCUBEBP001.KRIOSTESS.local/UCDA-Finance", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aUCDALQAaFINANCE", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aUCDALQAaFinance", "lastBuildTime": "2020-03-11T01:09:35" } }, "title": "Transaction Type" } ] } ] }, "oid": "5e6bc213448663025c976650", "type": "chart/bar", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "legend": { "enabled": true, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "hideMinMax": false }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "navigator": { "enabled": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "production", "title": "Production", "singular": "Production", "plural": "Production" }, { "id": "transaction_type", "title": "Transaction Type", "singular": "Transaction Type", "plural": "Transaction Type" }, { "id": "season", "title": "Season", "singular": "Season", "plural": "Season" }, { "id": "days", "title": "days", "singular": "days", "plural": "days" } ] } }, "instanceid": "D659F-2FE9-75", "queryStartTime": "2020-03-11T16:05:21", "currentPage": 4, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5e6bc213448663025c97664e", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "drawing": true, "disableSelctor": false, "continuousDates": false, "nullAsZero": false, "minDate": 1581660000000, "maxDate": 1591506000000, "tickInterval": 86400000, "tickLevel": "day", "forcedRedraw": false, "chart": { "0": {}, "context": {}, "length": 1 }, "canEditFilters": true } ], "hierarchies": [] }