{ "title": "Performance Calendar Heatmaps", "oid": "65035b67645bf74bb455f8d7", "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": "F7AE7-1F64-10", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 182, "maxHeight": 1000, "minWidth": 150, "maxWidth": 1000, "height": 640, "defaultWidth": 512, "widgetid": "65035ba6645bf74bb455f8da" } ], "width": 25, "stretchable": false, "pxlWidth": 459, "index": 0 }, { "elements": [ { "minHeight": 182, "maxHeight": 1000, "minWidth": 150, "maxWidth": 1000, "defaultWidth": 512, "widgetid": "65035c01645bf74bb455f8dc", "height": 640 } ], "width": 25, "stretchable": false, "pxlWidth": 459, "index": 1 }, { "elements": [ { "minHeight": 182, "maxHeight": 1000, "minWidth": 150, "maxWidth": 1000, "defaultWidth": 512, "widgetid": "65035c28645bf74bb455f8e0", "height": 640 } ], "width": 25, "stretchable": false, "pxlWidth": 459, "index": 2 } ] }, { "subcells": [ { "elements": [ { "minHeight": 256, "maxHeight": 2048, "minWidth": 256, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "65035e7e645bf74bb455f8ec", "height": "640px" } ], "width": 50, "stretchable": false, "pxlWidth": 917, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "65035ecd645bf74bb455f8f1", "height": "640px", "autoHeight": "650px" } ], "width": 50, "stretchable": false, "pxlWidth": 917, "index": 1 } ] } ], "pxlWidth": 0, "index": 0 } ], "container": { "sizzle1694718816146": { "undefined": { "parentNode": [ 1306.8262132372704, 33, true ] } } } }, "original": null, "dataExploration": false, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets" }, "filters": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Months in Date", "level": "months", "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T14:37:38.871Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2023-12-01T00:00:00" ] } }, "instanceid": "7E31D-3DFA-C8", "isCascading": false } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "widgets": [ { "title": "Daily All", "subtype": "heatmap", "oid": "65035ba6645bf74bb455f8da", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "date", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "color", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "max": "#436276", "min": "#6592b2", "rangeMode": "both", "type": "range", "steps": 9 } } } ] }, { "name": "filters", "items": [] } ] }, "type": "heatmap", "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": { "domain/month": true, "domain/quarter": false, "domain/half-year": false, "domain/year": false, "week/sunday": true, "week/monday": false, "grayoutEnabled": false, "orient/horizontal": true, "orient/vertical": false, "dayNumberEnabled": true, "dayNameEnabled": true, "view/monthly": true, "view/weekly": false, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days_in_date", "title": "Days in Date", "singular": "Days in Date", "plural": "Days in Date" } ] } }, "instanceid": "59DC8-6D66-43", "queryStartTime": "2023-09-14T15:14:35", "widgetTimingLoged": false, "drawing": true, "continuousDates": false, "nullAsZero": false, "minDate": 1701406800000, "maxDate": 1703998800000, "tickLevel": "day", "forcedRedraw": false, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "triggersDomready": true, "selector": true, "disallowSelector": false, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "65035b67645bf74bb455f8d7" }, { "title": "Daily Evening Only", "subtype": "heatmap", "oid": "65035c01645bf74bb455f8dc", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "date", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "color", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "max": "#436276", "min": "#6592b2", "rangeMode": "both", "type": "range", "steps": 9 }, "color": { "max": "#436276", "min": "#6592b2", "rangeMode": "both", "type": "range", "steps": 9 } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Time Slot", "dim": "[PERFORMANCE DETAIL.Time Slot]", "datatype": "text", "merged": true, "title": "Time Slot", "filter": { "explicit": true, "multiSelection": true, "members": [ "Evening" ] }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" } } } ] } ] }, "type": "heatmap", "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": { "domain/month": true, "domain/quarter": false, "domain/half-year": false, "domain/year": false, "week/sunday": true, "week/monday": false, "grayoutEnabled": false, "orient/horizontal": true, "orient/vertical": false, "dayNumberEnabled": true, "dayNameEnabled": true, "view/monthly": true, "view/weekly": false, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days_in_date", "title": "Days in Date", "singular": "Days in Date", "plural": "Days in Date" }, { "id": "time_slot", "title": "Time Slot", "singular": "Time Slot", "plural": "Time Slot" } ] } }, "instanceid": "59DC8-6D66-43", "queryStartTime": "2023-09-14T15:16:32", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "minDate": 1701493200000, "maxDate": 1703998800000, "tickLevel": "day", "forcedRedraw": false, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "triggersDomready": true, "selector": true, "disallowSelector": false, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "65035b67645bf74bb455f8d7", "canEditFilters": true, "drawing": true, "viewState": { "activeTab": "filters" } }, { "title": "Daily Evening Only", "subtype": "treemap", "oid": "65035c28645bf74bb455f8e0", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "hierarchies": [ "calendar", "calendar - weeks" ] }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" } } ] }, { "name": "size", "items": [] }, { "name": "color", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "steps": 9, "min": "#6592b2", "max": "#db4935", "minvalue": null, "midvalue": null, "maxvalue": null, "minValueValid": true, "midValueValid": true, "maxValueValid": true, "type": "range", "rangeMode": "both" } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Time Slot", "dim": "[PERFORMANCE DETAIL.Time Slot]", "datatype": "text", "merged": true, "title": "Time Slot", "filter": { "explicit": true, "multiSelection": true, "members": [ "Evening" ] }, "collapsed": true, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" } } } ] } ] }, "type": "treemap", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "title/1": true, "title/2": true, "title/3": true, "tooltip/value": true, "tooltip/contribution": false, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days_in_date", "title": "Days in Date", "singular": "Days in Date", "plural": "Days in Date" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" }, { "id": "time_slot", "title": "Time Slot", "singular": "Time Slot", "plural": "Time Slot" } ] } }, "instanceid": "87A19-7035-B4", "queryStartTime": "2023-09-14T15:18:33", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "minDate": 1701493200000, "maxDate": 1703998800000, "tickLevel": "day", "forcedRedraw": false, "realTimeRefreshing": false, "canEditFilters": true, "viewState": { "activeTab": "filters" }, "options": { "dashboardFiltersMode": "filter", "triggersDomready": true, "selector": true, "disallowSelector": false, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "dashboardid": "65035b67645bf74bb455f8d7", "drawing": true }, { "title": "Day+Code All", "subtype": "column/polar", "oid": "65035e7e645bf74bb455f8ec", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "yyyy-MM-dd", "minutes": "HH:mm" }, "members": { "2023-12-01": { "color": "#547A94", "title": "2023-12-01", "sortData": "2023-12-01T00:00:00", "inResultset": true }, "2023-12-02": { "color": "#F48E06", "title": "2023-12-02", "sortData": "2023-12-02T00:00:00", "inResultset": true }, "2023-12-03": { "color": "#DB4935", "title": "2023-12-03", "sortData": "2023-12-03T00:00:00", "inResultset": true }, "2023-12-04": { "color": "#333333", "title": "2023-12-04", "sortData": "2023-12-04T00:00:00", "inResultset": true }, "2023-12-05": { "color": "#008775", "title": "2023-12-05", "sortData": "2023-12-05T00:00:00", "inResultset": true }, "2023-12-06": { "color": "#618caa", "title": "2023-12-06", "sortData": "2023-12-06T00:00:00", "inResultset": true }, "2023-12-07": { "color": "#ff9b16", "title": "2023-12-07", "sortData": "2023-12-07T00:00:00", "inResultset": true }, "2023-12-08": { "color": "#fc543d", "title": "2023-12-08", "sortData": "2023-12-08T00:00:00", "inResultset": true }, "2023-12-09": { "color": "#3b3b3b", "title": "2023-12-09", "sortData": "2023-12-09T00:00:00", "inResultset": true }, "2023-12-10": { "color": "#009b87", "title": "2023-12-10", "sortData": "2023-12-10T00:00:00", "inResultset": true }, "2023-12-11": { "color": "#6897b7", "title": "2023-12-11", "sortData": "2023-12-11T00:00:00", "inResultset": true }, "2023-12-12": { "color": "#ffa022", "title": "2023-12-12", "sortData": "2023-12-12T00:00:00", "inResultset": true }, "2023-12-13": { "color": "#ff5d47", "title": "2023-12-13", "sortData": "2023-12-13T00:00:00", "inResultset": true }, "2023-12-14": { "color": "#3f3f3f", "title": "2023-12-14", "sortData": "2023-12-14T00:00:00", "inResultset": true }, "2023-12-15": { "color": "#00a790", "title": "2023-12-15", "sortData": "2023-12-15T00:00:00", "inResultset": true }, "2023-12-16": { "color": "#6fa1c3", "title": "2023-12-16", "sortData": "2023-12-16T00:00:00", "inResultset": true }, "2023-12-17": { "color": "#ffa62e", "title": "2023-12-17", "sortData": "2023-12-17T00:00:00", "inResultset": true }, "2023-12-18": { "color": "#ff6752", "title": "2023-12-18", "sortData": "2023-12-18T00:00:00", "inResultset": true }, "2023-12-19": { "color": "#434343", "title": "2023-12-19", "sortData": "2023-12-19T00:00:00", "inResultset": true }, "2023-12-20": { "color": "#00b29a", "title": "2023-12-20", "sortData": "2023-12-20T00:00:00", "inResultset": true }, "2023-12-21": { "color": "#74a9cd", "title": "2023-12-21", "sortData": "2023-12-21T00:00:00", "inResultset": true }, "2023-12-22": { "color": "#ffaa38", "title": "2023-12-22", "sortData": "2023-12-22T00:00:00", "inResultset": true }, "2023-12-23": { "color": "#ff6f5b", "title": "2023-12-23", "sortData": "2023-12-23T00:00:00", "inResultset": true }, "2023-12-24": { "color": "#474747", "title": "2023-12-24", "sortData": "2023-12-24T00:00:00", "inResultset": true }, "2023-12-25": { "color": "#00bba2", "title": "2023-12-25", "sortData": "2023-12-25T00:00:00", "inResultset": true }, "2023-12-26": { "color": "#79afd5", "title": "2023-12-26", "sortData": "2023-12-26T00:00:00", "inResultset": true }, "2023-12-27": { "color": "#ffad3f", "title": "2023-12-27", "sortData": "2023-12-27T00:00:00", "inResultset": true }, "2023-12-28": { "color": "#ff7461", "title": "2023-12-28", "sortData": "2023-12-28T00:00:00", "inResultset": true }, "2023-12-29": { "color": "#494949", "title": "2023-12-29", "sortData": "2023-12-29T00:00:00", "inResultset": true }, "2023-12-30": { "color": "#00c2a8", "title": "2023-12-30", "sortData": "2023-12-30T00:00:00", "inResultset": true }, "2023-12-31": { "color": "#7cb4db", "title": "2023-12-31", "sortData": "2023-12-31T00:00:00", "inResultset": true } } }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true } } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Code", "dim": "[PERFORMANCE DETAIL.Code]", "datatype": "text", "merged": true, "title": "Code" }, "format": { "members": { "GA120122": { "color": "#547A94", "title": "GA120122", "sortData": "GA120122", "inResultset": true }, "TUR120119": { "color": "#F48E06", "title": "TUR120119", "sortData": "TUR120119", "inResultset": true }, "ART120222": { "color": "#DB4935", "title": "ART120222", "sortData": "ART120222", "inResultset": true }, "AW-120219": { "color": "#333333", "title": "AW-120219", "sortData": "AW-120219", "inResultset": true }, "BFL120219": { "color": "#008775", "title": "BFL120219", "sortData": "BFL120219", "inResultset": true }, "COG120222": { "color": "#618caa", "title": "COG120222", "sortData": "COG120222", "inResultset": true }, "GA120222": { "color": "#ff9b16", "title": "GA120222", "sortData": "GA120222", "inResultset": true }, "HID120219": { "color": "#fc543d", "title": "HID120219", "sortData": "HID120219", "inResultset": true }, "ITD120219": { "color": "#3b3b3b", "title": "ITD120219", "sortData": "ITD120219", "inResultset": true }, "MUS120319": { "color": "#009b87", "title": "MUS120319", "sortData": "MUS120319", "inResultset": true }, "SY120222E": { "color": "#6897b7", "title": "SY120222E", "sortData": "SY120222E", "inResultset": true }, "TUR120219": { "color": "#ffa022", "title": "TUR120219", "sortData": "TUR120219", "inResultset": true }, "ART120319": { "color": "#ff5d47", "title": "ART120319", "sortData": "ART120319", "inResultset": true }, "CB120319": { "color": "#3f3f3f", "title": "CB120319", "sortData": "CB120319", "inResultset": true }, "COG120319": { "color": "#00a790", "title": "COG120319", "sortData": "COG120319", "inResultset": true }, "GA120322": { "color": "#6fa1c3", "title": "GA120322", "sortData": "GA120322", "inResultset": true }, "HIS120319": { "color": "#ffa62e", "title": "HIS120319", "sortData": "HIS120319", "inResultset": true }, "JZ120322E": { "color": "#ff6752", "title": "JZ120322E", "sortData": "JZ120322E", "inResultset": true }, "MAT120319": { "color": "#434343", "title": "MAT120319", "sortData": "MAT120319", "inResultset": true }, "SHA120319": { "color": "#00b29a", "title": "SHA120319", "sortData": "SHA120319", "inResultset": true }, "SY120321E": { "color": "#74a9cd", "title": "SY120321E", "sortData": "SY120321E", "inResultset": true }, "TUR120319": { "color": "#ffaa38", "title": "TUR120319", "sortData": "TUR120319", "inResultset": true }, "AW-120419": { "color": "#ff6f5b", "title": "AW-120419", "sortData": "AW-120419", "inResultset": true }, "BFL120419": { "color": "#474747", "title": "BFL120419", "sortData": "BFL120419", "inResultset": true }, "GA120422": { "color": "#00bba2", "title": "GA120422", "sortData": "GA120422", "inResultset": true }, "HID120419": { "color": "#79afd5", "title": "HID120419", "sortData": "HID120419", "inResultset": true }, "ITD120419": { "color": "#ffad3f", "title": "ITD120419", "sortData": "ITD120419", "inResultset": true }, "JZ120421E": { "color": "#ff7461", "title": "JZ120421E", "sortData": "JZ120421E", "inResultset": true }, "MUS120419": { "color": "#494949", "title": "MUS120419", "sortData": "MUS120419", "inResultset": true }, "SY120421E": { "color": "#00c2a8", "title": "SY120421E", "sortData": "SY120421E", "inResultset": true }, "SY120422M": { "color": "#7cb4db", "title": "SY120422M", "sortData": "SY120422M", "inResultset": true }, "TUR120419": { "color": "#ffaf45", "title": "TUR120419", "sortData": "TUR120419", "inResultset": true }, "GA120522": { "color": "#ff7966", "title": "GA120522", "sortData": "GA120522", "inResultset": true }, "HIS120519": { "color": "#4b4b4b", "title": "HIS120519", "sortData": "HIS120519", "inResultset": true }, "TUR120519": { "color": "#00c7ad", "title": "TUR120519", "sortData": "TUR120519", "inResultset": true }, "AE120419": { "color": "#7fb8df", "title": "AE120419", "sortData": "AE120419", "inResultset": true }, "GA120622": { "color": "#ffb14a", "title": "GA120622", "sortData": "GA120622", "inResultset": true }, "TUR120619": { "color": "#ff7d6b", "title": "TUR120619", "sortData": "TUR120619", "inResultset": true }, "AE120719": { "color": "#4d4d4d", "title": "AE120719", "sortData": "AE120719", "inResultset": true }, "BST120719": { "color": "#00ccb1", "title": "BST120719", "sortData": "BST120719", "inResultset": true }, "GA120722": { "color": "#81bce4", "title": "GA120722", "sortData": "GA120722", "inResultset": true }, "ON-120719": { "color": "#ffb34e", "title": "ON-120719", "sortData": "ON-120719", "inResultset": true }, "PNG120719": { "color": "#ff806f", "title": "PNG120719", "sortData": "PNG120719", "inResultset": true }, "TUR120719": { "color": "#4e4e4e", "title": "TUR120719", "sortData": "TUR120719", "inResultset": true }, "AE120819": { "color": "#00d0b4", "title": "AE120819", "sortData": "AE120819", "inResultset": true }, "GA120822": { "color": "#83bfe7", "title": "GA120822", "sortData": "GA120822", "inResultset": true }, "PNG120821": { "color": "#ffb552", "title": "PNG120821", "sortData": "PNG120821", "inResultset": true }, "PNGM120821": { "color": "#ff8372", "title": "PNGM120821", "sortData": "PNGM120821", "inResultset": true }, "TUR120819": { "color": "#505050", "title": "TUR120819", "sortData": "TUR120819", "inResultset": true }, "ABW120919": { "color": "#00d3b7", "title": "ABW120919", "sortData": "ABW120919", "inResultset": true }, "ART120922": { "color": "#85c1eb", "title": "ART120922", "sortData": "ART120922", "inResultset": true }, "AW-120919": { "color": "#ffb655", "title": "AW-120919", "sortData": "AW-120919", "inResultset": true }, "HAN120922E": { "color": "#ff8575", "title": "HAN120922E", "sortData": "HAN120922E", "inResultset": true }, "HID120919": { "color": "#515151", "title": "HID120919", "sortData": "HID120919", "inResultset": true }, "IMB6MON19": { "color": "#00d6ba", "title": "IMB6MON19", "sortData": "IMB6MON19", "inResultset": true }, "ITD120919": { "color": "#85c1eb", "title": "ITD120919", "sortData": "ITD120919", "inResultset": true }, "MRY120922E": { "color": "#ffb655", "title": "MRY120922E", "sortData": "MRY120922E", "inResultset": true }, "MUS120919": { "color": "#ff8575", "title": "MUS120919", "sortData": "MUS120919", "inResultset": true }, "SY120922E": { "color": "#515151", "title": "SY120922E", "sortData": "SY120922E", "inResultset": true }, "TUR120919": { "color": "#00d6ba", "title": "TUR120919", "sortData": "TUR120919", "inResultset": true }, "ART121019": { "color": "#85c1eb", "title": "ART121019", "sortData": "ART121019", "inResultset": true }, "CB121019": { "color": "#ffb655", "title": "CB121019", "sortData": "CB121019", "inResultset": true }, "F20_A1210": { "color": "#ff8575", "title": "F20_A1210", "sortData": "F20_A1210", "inResultset": true }, "F20_IM1210": { "color": "#515151", "title": "F20_IM1210", "sortData": "F20_IM1210", "inResultset": true }, "F20_ON1210": { "color": "#00d6ba", "title": "F20_ON1210", "sortData": "F20_ON1210", "inResultset": true }, "F20_VA1210": { "color": "#85c1eb", "title": "F20_VA1210", "sortData": "F20_VA1210", "inResultset": true }, "GA121022": { "color": "#ffb655", "title": "GA121022", "sortData": "GA121022", "inResultset": true }, "HAN121021E": { "color": "#ff8575", "title": "HAN121021E", "sortData": "HAN121021E", "inResultset": true }, "HIS121019": { "color": "#515151", "title": "HIS121019", "sortData": "HIS121019", "inResultset": true }, "JZ121022E": { "color": "#00d6ba", "title": "JZ121022E", "sortData": "JZ121022E", "inResultset": true }, "MRY121021E": { "color": "#85c1eb", "title": "MRY121021E", "sortData": "MRY121021E", "inResultset": true }, "MRY121022M": { "color": "#ffb655", "title": "MRY121022M", "sortData": "MRY121022M", "inResultset": true }, "SHA121019": { "color": "#ff8575", "title": "SHA121019", "sortData": "SHA121019", "inResultset": true }, "SY121021E": { "color": "#515151", "title": "SY121021E", "sortData": "SY121021E", "inResultset": true }, "TUR121019": { "color": "#00d6ba", "title": "TUR121019", "sortData": "TUR121019", "inResultset": true }, "AW-121119": { "color": "#85c1eb", "title": "AW-121119", "sortData": "AW-121119", "inResultset": true }, "BZ-121119": { "color": "#ffb655", "title": "BZ-121119", "sortData": "BZ-121119", "inResultset": true }, "F20_S21211": { "color": "#ff8575", "title": "F20_S21211", "sortData": "F20_S21211", "inResultset": true }, "GA121122": { "color": "#515151", "title": "GA121122", "sortData": "GA121122", "inResultset": true }, "HAN121119E": { "color": "#00d6ba", "title": "HAN121119E", "sortData": "HAN121119E", "inResultset": true }, "HAN121121M": { "color": "#85c1eb", "title": "HAN121121M", "sortData": "HAN121121M", "inResultset": true }, "HAN121122M": { "color": "#ffb655", "title": "HAN121122M", "sortData": "HAN121122M", "inResultset": true }, "HID121119": { "color": "#ff8575", "title": "HID121119", "sortData": "HID121119", "inResultset": true }, "IMB6WED19": { "color": "#515151", "title": "IMB6WED19", "sortData": "IMB6WED19", "inResultset": true }, "ITD121119": { "color": "#00d6ba", "title": "ITD121119", "sortData": "ITD121119", "inResultset": true }, "JZ121121E": { "color": "#85c1eb", "title": "JZ121121E", "sortData": "JZ121121E", "inResultset": true }, "MRY121121E": { "color": "#ffb655", "title": "MRY121121E", "sortData": "MRY121121E", "inResultset": true }, "MRY121121M": { "color": "#ff8575", "title": "MRY121121M", "sortData": "MRY121121M", "inResultset": true }, "MUS121119": { "color": "#515151", "title": "MUS121119", "sortData": "MUS121119", "inResultset": true }, "SY121121E": { "color": "#00d6ba", "title": "SY121121E", "sortData": "SY121121E", "inResultset": true }, "SY121122M": { "color": "#85c1eb", "title": "SY121122M", "sortData": "SY121122M", "inResultset": true }, "TUR121119": { "color": "#ffb655", "title": "TUR121119", "sortData": "TUR121119", "inResultset": true }, "GA121222": { "color": "#ff8575", "title": "GA121222", "sortData": "GA121222", "inResultset": true }, "HIS121219": { "color": "#515151", "title": "HIS121219", "sortData": "HIS121219", "inResultset": true }, "IMI6THU19": { "color": "#00d6ba", "title": "IMI6THU19", "sortData": "IMI6THU19", "inResultset": true }, "TUR121219": { "color": "#85c1eb", "title": "TUR121219", "sortData": "TUR121219", "inResultset": true }, "ABD121319": { "color": "#ffb655", "title": "ABD121319", "sortData": "ABD121319", "inResultset": true }, "AE121319": { "color": "#ff8575", "title": "AE121319", "sortData": "AE121319", "inResultset": true }, "GA121322": { "color": "#515151", "title": "GA121322", "sortData": "GA121322", "inResultset": true }, "IMA6FRI19": { "color": "#00d6ba", "title": "IMA6FRI19", "sortData": "IMA6FRI19", "inResultset": true }, "TUR121319": { "color": "#85c1eb", "title": "TUR121319", "sortData": "TUR121319", "inResultset": true }, "ABD121419": { "color": "#ffb655", "title": "ABD121419", "sortData": "ABD121419", "inResultset": true }, "AE121419": { "color": "#ff8575", "title": "AE121419", "sortData": "AE121419", "inResultset": true }, "BST121419": { "color": "#515151", "title": "BST121419", "sortData": "BST121419", "inResultset": true }, "GA121422": { "color": "#00d6ba", "title": "GA121422", "sortData": "GA121422", "inResultset": true }, "TUR121419": { "color": "#85c1eb", "title": "TUR121419", "sortData": "TUR121419", "inResultset": true }, "ABD121519": { "color": "#ffb655", "title": "ABD121519", "sortData": "ABD121519", "inResultset": true }, "AE121519": { "color": "#ff8575", "title": "AE121519", "sortData": "AE121519", "inResultset": true }, "GA121522": { "color": "#515151", "title": "GA121522", "sortData": "GA121522", "inResultset": true }, "SY121522E": { "color": "#00d6ba", "title": "SY121522E", "sortData": "SY121522E", "inResultset": true }, "TUR121519": { "color": "#85c1eb", "title": "TUR121519", "sortData": "TUR121519", "inResultset": true }, "ABD121619": { "color": "#ffb655", "title": "ABD121619", "sortData": "ABD121619", "inResultset": true }, "AW-121619": { "color": "#ff8575", "title": "AW-121619", "sortData": "AW-121619", "inResultset": true }, "BFL121619": { "color": "#515151", "title": "BFL121619", "sortData": "BFL121619", "inResultset": true }, "CHI121622E": { "color": "#00d6ba", "title": "CHI121622E", "sortData": "CHI121622E", "inResultset": true }, "GA121622": { "color": "#85c1eb", "title": "GA121622", "sortData": "GA121622", "inResultset": true }, "HID121619": { "color": "#ffb655", "title": "HID121619", "sortData": "HID121619", "inResultset": true }, "ITD121619": { "color": "#ff8575", "title": "ITD121619", "sortData": "ITD121619", "inResultset": true }, "MUS121619": { "color": "#515151", "title": "MUS121619", "sortData": "MUS121619", "inResultset": true }, "RTE121622E": { "color": "#00d6ba", "title": "RTE121622E", "sortData": "RTE121622E", "inResultset": true }, "SY121620E": { "color": "#85c1eb", "title": "SY121620E", "sortData": "SY121620E", "inResultset": true }, "TUR121619": { "color": "#ffb655", "title": "TUR121619", "sortData": "TUR121619", "inResultset": true }, "ABD121719": { "color": "#ff8575", "title": "ABD121719", "sortData": "ABD121719", "inResultset": true }, "BDAYPARTY1": { "color": "#515151", "title": "BDAYPARTY1", "sortData": "BDAYPARTY1", "inResultset": true }, "CB121719": { "color": "#00d6ba", "title": "CB121719", "sortData": "CB121719", "inResultset": true }, "CHI121721E": { "color": "#85c1eb", "title": "CHI121721E", "sortData": "CHI121721E", "inResultset": true }, "CHI121722M": { "color": "#ffb655", "title": "CHI121722M", "sortData": "CHI121722M", "inResultset": true }, "GA121722": { "color": "#ff8575", "title": "GA121722", "sortData": "GA121722", "inResultset": true }, "HIS121719": { "color": "#515151", "title": "HIS121719", "sortData": "HIS121719", "inResultset": true }, "JZ121722E": { "color": "#00d6ba", "title": "JZ121722E", "sortData": "JZ121722E", "inResultset": true }, "MAT121719": { "color": "#85c1eb", "title": "MAT121719", "sortData": "MAT121719", "inResultset": true }, "RTE121721E": { "color": "#ffb655", "title": "RTE121721E", "sortData": "RTE121721E", "inResultset": true }, "RTE121722M": { "color": "#ff8575", "title": "RTE121722M", "sortData": "RTE121722M", "inResultset": true }, "SY121721E": { "color": "#515151", "title": "SY121721E", "sortData": "SY121721E", "inResultset": true }, "TUR121719": { "color": "#00d6ba", "title": "TUR121719", "sortData": "TUR121719", "inResultset": true }, "BDAYPARTY4": { "color": "#85c1eb", "title": "BDAYPARTY4", "sortData": "BDAYPARTY4", "inResultset": true }, "CHI121821E": { "color": "#ffb655", "title": "CHI121821E", "sortData": "CHI121821E", "inResultset": true }, "CHI121821M": { "color": "#ff8575", "title": "CHI121821M", "sortData": "CHI121821M", "inResultset": true }, "GA121822": { "color": "#515151", "title": "GA121822", "sortData": "GA121822", "inResultset": true }, "JZ121821E": { "color": "#00d6ba", "title": "JZ121821E", "sortData": "JZ121821E", "inResultset": true }, "RTE121821E": { "color": "#85c1eb", "title": "RTE121821E", "sortData": "RTE121821E", "inResultset": true }, "RTE121821M": { "color": "#ffb655", "title": "RTE121821M", "sortData": "RTE121821M", "inResultset": true }, "SY121821E": { "color": "#ff8575", "title": "SY121821E", "sortData": "SY121821E", "inResultset": true }, "SY121822M": { "color": "#515151", "title": "SY121822M", "sortData": "SY121822M", "inResultset": true }, "GA121922": { "color": "#00d6ba", "title": "GA121922", "sortData": "GA121922", "inResultset": true }, "WBEC121922": { "color": "#85c1eb", "title": "WBEC121922", "sortData": "WBEC121922", "inResultset": true }, "AC-122519": { "color": "#ffb655", "title": "AC-122519", "sortData": "AC-122519", "inResultset": true }, "BC-122519": { "color": "#ff8575", "title": "BC-122519", "sortData": "BC-122519", "inResultset": true }, "GA122022": { "color": "#515151", "title": "GA122022", "sortData": "GA122022", "inResultset": true }, "HAM122021E": { "color": "#00d6ba", "title": "HAM122021E", "sortData": "HAM122021E", "inResultset": true }, "AC-122119": { "color": "#85c1eb", "title": "AC-122119", "sortData": "AC-122119", "inResultset": true }, "AE122119": { "color": "#ffb655", "title": "AE122119", "sortData": "AE122119", "inResultset": true }, "BST122119": { "color": "#ff8575", "title": "BST122119", "sortData": "BST122119", "inResultset": true }, "GA122122": { "color": "#515151", "title": "GA122122", "sortData": "GA122122", "inResultset": true }, "HAM122122E": { "color": "#00d6ba", "title": "HAM122122E", "sortData": "HAM122122E", "inResultset": true }, "PNG122119": { "color": "#85c1eb", "title": "PNG122119", "sortData": "PNG122119", "inResultset": true }, "TUR122119": { "color": "#ffb655", "title": "TUR122119", "sortData": "TUR122119", "inResultset": true }, "WBEC122119": { "color": "#ff8575", "title": "WBEC122119", "sortData": "WBEC122119", "inResultset": true }, "ABW122221": { "color": "#515151", "title": "ABW122221", "sortData": "ABW122221", "inResultset": true }, "ABWA122221": { "color": "#00d6ba", "title": "ABWA122221", "sortData": "ABWA122221", "inResultset": true }, "ABWI122221": { "color": "#85c1eb", "title": "ABWI122221", "sortData": "ABWI122221", "inResultset": true }, "AC-122219": { "color": "#ffb655", "title": "AC-122219", "sortData": "AC-122219", "inResultset": true }, "AE122219": { "color": "#ff8575", "title": "AE122219", "sortData": "AE122219", "inResultset": true }, "BC-122219": { "color": "#515151", "title": "BC-122219", "sortData": "BC-122219", "inResultset": true }, "GA122222": { "color": "#00d6ba", "title": "GA122222", "sortData": "GA122222", "inResultset": true }, "TUR122219": { "color": "#85c1eb", "title": "TUR122219", "sortData": "TUR122219", "inResultset": true }, "AC-122319": { "color": "#ffb655", "title": "AC-122319", "sortData": "AC-122319", "inResultset": true }, "AW-122319": { "color": "#ff8575", "title": "AW-122319", "sortData": "AW-122319", "inResultset": true }, "BFL122319": { "color": "#515151", "title": "BFL122319", "sortData": "BFL122319", "inResultset": true }, "COG122322": { "color": "#00d6ba", "title": "COG122322", "sortData": "COG122322", "inResultset": true }, "GA122322": { "color": "#85c1eb", "title": "GA122322", "sortData": "GA122322", "inResultset": true }, "HID122319": { "color": "#ffb655", "title": "HID122319", "sortData": "HID122319", "inResultset": true }, "ITD122319": { "color": "#ff8575", "title": "ITD122319", "sortData": "ITD122319", "inResultset": true }, "MUS122319": { "color": "#515151", "title": "MUS122319", "sortData": "MUS122319", "inResultset": true }, "NTC122322E": { "color": "#00d6ba", "title": "NTC122322E", "sortData": "NTC122322E", "inResultset": true }, "STR122322E": { "color": "#85c1eb", "title": "STR122322E", "sortData": "STR122322E", "inResultset": true }, "SY122321E": { "color": "#ffb655", "title": "SY122321E", "sortData": "SY122321E", "inResultset": true }, "TUR122319": { "color": "#ff8575", "title": "TUR122319", "sortData": "TUR122319", "inResultset": true }, "AC-122419": { "color": "#515151", "title": "AC-122419", "sortData": "AC-122419", "inResultset": true }, "GA122422": { "color": "#00d6ba", "title": "GA122422", "sortData": "GA122422", "inResultset": true }, "HIS122419": { "color": "#85c1eb", "title": "HIS122419", "sortData": "HIS122419", "inResultset": true }, "JZ122422E": { "color": "#ffb655", "title": "JZ122422E", "sortData": "JZ122422E", "inResultset": true }, "NTC122419E": { "color": "#ff8575", "title": "NTC122419E", "sortData": "NTC122419E", "inResultset": true }, "NTC122422M": { "color": "#515151", "title": "NTC122422M", "sortData": "NTC122422M", "inResultset": true }, "SHA122419": { "color": "#00d6ba", "title": "SHA122419", "sortData": "SHA122419", "inResultset": true }, "STR122419E": { "color": "#85c1eb", "title": "STR122419E", "sortData": "STR122419E", "inResultset": true }, "STR122422M": { "color": "#ffb655", "title": "STR122422M", "sortData": "STR122422M", "inResultset": true }, "TUR122419": { "color": "#ff8575", "title": "TUR122419", "sortData": "TUR122419", "inResultset": true }, "AW-122519": { "color": "#515151", "title": "AW-122519", "sortData": "AW-122519", "inResultset": true }, "HID122519": { "color": "#00d6ba", "title": "HID122519", "sortData": "HID122519", "inResultset": true }, "ITD122519": { "color": "#85c1eb", "title": "ITD122519", "sortData": "ITD122519", "inResultset": true }, "JZ122521E": { "color": "#ffb655", "title": "JZ122521E", "sortData": "JZ122521E", "inResultset": true }, "MUS122519": { "color": "#ff8575", "title": "MUS122519", "sortData": "MUS122519", "inResultset": true }, "NTC122521E": { "color": "#515151", "title": "NTC122521E", "sortData": "NTC122521E", "inResultset": true }, "NTC122521M": { "color": "#00d6ba", "title": "NTC122521M", "sortData": "NTC122521M", "inResultset": true }, "STR122521E": { "color": "#85c1eb", "title": "STR122521E", "sortData": "STR122521E", "inResultset": true }, "STR122521M": { "color": "#ffb655", "title": "STR122521M", "sortData": "STR122521M", "inResultset": true }, "SY122521E": { "color": "#ff8575", "title": "SY122521E", "sortData": "SY122521E", "inResultset": true }, "SY122522E": { "color": "#515151", "title": "SY122522E", "sortData": "SY122522E", "inResultset": true }, "SY122522M": { "color": "#00d6ba", "title": "SY122522M", "sortData": "SY122522M", "inResultset": true }, "TUR122519": { "color": "#85c1eb", "title": "TUR122519", "sortData": "TUR122519", "inResultset": true }, "HIS122619": { "color": "#ffb655", "title": "HIS122619", "sortData": "HIS122619", "inResultset": true }, "TUR122619": { "color": "#ff8575", "title": "TUR122619", "sortData": "TUR122619", "inResultset": true }, "AE122719": { "color": "#515151", "title": "AE122719", "sortData": "AE122719", "inResultset": true }, "GA122722": { "color": "#00d6ba", "title": "GA122722", "sortData": "GA122722", "inResultset": true }, "TUR122719": { "color": "#85c1eb", "title": "TUR122719", "sortData": "TUR122719", "inResultset": true }, "AE122819": { "color": "#ffb655", "title": "AE122819", "sortData": "AE122819", "inResultset": true }, "BST122819": { "color": "#ff8575", "title": "BST122819", "sortData": "BST122819", "inResultset": true }, "GROUNDS": { "color": "#515151", "title": "GROUNDS", "sortData": "GROUNDS", "inResultset": true }, "OPR-122821": { "color": "#00d6ba", "title": "OPR-122821", "sortData": "OPR-122821", "inResultset": true }, "TGA122820": { "color": "#85c1eb", "title": "TGA122820", "sortData": "TGA122820", "inResultset": true }, "TUR122819": { "color": "#ffb655", "title": "TUR122819", "sortData": "TUR122819", "inResultset": true }, "AE122919": { "color": "#ff8575", "title": "AE122919", "sortData": "AE122919", "inResultset": true }, "MODEL01": { "color": "#515151", "title": "MODEL01", "sortData": "MODEL01", "inResultset": true }, "MODEL02": { "color": "#00d6ba", "title": "MODEL02", "sortData": "MODEL02", "inResultset": true }, "MODEL03": { "color": "#85c1eb", "title": "MODEL03", "sortData": "MODEL03", "inResultset": true }, "MODEL04": { "color": "#ffb655", "title": "MODEL04", "sortData": "MODEL04", "inResultset": true }, "MODEL05": { "color": "#ff8575", "title": "MODEL05", "sortData": "MODEL05", "inResultset": true }, "PNG122919": { "color": "#515151", "title": "PNG122919", "sortData": "PNG122919", "inResultset": true }, "STNG122919": { "color": "#00d6ba", "title": "STNG122919", "sortData": "STNG122919", "inResultset": true }, "THSDIGITAL": { "color": "#85c1eb", "title": "THSDIGITAL", "sortData": "THSDIGITAL", "inResultset": true }, "TUR122919": { "color": "#ffb655", "title": "TUR122919", "sortData": "TUR122919", "inResultset": true }, "AW-123019": { "color": "#ff8575", "title": "AW-123019", "sortData": "AW-123019", "inResultset": true }, "BFL123019": { "color": "#515151", "title": "BFL123019", "sortData": "BFL123019", "inResultset": true }, "GA123022": { "color": "#00d6ba", "title": "GA123022", "sortData": "GA123022", "inResultset": true }, "HID123019": { "color": "#85c1eb", "title": "HID123019", "sortData": "HID123019", "inResultset": true }, "ITD123019": { "color": "#ffb655", "title": "ITD123019", "sortData": "ITD123019", "inResultset": true }, "MUS123019": { "color": "#ff8575", "title": "MUS123019", "sortData": "MUS123019", "inResultset": true }, "SY123021M": { "color": "#515151", "title": "SY123021M", "sortData": "SY123021M", "inResultset": true }, "TUR123019": { "color": "#00d6ba", "title": "TUR123019", "sortData": "TUR123019", "inResultset": true }, "ADMV-2020": { "color": "#85c1eb", "title": "ADMV-2020", "sortData": "ADMV-2020", "inResultset": true }, "ART123119": { "color": "#ffb655", "title": "ART123119", "sortData": "ART123119", "inResultset": true }, "AUD-2019": { "color": "#ff8575", "title": "AUD-2019", "sortData": "AUD-2019", "inResultset": true }, "BAKED-2019": { "color": "#515151", "title": "BAKED-2019", "sortData": "BAKED-2019", "inResultset": true }, "CANDY-2019": { "color": "#00d6ba", "title": "CANDY-2019", "sortData": "CANDY-2019", "inResultset": true }, "CAR-2018": { "color": "#85c1eb", "title": "CAR-2018", "sortData": "CAR-2018", "inResultset": true }, "COFFTEAV": { "color": "#ffb655", "title": "COFFTEAV", "sortData": "COFFTEAV", "inResultset": true }, "CORN-2019": { "color": "#ff8575", "title": "CORN-2019", "sortData": "CORN-2019", "inResultset": true }, "FLEX1-2020": { "color": "#515151", "title": "FLEX1-2020", "sortData": "FLEX1-2020", "inResultset": true }, "FLEX2-2020": { "color": "#00d6ba", "title": "FLEX2-2020", "sortData": "FLEX2-2020", "inResultset": true }, "FLEX3-2020": { "color": "#85c1eb", "title": "FLEX3-2020", "sortData": "FLEX3-2020", "inResultset": true }, "FLEX4-2020": { "color": "#ffb655", "title": "FLEX4-2020", "sortData": "FLEX4-2020", "inResultset": true }, "FLEX5-2020": { "color": "#ff8575", "title": "FLEX5-2020", "sortData": "FLEX5-2020", "inResultset": true }, "FLEX6-2020": { "color": "#515151", "title": "FLEX6-2020", "sortData": "FLEX6-2020", "inResultset": true }, "FLEX7-2020": { "color": "#00d6ba", "title": "FLEX7-2020", "sortData": "FLEX7-2020", "inResultset": true }, "FLEX8-2020": { "color": "#85c1eb", "title": "FLEX8-2020", "sortData": "FLEX8-2020", "inResultset": true }, "FLEX9-2020": { "color": "#ffb655", "title": "FLEX9-2020", "sortData": "FLEX9-2020", "inResultset": true }, "FLX10-2020": { "color": "#ff8575", "title": "FLX10-2020", "sortData": "FLX10-2020", "inResultset": true }, "FOUNT-2019": { "color": "#515151", "title": "FOUNT-2019", "sortData": "FOUNT-2019", "inResultset": true }, "GA123122": { "color": "#00d6ba", "title": "GA123122", "sortData": "GA123122", "inResultset": true }, "GB2021": { "color": "#85c1eb", "title": "GB2021", "sortData": "GB2021", "inResultset": true }, "HIS123119": { "color": "#ffb655", "title": "HIS123119", "sortData": "HIS123119", "inResultset": true }, "MAT123119": { "color": "#ff8575", "title": "MAT123119", "sortData": "MAT123119", "inResultset": true }, "MDRNK-2019": { "color": "#515151", "title": "MDRNK-2019", "sortData": "MDRNK-2019", "inResultset": true }, "MUG-2019": { "color": "#00d6ba", "title": "MUG-2019", "sortData": "MUG-2019", "inResultset": true }, "OPR-123121": { "color": "#85c1eb", "title": "OPR-123121", "sortData": "OPR-123121", "inResultset": true }, "PL05PK19": { "color": "#ffb655", "title": "PL05PK19", "sortData": "PL05PK19", "inResultset": true }, "PL10PK19": { "color": "#ff8575", "title": "PL10PK19", "sortData": "PL10PK19", "inResultset": true }, "PL16PK19": { "color": "#515151", "title": "PL16PK19", "sortData": "PL16PK19", "inResultset": true }, "PRK123119": { "color": "#00d6ba", "title": "PRK123119", "sortData": "PRK123119", "inResultset": true }, "RENTFOOD19": { "color": "#85c1eb", "title": "RENTFOOD19", "sortData": "RENTFOOD19", "inResultset": true }, "RENTREQ19": { "color": "#ffb655", "title": "RENTREQ19", "sortData": "RENTREQ19", "inResultset": true }, "REST-2019": { "color": "#ff8575", "title": "REST-2019", "sortData": "REST-2019", "inResultset": true }, "SOR-2020": { "color": "#515151", "title": "SOR-2020", "sortData": "SOR-2020", "inResultset": true }, "SY123119E": { "color": "#00d6ba", "title": "SY123119E", "sortData": "SY123119E", "inResultset": true }, "TEE-2019": { "color": "#85c1eb", "title": "TEE-2019", "sortData": "TEE-2019", "inResultset": true }, "TURREQ2019": { "color": "#ffb655", "title": "TURREQ2019", "sortData": "TURREQ2019", "inResultset": true }, "UMB-2019": { "color": "#ff8575", "title": "UMB-2019", "sortData": "UMB-2019", "inResultset": true }, "WINE-2019": { "color": "#515151", "title": "WINE-2019", "sortData": "WINE-2019", "inResultset": true } } } } ] }, { "name": "filters", "items": [] } ] }, "type": "chart/polar", "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 }, "categories": { "enabled": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "axis": { "enabled": true, "labels": { "enabled": true, "rotation": 0 }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 200 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days_in_date", "title": "Days in Date", "singular": "Days in Date", "plural": "Days in Date" }, { "id": "code", "title": "Code", "singular": "Code", "plural": "Code" } ] } }, "instanceid": "5717E-232B-6F", "queryStartTime": "2023-09-14T15:27:19", "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "minDate": 1701406800000, "maxDate": 1703998800000, "tickLevel": "day", "forcedRedraw": false, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 31 } }, "dashboardid": "65035b67645bf74bb455f8d7", "drawing": true, "disableSelctor": 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": 1, "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 } }, { "title": "Date by Performance Hour", "subtype": "pivot", "oid": "65035ecd645bf74bb455f8f1", "desc": null, "source": null, "datasource": { "title": "TNHS-Seats and Tickets", "fullname": "CWALLINGFORD-TN/TNHS-Seats and Tickets", "id": "aCWALLINGFORDLQAaTN_aTNHSLQAaSEATSIAAaANDIAAaTICKETS", "address": "CWALLINGFORD-TN", "database": "aTNHSLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2023-09-12T10:37:38" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "yyyy-MM-dd", "minutes": "HH:mm" }, "members": { "2023-12-01": { "color": "#547A94", "title": "2023-12-01", "sortData": "2023-12-01T00:00:00", "inResultset": true }, "2023-12-02": { "color": "#F48E06", "title": "2023-12-02", "sortData": "2023-12-02T00:00:00", "inResultset": true }, "2023-12-03": { "color": "#DB4935", "title": "2023-12-03", "sortData": "2023-12-03T00:00:00", "inResultset": true }, "2023-12-04": { "color": "#333333", "title": "2023-12-04", "sortData": "2023-12-04T00:00:00", "inResultset": true }, "2023-12-05": { "color": "#008775", "title": "2023-12-05", "sortData": "2023-12-05T00:00:00", "inResultset": true }, "2023-12-06": { "color": "#618caa", "title": "2023-12-06", "sortData": "2023-12-06T00:00:00", "inResultset": true }, "2023-12-07": { "color": "#ff9b16", "title": "2023-12-07", "sortData": "2023-12-07T00:00:00", "inResultset": true }, "2023-12-08": { "color": "#fc543d", "title": "2023-12-08", "sortData": "2023-12-08T00:00:00", "inResultset": true }, "2023-12-09": { "color": "#3b3b3b", "title": "2023-12-09", "sortData": "2023-12-09T00:00:00", "inResultset": true }, "2023-12-10": { "color": "#009b87", "title": "2023-12-10", "sortData": "2023-12-10T00:00:00", "inResultset": true }, "2023-12-11": { "color": "#6897b7", "title": "2023-12-11", "sortData": "2023-12-11T00:00:00", "inResultset": true }, "2023-12-12": { "color": "#ffa022", "title": "2023-12-12", "sortData": "2023-12-12T00:00:00", "inResultset": true }, "2023-12-13": { "color": "#ff5d47", "title": "2023-12-13", "sortData": "2023-12-13T00:00:00", "inResultset": true }, "2023-12-14": { "color": "#3f3f3f", "title": "2023-12-14", "sortData": "2023-12-14T00:00:00", "inResultset": true }, "2023-12-15": { "color": "#00a790", "title": "2023-12-15", "sortData": "2023-12-15T00:00:00", "inResultset": true }, "2023-12-16": { "color": "#6fa1c3", "title": "2023-12-16", "sortData": "2023-12-16T00:00:00", "inResultset": true }, "2023-12-17": { "color": "#ffa62e", "title": "2023-12-17", "sortData": "2023-12-17T00:00:00", "inResultset": true }, "2023-12-18": { "color": "#ff6752", "title": "2023-12-18", "sortData": "2023-12-18T00:00:00", "inResultset": true }, "2023-12-19": { "color": "#434343", "title": "2023-12-19", "sortData": "2023-12-19T00:00:00", "inResultset": true }, "2023-12-20": { "color": "#00b29a", "title": "2023-12-20", "sortData": "2023-12-20T00:00:00", "inResultset": true }, "2023-12-21": { "color": "#74a9cd", "title": "2023-12-21", "sortData": "2023-12-21T00:00:00", "inResultset": true }, "2023-12-22": { "color": "#ffaa38", "title": "2023-12-22", "sortData": "2023-12-22T00:00:00", "inResultset": true }, "2023-12-23": { "color": "#ff6f5b", "title": "2023-12-23", "sortData": "2023-12-23T00:00:00", "inResultset": true }, "2023-12-24": { "color": "#474747", "title": "2023-12-24", "sortData": "2023-12-24T00:00:00", "inResultset": true }, "2023-12-25": { "color": "#00bba2", "title": "2023-12-25", "sortData": "2023-12-25T00:00:00", "inResultset": true }, "2023-12-26": { "color": "#79afd5", "title": "2023-12-26", "sortData": "2023-12-26T00:00:00", "inResultset": true }, "2023-12-27": { "color": "#ffad3f", "title": "2023-12-27", "sortData": "2023-12-27T00:00:00", "inResultset": true }, "2023-12-28": { "color": "#ff7461", "title": "2023-12-28", "sortData": "2023-12-28T00:00:00", "inResultset": true }, "2023-12-29": { "color": "#494949", "title": "2023-12-29", "sortData": "2023-12-29T00:00:00", "inResultset": true }, "2023-12-30": { "color": "#00c2a8", "title": "2023-12-30", "sortData": "2023-12-30T00:00:00", "inResultset": true }, "2023-12-31": { "color": "#7cb4db", "title": "2023-12-31", "sortData": "2023-12-31T00:00:00", "inResultset": true } } }, "hierarchies": [ "calendar", "calendar - weeks" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "type": "color", "color": "transparent" }, "color": { "type": "condition", "conditions": [ { "color": "#ff6752", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "MAX([FC4D1-EDD],\n MAX([1075F-A25],\n [46BAE-748])) * 0.8", "context": { "[46BAE-748]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[1075F-A25]": { "table": "PERFORMANCE DETAIL", "column": "Performance Hour", "dim": "[PERFORMANCE DETAIL.Performance Hour]", "datatype": "numeric", "title": "Performance Hour" }, "[FC4D1-EDD]": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula" } } }, { "color": "#ffa62e", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "MAX([92C3C-F28],\n MAX([91A0D-691],\n [9EBAE-4F8])) * 0.6", "context": { "[9EBAE-4F8]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[91A0D-691]": { "table": "PERFORMANCE DETAIL", "column": "Performance Hour", "dim": "[PERFORMANCE DETAIL.Performance Hour]", "datatype": "numeric", "title": "Performance Hour" }, "[92C3C-F28]": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula" } } }, { "color": "#00b29a", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "MAX([708AC-93B],\n MAX([EB436-A73],\n [6F4A5-5F1])) * 0.4", "context": { "[6F4A5-5F1]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[EB436-A73]": { "table": "PERFORMANCE DETAIL", "column": "Performance Hour", "dim": "[PERFORMANCE DETAIL.Performance Hour]", "datatype": "numeric", "title": "Performance Hour" }, "[708AC-93B]": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula" } } }, { "color": "#6fa1c3", "operator": "≥", "expression": { "jaql": { "type": "measure", "formula": "MAX([04879-845],\n MAX([A136F-641],\n [8D6A1-982])) * 0.2", "context": { "[8D6A1-982]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[A136F-641]": { "table": "PERFORMANCE DETAIL", "column": "Performance Hour", "dim": "[PERFORMANCE DETAIL.Performance Hour]", "datatype": "numeric", "title": "Performance Hour" }, "[04879-845]": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Formula" } } } ] } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 2 } } ] }, { "name": "columns", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Hour", "dim": "[PERFORMANCE DETAIL.Performance Hour]", "datatype": "numeric", "title": "Performance Hour" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Hour]", "index": 1 } } ] }, { "name": "filters", "items": [] } ] }, "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": "31", "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": true, "members": true, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days_in_date", "title": "Days in Date", "singular": "Days in Date", "plural": "Days in Date" }, { "id": "performance_hour", "title": "Performance Hour", "singular": "Performance Hour", "plural": "Performance Hour" } ] } }, "instanceid": "A6A1F-568E-53", "queryStartTime": "2023-09-14T15:33:04", "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "minDate": 1701406800000, "maxDate": 1703998800000, "tickLevel": "day", "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": 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 }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "65035b67645bf74bb455f8d7", "drawing": true } ], "hierarchies": [] }