{ "title": "Anne's Weekly Attendance", "desc": "", "source": "5c33663e244d6414ec2dfc55", "type": "dashboard", "style": { "name": "vivid", "palette": { "_id": "5a4fefe39e99d8d281b449df", "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "isDefault": true, "sortOrder": 0 } }, "layout": { "instanceid": "DA9DB-EFA1-CF", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 1028, "height": "464px", "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5d9b852e16a41532b4f693fc" } ], "width": 36.643356643356654, "stretchable": false, "pxlWidth": 524, "index": 0 }, { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d9f3a944fbffb2840cb5e5b", "height": "464px" } ], "width": 63.356643356643346, "stretchable": false, "pxlWidth": 906, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5da5cfe267c84d1d74eb64f7", "height": "464px" } ], "width": 50, "stretchable": false, "pxlWidth": 715, "index": 0 }, { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "5d9b858416a41532b4f69412", "height": "464px" } ], "width": 50, "stretchable": false, "pxlWidth": 715, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d9b84ab16a41532b4f693c6", "height": "464px" } ], "width": 100, "stretchable": false, "pxlWidth": 953, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d9b84ab16a41532b4f693c9", "height": "464px" } ], "width": 100, "stretchable": false, "pxlWidth": 1430, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "5d9b84ab16a41532b4f693c4" } ], "width": 100, "stretchable": false, "pxlWidth": 1430, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "5d9b84ab16a41532b4f693ca", "height": 384 } ], "width": 100, "stretchable": false, "pxlWidth": 1430, "index": 0 } ] } ], "pxlWidth": 1430, "index": 0 } ], "container": {} }, "original": null, "oid": "5d9b84ab16a41532b4f693bf", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "editing": false, "filters": [ { "instanceid": "78B19-927F-53", "isCascading": false, "disabled": false, "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Current Year Offset", "dim": "[PERFORMANCE DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "collapsed": true, "panel": "scope", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "all": true } } }, { "instanceid": "FEAA4-5BDA-85", "isCascading": true, "levels": [ { "table": "PERFORMANCE DETAIL", "column": "Title", "dim": "[PERFORMANCE DETAIL.Title]", "datatype": "text", "merged": true, "title": "Title", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-10-06T23:36:33" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Type", "dim": "[PERFORMANCE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code Short", "dim": "[PERFORMANCE DETAIL.Performance Date and Code Short]", "datatype": "text", "merged": true, "title": "Performance Date and Code Short", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "all": true } } ], "model": { "instanceid": "B767E-D9B4-AC", "__store": [ "[PERFORMANCE DETAIL.Title]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Production Season]", "[PERFORMANCE DETAIL.Type]", "[PERFORMANCE DETAIL.Performance Date and Code Short]" ] }, "disabled": false }, { "jaql": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "collapsed": true, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-09-14T17:24:08" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "049DC-2B7E-5E", "isCascading": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-09-14T17:24:08" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": "true", "all": true } }, "instanceid": "C5073-1673-EB", "isCascading": false, "locked": true }, { "jaql": { "datatype": "text", "dim": "[SEAT & TICKET DETAILS.Attended Flag]", "title": "Attended Flag", "column": "Attended Flag", "table": "SEAT & TICKET DETAILS", "filter": { "explicit": false, "multiSelection": true, "all": true }, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "collapsed": true }, "instanceid": "DE20A-8B34-82", "isCascading": false }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Weeks in Date", "level": "weeks", "firstday": "mon", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-10-06T23:36:33" }, "collapsed": true, "filter": { "last": { "count": 1, "offset": 1 } } }, "instanceid": "582C7-A048-5E", "isCascading": false } ], "filterToDatasourceMapping": {}, "isPublic": null, "parentFolder": null, "previewLayout": [ { "type": "previewLayout", "format": "LETTER", "orientation": "landscape", "layout": "asis", "headerSize": "compact", "title": true, "elasticubeBuilt": true, "elasticubeName": true, "filters": true, "logo": false, "pageNumbers": true, "pages": [ { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5d9b852e16a41532b4f693fc" } ], "width": 36.643356643356654 }, { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5d9f3a944fbffb2840cb5e5b" } ], "width": 63.356643356643346 } ] } ] } ] }, { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5da5cfe267c84d1d74eb64f7" } ], "width": 50 }, { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5d9b858416a41532b4f69412" } ], "width": 50 } ] } ] } ] }, { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5d9b84ab16a41532b4f693c6" } ], "width": 100 } ] } ] } ] }, { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 506, "widgetid": "5d9b84ab16a41532b4f693c9" } ], "width": 100 } ] } ] } ] }, { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 426, "widgetid": "5d9b84ab16a41532b4f693c4" } ], "width": 100 } ] } ] } ] }, { "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 1024, "height": 426, "widgetid": "5d9b84ab16a41532b4f693ca" } ], "width": 100 } ] } ] } ] } ], "savedByButton": "Export", "openPath": "PDF Settings" } ], "defaultFilters": [ { "instanceid": "78B19-927F-53", "isCascading": false, "disabled": false, "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Current Year Offset", "dim": "[PERFORMANCE DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "collapsed": true, "panel": "scope", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "0" ] } } }, { "instanceid": "FEAA4-5BDA-85", "isCascading": true, "levels": [ { "table": "PERFORMANCE DETAIL", "column": "Title", "dim": "[PERFORMANCE DETAIL.Title]", "datatype": "text", "merged": true, "title": "Title", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Type", "dim": "[PERFORMANCE DETAIL.Type]", "datatype": "text", "merged": true, "title": "Type", "collapsed": true, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "all": true } }, { "table": "PERFORMANCE DETAIL", "column": "Performance Date and Code Short", "dim": "[PERFORMANCE DETAIL.Performance Date and Code Short]", "datatype": "text", "merged": true, "title": "Performance Date and Code Short", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-06-11T08:48:46" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "all": true } } ], "model": { "instanceid": "B767E-D9B4-AC", "__store": [ "[PERFORMANCE DETAIL.Title]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Production Season]", "[PERFORMANCE DETAIL.Type]", "[PERFORMANCE DETAIL.Performance Date and Code Short]" ] }, "disabled": false }, { "jaql": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "collapsed": true, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-09-14T17:24:08" }, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "049DC-2B7E-5E", "isCascading": false }, { "jaql": { "table": "CONSTITUENT", "column": "Constituent ID", "dim": "[CONSTITUENT.Constituent ID]", "datatype": "numeric", "merged": true, "title": "Constituent ID", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2018-09-14T17:24:08" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "-999999" ] } } }, "instanceid": "C5073-1673-EB", "isCascading": false, "locked": true } ], "settings": { "autoUpdateOnFiltersChange": false }, "hasPrevioiusVersion": true, "widgets": [ { "title": "Monthly Attendance Comparison (this and last year)", "subtype": "column/classic", "desc": null, "source": "5c33663e244d6414ec2dfc67", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [ "[PERFORMANCE DATE.Fiscal Current Year Offset]", "[PERFORMANCE DETAIL.Title]", "[PERFORMANCE DETAIL.Production]", "[PERFORMANCE DETAIL.Production Season]", "[PERFORMANCE DETAIL.Type]", "[PERFORMANCE DETAIL.Performance Date and Code Short]", "[ATTENDED DATE.Date (Calendar)]" ], "all": true }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Fiscal Period", "dim": "[ATTENDED.Fiscal Period1]", "datatype": "numeric", "title": "Fiscal Period" } }, { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Month Name", "dim": "[ATTENDED DATE.Calendar Month Name]", "datatype": "text", "merged": true, "title": "Calendar Month Name" }, "disabled": false } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "SUM([75D14-19B])", "context": { "[75D14-19B]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "title": "Attended Count" } }, "title": "Count" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#547A94", "type": "color" } }, "disabled": false } ] }, { "name": "break by", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year" }, "format": { "members": { "1900": { "color": "#DB4935", "title": "1900", "sortData": 1900, "inResultset": true }, "2018": { "color": "#F48E06", "title": "2018", "sortData": 2018, "inResultset": true }, "2019": { "color": "#547A94", "title": "2019", "sortData": 2019, "inResultset": true } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Fiscal Current Year Offset", "dim": "[PERFORMANCE DATE.Fiscal Current Year Offset]", "datatype": "numeric", "title": "Fiscal Current Year Offset", "filter": { "from": "-2", "to": "0" }, "collapsed": true }, "disabled": true }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "filter": { "explicit": true, "multiSelection": true, "members": [ "General Admissions" ] }, "collapsed": false, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } } }, { "jaql": { "table": "SEAT & TICKET DETAILS", "column": "SLI Status", "dim": "[SEAT & TICKET.SLI Status]", "datatype": "text", "merged": true, "title": "SLI Status", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)", "Return in Benevolent Mode", "Seated, Unpaid", "Seated, Paid" ] } }, "collapsed": false, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } } }, { "jaql": { "table": "ATTENDED DATE", "column": "Calendar Year", "dim": "[ATTENDED.Calendar Year1]", "datatype": "numeric", "title": "Calendar Year", "filter": { "explicit": false, "multiSelection": "true", "all": "true" }, "collapsed": false, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } }, "title": "Calendar Year" } ] } ] }, "type": "chart/column", "oid": "5d9b84ab16a41532b4f693c4", "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": true, "rotation": -45 }, "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": false, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": false, "hideMinMax": false, "templateMainYHasGridLines": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "lineWidth": { "width": "bold" }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "fiscal_period", "title": "Fiscal Period", "singular": "Fiscal Period", "plural": "Fiscal Period" }, { "id": "calendar_month_name", "title": "Calendar Month Name", "singular": "Calendar Month Name", "plural": "Calendar Month Name" }, { "id": "calendar_year", "title": "Calendar Year", "singular": "Calendar Year", "plural": "Calendar Year" }, { "id": "fiscal_current_year_offset", "title": "Fiscal Current Year Offset", "singular": "Fiscal Current Year Offset", "plural": "Fiscal Current Year Offset" }, { "id": "production", "title": "Production", "singular": "Production", "plural": "Production" }, { "id": "sli_status", "title": "SLI Status", "singular": "SLI Status", "plural": "SLI Status" } ] } }, "instanceid": "FB637-E328-00", "queryStartTime": "2020-01-02T14:54:05", "widgetTimingLoged": false, "drawing": true, "disableSelctor": 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 }, "forcedRedraw": false, "realTimeRefreshing": false, "dashboardid": "5d9b84ab16a41532b4f693bf", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 22 } }, "canEditFilters": true, "script": "", "chart": { "0": {}, "context": {}, "length": 1 }, "continuousDates": false, "nullAsZero": false, "viewState": { "activeTab": "design" }, "minDate": 0, "maxDate": 0, "tickInterval": 31556952000, "tickLevel": "year" }, { "title": "Last 7 Days' Museum Attendance by Price Type", "subtype": "column/classic", "desc": null, "source": "5c33663e244d6414ec2dfc66", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": true }, "panels": [ { "name": "categories", "items": [ { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED 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": "values", "items": [ { "jaql": { "type": "measure", "formula": "[2E8A4-608]", "context": { "[2E8A4-608]": { "table": "SEAT & TICKET VALUES", "column": "Attended Count", "dim": "[SEAT & TICKET VALUES.Attended Count]", "datatype": "numeric", "agg": "sum", "title": "Total Attended Count" } }, "title": "TIcket Count" }, "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": 0, "number": { "separated": true } }, "color_bkp": { "color": "#547A94", "type": "color" } } } ] }, { "name": "break by", "items": [ { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type" }, "format": { "members": { "(none)": { "color": "#e6e6e6", "title": "(none)", "sortData": "(none)" }, "Child (17 and under)": { "color": "#953224", "title": "Child (17 and under)", "sortData": "Child (17 and under)", "inResultset": true }, "Founder Ind Member": { "color": "#ff6752", "title": "Founder Ind Member", "sortData": "Founder Ind Member", "inResultset": true }, "General Admission": { "color": "#47667c", "title": "General Admission", "sortData": "General Admission", "inResultset": true }, "Merieult Member": { "color": "#008775", "title": "Merieult Member", "sortData": "Merieult Member", "inResultset": true }, "Founder Family Member": { "color": "#ff9c17", "title": "Founder Family Member", "sortData": "Founder Family Member", "inResultset": true }, "Calliot Ind Member": { "color": "#ff9b16", "title": "Calliot Ind Member", "sortData": "Calliot Ind Member" }, "Laussat Member": { "color": "#fc543d", "title": "Laussat Member", "sortData": "Laussat Member" }, "Calliot Couple Member": { "color": "#3b3b3b", "title": "Calliot Couple Member", "sortData": "Calliot Couple Member", "inResultset": true }, "Mahalia Member": { "color": "#009b87", "title": "Mahalia Member", "sortData": "Mahalia Member" }, "THNOC Volunteer": { "color": "#6897b7", "title": "THNOC Volunteer", "sortData": "THNOC Volunteer" }, "Jackson Member": { "color": "#ffa022", "title": "Jackson Member", "sortData": "Jackson Member", "inResultset": true }, "Members": { "color": "#ff5d47", "title": "Members", "sortData": "Members" }, "New Orleans Museum Month": { "color": "#3f3f3f", "title": "New Orleans Museum Month", "sortData": "New Orleans Museum Month" }, "THNOC Employee": { "color": "#00a790", "title": "THNOC Employee", "sortData": "THNOC Employee" }, "Bienville Member": { "color": "#6fa1c3", "title": "Bienville Member", "sortData": "Bienville Member" } } } } ] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "last": { "count": 7, "offset": 0 } }, "collapsed": true, "firstday": "mon", "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "disabled": true }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production", "dim": "[PERFORMANCE DETAIL.Production]", "datatype": "text", "merged": true, "title": "Production", "filter": { "explicit": true, "multiSelection": true, "members": [ "General Admissions" ] }, "collapsed": false, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } }, "disabled": false }, { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "(none)" ] } }, "collapsed": false, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } } }, { "jaql": { "table": "ATTENDED DATE", "column": "Date", "dim": "[ATTENDED DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 7, "offset": 0 } }, "collapsed": true, "datasource": { "title": "HNOC-Seats and Tickets", "fullname": "NASCUBEBP006.KRIOSTESS.local/HNOC-Seats and Tickets", "id": "aNASCUBEBP006LgAaKRIOSTESSLgAaLOCAL_aHNOCLQAaSEATSIAAaANDIAAaTICKETS", "address": "NASCUBEBP006.KRIOSTESS.local", "database": "aHNOCLQAaSeatsIAAaandIAAaTickets" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } }, "title": "Days in Date", "disabled": false } ] } ] }, "type": "chart/column", "oid": "5d9b84ab16a41532b4f693c6", "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": true, "rotation": -45 }, "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, "hideMinMax": false, "isIntervalEnabled": true }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "hideMinMax": false, "isIntervalEnabled": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "price_type", "title": "Price Type", "singular": "Price Type", "plural": "Price Type" }, { "id": "production", "title": "Production", "singular": "Production", "plural": "Production" } ] } }, "instanceid": "5E1B0-D635-08", "queryStartTime": "2020-01-06T08:55:52", "disableSelctor": false, "widgetTimingLoged": false, "forcedRedraw": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5d9b84ab16a41532b4f693bf", "options": { "dashboardFiltersMode": "select", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "canEditFilters": true, "drawing": true, "script": "widget.on('processresult',function(s,e){\n\n\t//////////////////////////\n\t//\tSort the categories\t//\n\t//////////////////////////\n\n\t\t//\tGet the categories\n\tvar categories = e.result.xAxis.categories;\n\n\t//\tCreate array to hold the totals\n\tvar totals = [];\n\n\t//\tGet the data\n\tvar data = e.result.series;\n\n\t//\tLoop through each category\n\tfor (var i=0; i