{ "title": "Tickets Out Exec", "desc": "", "source": "5cfe7fd0a63bc814a8625ffd", "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#547A94", "#F48E06", "#DB4935", "#333333", "#008775" ], "min": "#547A94", "max": "#F48E06", "name": "Tessitura", "sortOrder": 0 } }, "layout": { "instanceid": "94E3B-8043-B6", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "5d2e16101f5cfb1ad0ef9fa3" } ] } ] } ] } ], "container": {} }, "original": null, "oid": "5d2e16101f5cfb1ad0ef9fa2", "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "editing": false, "filters": [ { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] } }, "instanceid": "AA3BA-1E7E-07", "isCascading": false, "disabled": true }, { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Days in Date", "level": "days", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "next": { "count": 365, "offset": 1 }, "custom": true } }, "instanceid": "49D87-606A-68", "isCascading": false, "disabled": false, "locked": true }, { "levels": [ { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Bad Season", "Education", "Merchandise", "Tours" ] } } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1920 Shuttle Bus - Vivaldi Fou", "1920 Shuttle Bus - Very Vegas", "1920 Shuttle Bus - Season Fina", "1920 Shuttle Bus - Opening Nig", "1920 Shuttle Bus - Kurt Weill'", "1920 Shuttle Bus - Dvorak Brah", "1920 Shuttle Bus - Danny Elfma", "1920 Shuttle Bus - Beethoven M", "1920 Shuttle Bus - Baroque Hol", "1920 Shuttle Bus - A Classic H", "1920 Donation Events", "1920 Broadway Deposit", "1920 Choreographers' Showcase", "1920 The Studio Series" ] } } } ], "model": { "instanceid": "D1163-A9AF-EE", "__store": [ "[SEASON.Season Type]", "[PERFORMANCE DETAIL.Production Season]" ] }, "isCascading": true, "instanceid": "6B319-C856-55", "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Status", "dim": "[PERFORMANCE DETAIL.Status]", "datatype": "text", "merged": true, "title": "Status", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Cancelled" ] } } }, "instanceid": "C1405-96E9-32", "isCascading": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Theater", "dim": "[PERFORMANCE DETAIL.Theater]", "datatype": "text", "merged": true, "title": "Theater", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Shuttle Bus" ] } } }, "instanceid": "FBC07-D2C0-40", "isCascading": false } ], "filterToDatasourceMapping": {}, "parentFolder": "5d24c0371f5cfb1ad0ef75e2", "isPublic": null, "defaultFilters": [ { "jaql": { "table": "PERFORMANCE DATE", "column": "Date", "dim": "[PERFORMANCE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "filter": { "next": { "count": 365, "offset": 1 }, "custom": true } }, "isCascading": false, "disabled": false }, { "jaql": { "table": "SEASON", "column": "Season Fiscal Year", "dim": "[SEASON.Season Fiscal Year]", "datatype": "numeric", "title": "Season Fiscal Year", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-06T04:37:37" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2020" ] } }, "isCascading": false }, { "levels": [ { "table": "SEASON", "column": "Season Type", "dim": "[SEASON.Season Type]", "datatype": "text", "merged": true, "title": "Season Type", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-06T04:37:37" }, "panel": "scope", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Bad Season", "Education", "Merchandise", "Tours" ] } } }, { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-06T04:37:37" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "1920 Shuttle Bus - Vivaldi Fou", "1920 Shuttle Bus - Very Vegas", "1920 Shuttle Bus - Season Fina", "1920 Shuttle Bus - Opening Nig", "1920 Shuttle Bus - Kurt Weill'", "1920 Shuttle Bus - Dvorak Brah", "1920 Shuttle Bus - Danny Elfma", "1920 Shuttle Bus - Beethoven M", "1920 Shuttle Bus - Baroque Hol", "1920 Shuttle Bus - A Classic H", "1920 Donation Events", "1920 Broadway Deposit", "1920 Choreographers' Showcase", "1920 The Studio Series" ] } } } ], "model": { "instanceid": "D1163-A9AF-EE", "__store": [ "[SEASON.Season Type]", "[PERFORMANCE DETAIL.Production Season]" ] }, "isCascading": true, "disabled": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Status", "dim": "[PERFORMANCE DETAIL.Status]", "datatype": "text", "merged": true, "title": "Status", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-06T04:37:37" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Cancelled" ] } } }, "isCascading": false }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Theater", "dim": "[PERFORMANCE DETAIL.Theater]", "datatype": "text", "merged": true, "title": "Theater", "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-06-20T04:57:18" }, "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Shuttle Bus" ] } } }, "isCascading": false } ], "subscription": { "isDataChange": true, "type": "onUpdate", "schedule": "* * * * * *", "timezone": 300, "tzName": "America/Chicago", "context": { "dashboardid": "5d2e16101f5cfb1ad0ef9fa2" }, "active": false, "executionPerDay": 1, "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false } }, "settings": { "autoUpdateOnFiltersChange": false }, "widgets": [ { "title": "Tickets Out", "subtype": "pivot", "desc": null, "source": "5cfe7fd0a63bc814a8625ffe", "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets" }, "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": "Event 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" ], "field": { "id": "[PERFORMANCE DATE.Date (Calendar)]_days", "index": 0 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance Time", "dim": "[PERFORMANCE DETAIL.Performance Time]", "datatype": "text", "merged": true, "title": "Event Time" }, "field": { "id": "[PERFORMANCE DETAIL.Performance Time]", "index": 1 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Facility", "dim": "[PERFORMANCE DETAIL.Facility]", "datatype": "text", "merged": true, "title": "Facility" }, "field": { "id": "[PERFORMANCE DETAIL.Facility]", "index": 2 } }, { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Performance", "dim": "[PERFORMANCE DETAIL.Performance]", "datatype": "text", "merged": true, "title": "Event Name" }, "field": { "id": "[PERFORMANCE DETAIL.Performance]", "index": 3 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Sellable" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Seat Count]_sum", "index": 4 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Comp Count", "dim": "[SEAT & TICKET VALUES.Ticket Comp Count]", "datatype": "numeric", "agg": "sum", "title": "Comp" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Comp Count]_sum", "index": 5 } }, { "jaql": { "type": "measure", "formula": "(SUM([204DF-76B]), [80286-010])", "context": { "[80286-010]": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "filter": { "explicit": true, "multiSelection": true, "members": [ "Consignment" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[204DF-76B]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count" } }, "title": "Consignments" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(SUM([204DF-76B]), [80286-010])", "index": 6 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Issued" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Count]_sum", "index": 7 } }, { "jaql": { "type": "measure", "formula": "(sum([90DBC-F5D]),[6C74C-713])", "context": { "[CF512-832]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Held" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[6C74C-713]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Available" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[90DBC-F5D]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "title": "Seat Count" } }, "title": "Available" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([90DBC-F5D]),[6C74C-713])", "index": 8 } }, { "jaql": { "type": "measure", "formula": "(sum([7D661-220]),[9BEB4-3A6])", "context": { "[9BEB4-3A6]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Held" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[6A300-8AC]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status" }, "[7D661-220]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "title": "Seat Count" } }, "title": "Held" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([7D661-220]),[9BEB4-3A6])", "index": 9 } }, { "jaql": { "type": "measure", "formula": "(sum([24B20-77C]),[B9835-BF9])", "context": { "[62279-E7D]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Held" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[B9835-BF9]": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": true, "multiSelection": true, "members": [ "Reserved, Unpaid" ] }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[24B20-77C]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "title": "Seat Count" } }, "title": "Reserved" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([24B20-77C]),[B9835-BF9])", "index": 10 } }, { "jaql": { "type": "measure", "formula": "(sum([C881B-46E]),[93958-6EF])", "context": { "[93958-6EF]": { "table": "PERFORMANCE PRICING", "column": "Price Type Category", "dim": "[PERFORMANCE PRICING.Price Type Category]", "datatype": "text", "merged": true, "title": "Price Type Category", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "Consignment" ] } }, "collapsed": false, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[C881B-46E]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" } }, "title": "Ticket Paid Amount" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(sum([C881B-46E]),[93958-6EF])", "index": 11 } }, { "jaql": { "type": "measure", "formula": "sum([BE141-DA3]/[8BA6C-A91])", "context": { "[BE141-DA3]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[8BA6C-A91]": { "table": "SEAT & TICKET VALUES", "column": "Seat Count", "dim": "[SEAT & TICKET VALUES.Seat Count]", "datatype": "numeric", "agg": "sum", "title": "Total Seat Count" } }, "title": "Pct Issued" }, "format": { "mask": { "decimals": 2, "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([BE141-DA3]/[8BA6C-A91])", "index": 12 } }, { "jaql": { "type": "measure", "formula": "sum([CE81D-D6B]/[69B65-EAB])", "context": { "[CE81D-D6B]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[69B65-EAB]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" } }, "title": "Avg Ticket Price" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([CE81D-D6B]/[69B65-EAB])", "index": 13 } }, { "jaql": { "type": "measure", "formula": "(SUM([DC321-375]),[38E6E-57D])", "context": { "[DC321-375]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[38E6E-57D]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 1, "offset": 1 } }, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[FD865-D83]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date" } }, "title": "Yesterday Tix Issued" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(SUM([DC321-375]),[38E6E-57D])", "index": 14 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(SUM([74DE4-22A]),[71A14-D6C])", "context": { "[74DE4-22A]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[71A14-D6C]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 1, "offset": 1 } }, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } } }, "title": "Yesterday Sales Amt" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": 2, "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(SUM([74DE4-22A]),[71A14-D6C])", "index": 15 }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(SUM([DB094-A27]),[03AB4-ED5])", "context": { "[DB094-A27]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" }, "[ED326-F72]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 1, "offset": 1 } }, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } }, "[03AB4-ED5]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 1, "offset": 0 } }, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } } }, "title": "Today Tix Issued" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 16 }, "disabled": true }, { "jaql": { "type": "measure", "formula": "(SUM([3C097-E3F]),[54ADF-11A])", "context": { "[3C097-E3F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[54ADF-11A]": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Date", "filter": { "last": { "count": 1, "offset": 0 } }, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } } }, "title": "Today Sales Amt" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "index": 16 }, "disabled": true } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "SEATING", "column": "Seat Status", "dim": "[SEATING.Seat Status]", "datatype": "text", "merged": true, "title": "Seat Status", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": true, "datasource": { "title": "SCPA-Seats and Tickets", "fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets", "id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS", "address": "nauCUBEBP001.KRIOSTESS.local", "database": "aSCPALQAaSeatsIAAaandIAAaTickets", "lastBuildTime": "2019-02-27T04:39:02" } } } ] } ] }, "oid": "5d2e16101f5cfb1ad0ef9fa3", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "event_time", "title": "Event Time", "singular": "Event Time", "plural": "Event Time" }, { "id": "facility", "title": "Facility", "singular": "Facility", "plural": "Facility" }, { "id": "event_name", "title": "Event Name", "singular": "Event Name", "plural": "Event Name" }, { "id": "seat_status", "title": "Seat Status", "singular": "Seat Status", "plural": "Seat Status" } ] }, "rowsGrandTotal": true }, "instanceid": "03310-EA95-C9", "queryStartTime": "2019-08-06T12:28:18", "drawing": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "realTimeRefreshing": false, "dashboardid": "5d2e16101f5cfb1ad0ef9fa2", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true } ], "hierarchies": [] }