{
"title": "Ticket Sales 2020",
"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": "4873A-C7A5-F4",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": 128,
"defaultWidth": 128,
"widgetid": "5d361bd21f5cfb1ad0efcf3f"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1028,
"height": 352,
"minWidth": 48,
"maxWidth": 1028,
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc79d"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "116px",
"defaultWidth": 128,
"widgetid": "5d322c971f5cfb1ad0efc79e"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"height": "160px",
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc79c"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc79f",
"height": 384
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc7a0",
"height": 384
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "120px",
"defaultWidth": 128,
"widgetid": "5d322c971f5cfb1ad0efc7a1"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc7a2",
"height": "116px"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5d322c971f5cfb1ad0efc7a3",
"height": 384
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 876,
"index": 0
}
]
}
],
"pxlWidth": 876,
"index": 0
}
],
"container": {}
},
"original": null,
"oid": "5d322c971f5cfb1ad0efc79b",
"datasource": {
"title": "SCPA-Seats and Tickets",
"fullname": "nauCUBEBP001.KRIOSTESS.local/SCPA-Seats and Tickets",
"id": "aNAUCUBEBP001LgAaKRIOSTESSLgAaLOCAL_aSCPALQAaSEATSIAAaANDIAAaTICKETS",
"address": "nauCUBEBP001.KRIOSTESS.local",
"database": "aSCPALQAaSeatsIAAaandIAAaTickets"
},
"editing": true,
"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",
"lastBuildTime": "2019-06-06T04:37:37"
},
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2020"
]
}
},
"instanceid": "2218F-A50E-5E",
"isCascading": false,
"disabled": 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 Donation Events",
"1920 Broadway Deposit",
"1920 Choreographers' Showcase",
"1920 The Studio Series",
"1920 West Las Vegas Arts"
]
}
}
}
],
"model": {
"instanceid": "D1163-A9AF-EE",
"__store": [
"[SEASON.Season Type]",
"[PERFORMANCE DETAIL.Production Season]"
]
},
"isCascading": true,
"instanceid": "7D69D-768E-70",
"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"
]
}
}
},
"instanceid": "E01D8-2393-47",
"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",
"",
"EDU Matinees"
]
}
}
},
"instanceid": "0D87E-D5A2-F0",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Layer Type",
"dim": "[PERFORMANCE PRICING.Price Layer Type]",
"datatype": "text",
"merged": true,
"title": "Price Layer 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-07-17T02:41:07"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Facility Fee"
]
}
}
},
"instanceid": "2824A-A495-B3",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "ORDER DATE",
"column": "Date",
"dim": "[ORDER 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",
"lastBuildTime": "2019-08-08T02:48:31"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"2019-06-30T00:00:00",
"2019-06-29T00:00:00",
"2019-06-28T00:00:00",
"2019-06-27T00:00:00",
"2019-06-26T00:00:00",
"2019-06-25T00:00:00",
"2019-06-24T00:00:00",
"2019-06-23T00:00:00",
"2019-06-22T00:00:00",
"2019-06-21T00:00:00",
"2019-06-20T00:00:00",
"2019-06-19T00:00:00",
"2019-06-18T00:00:00",
"2019-06-10T00:00:00",
"2019-06-17T00:00:00",
"2019-06-16T00:00:00",
"2019-06-15T00:00:00",
"2019-06-14T00:00:00",
"2019-06-13T00:00:00",
"2019-06-12T00:00:00",
"2019-06-11T00:00:00",
"2019-06-09T00:00:00",
"2019-06-08T00:00:00",
"2019-06-07T00:00:00",
"2019-06-06T00:00:00",
"2019-06-05T00:00:00",
"2019-06-04T00:00:00",
"2019-06-03T00:00:00",
"2019-06-02T00:00:00",
"2019-06-01T00:00:00",
"2019-05-31T00:00:00",
"2019-05-30T00:00:00",
"2019-05-29T00:00:00",
"2019-05-28T00:00:00",
"2019-05-27T00:00:00",
"2019-05-26T00:00:00",
"2019-05-25T00:00:00",
"2019-05-24T00:00:00",
"2019-05-23T00:00:00",
"2019-05-21T00:00:00",
"2019-05-22T00:00:00",
"2019-05-20T00:00:00",
"2019-05-19T00:00:00",
"2019-05-18T00:00:00",
"2019-05-17T00:00:00",
"2019-05-16T00:00:00",
"2019-05-15T00:00:00",
"2019-05-14T00:00:00",
"2019-05-13T00:00:00",
"2019-05-12T00:00:00",
"2019-05-11T00:00:00",
"2019-05-10T00:00:00",
"2019-05-09T00:00:00",
"2019-05-08T00:00:00",
"2019-05-07T00:00:00",
"2019-05-06T00:00:00",
"2019-05-05T00:00:00",
"2019-05-04T00:00:00",
"2019-05-03T00:00:00",
"2019-05-02T00:00:00",
"2019-05-01T00:00:00",
"2019-04-30T00:00:00",
"2019-04-29T00:00:00",
"2019-04-28T00:00:00",
"2019-04-27T00:00:00",
"2019-04-26T00:00:00",
"2019-04-25T00:00:00",
"2019-04-24T00:00:00",
"2019-04-23T00:00:00",
"2019-04-22T00:00:00",
"2019-04-21T00:00:00",
"2019-04-20T00:00:00",
"2019-04-19T00:00:00",
"2019-04-18T00:00:00",
"2019-04-17T00:00:00",
"2019-04-16T00:00:00",
"2019-04-15T00:00:00",
"2019-04-14T00:00:00",
"2019-04-13T00:00:00",
"2019-04-12T00:00:00",
"2019-04-11T00:00:00",
"2019-04-10T00:00:00",
"2019-04-09T00:00:00",
"2019-04-08T00:00:00",
"2019-04-07T00:00:00",
"2019-04-06T00:00:00",
"2019-04-05T00:00:00",
"2019-04-04T00:00:00",
"2019-04-03T00:00:00",
"2019-04-02T00:00:00",
"2019-04-01T00:00:00",
"2019-03-31T00:00:00",
"2019-03-30T00:00:00",
"2019-03-29T00:00:00",
"2019-03-28T00:00:00",
"2019-03-27T00:00:00",
"2019-03-26T00:00:00",
"2019-03-25T00:00:00",
"2019-03-24T00:00:00",
"2019-03-23T00:00:00",
"2019-03-22T00:00:00",
"2019-03-21T00:00:00",
"2019-03-20T00:00:00",
"2019-03-19T00:00:00",
"2019-03-18T00:00:00",
"2019-03-17T00:00:00",
"2019-03-16T00:00:00",
"2019-03-15T00:00:00",
"2019-03-14T00:00:00",
"2019-03-13T00:00:00",
"2019-03-12T00:00:00",
"2019-03-11T00:00:00",
"2019-03-10T00:00:00",
"2019-03-09T00:00:00",
"2019-03-08T00:00:00",
"2019-03-07T00:00:00",
"2019-03-06T00:00:00",
"2019-03-05T00:00:00",
"2019-03-04T00:00:00",
"2019-03-03T00:00:00",
"2019-03-02T00:00:00",
"2019-03-01T00:00:00",
"2019-02-28T00:00:00",
"2019-02-27T00:00:00",
"2019-02-26T00:00:00",
"2019-02-25T00:00:00",
"2019-02-24T00:00:00",
"2019-02-23T00:00:00",
"2019-02-22T00:00:00",
"2019-02-21T00:00:00",
"2019-02-20T00:00:00",
"2019-02-19T00:00:00",
"2019-02-18T00:00:00",
"2019-02-17T00:00:00",
"2019-02-16T00:00:00",
"2019-02-15T00:00:00",
"2019-02-14T00:00:00",
"2019-02-13T00:00:00",
"2019-02-12T00:00:00",
"2019-02-11T00:00:00",
"2019-02-10T00:00:00",
"2019-02-09T00:00:00",
"2019-02-08T00:00:00",
"2019-02-07T00:00:00",
"2019-02-06T00:00:00",
"2019-02-05T00:00:00",
"2019-02-04T00:00:00",
"2019-02-03T00:00:00",
"2019-02-02T00:00:00",
"2019-02-01T00:00:00",
"2019-01-31T00:00:00",
"2019-01-30T00:00:00",
"2019-01-29T00:00:00",
"2019-01-28T00:00:00",
"2019-01-27T00:00:00",
"2019-01-26T00:00:00",
"2019-01-25T00:00:00",
"2019-01-24T00:00:00",
"2019-01-23T00:00:00",
"2019-01-22T00:00:00",
"2019-01-21T00:00:00",
"2019-01-20T00:00:00",
"2019-01-19T00:00:00",
"2019-01-18T00:00:00",
"2019-01-17T00:00:00",
"2019-01-16T00:00:00",
"2019-01-15T00:00:00",
"2019-01-14T00:00:00",
"2019-01-13T00:00:00",
"2019-01-12T00:00:00",
"2019-01-11T00:00:00",
"2019-01-10T00:00:00",
"2019-01-09T00:00:00",
"2019-01-08T00:00:00",
"2019-01-07T00:00:00",
"2019-01-06T00:00:00",
"2019-01-05T00:00:00",
"2019-01-04T00:00:00",
"2019-01-03T00:00:00",
"2019-01-02T00:00:00",
"2019-01-01T00:00:00",
"2018-12-31T00:00:00",
"2018-12-30T00:00:00",
"2018-12-29T00:00:00",
"2018-12-28T00:00:00",
"2018-12-27T00:00:00",
"2018-12-26T00:00:00",
"2018-12-25T00:00:00",
"2018-12-24T00:00:00",
"2018-12-23T00:00:00",
"2018-12-22T00:00:00",
"2018-12-21T00:00:00",
"2018-12-20T00:00:00",
"2018-12-19T00:00:00",
"2018-12-18T00:00:00",
"2018-12-17T00:00:00",
"2018-12-16T00:00:00",
"2018-12-15T00:00:00",
"2018-12-14T00:00:00",
"2018-12-13T00:00:00",
"2018-12-12T00:00:00",
"2018-12-11T00:00:00",
"2018-12-10T00:00:00",
"2018-12-09T00:00:00",
"2018-12-08T00:00:00",
"2018-12-07T00:00:00",
"2018-12-06T00:00:00",
"2018-12-05T00:00:00",
"2018-12-04T00:00:00",
"2018-12-03T00:00:00",
"2018-12-02T00:00:00",
"2018-12-01T00:00:00",
"2018-11-30T00:00:00",
"2018-11-29T00:00:00",
"2018-11-28T00:00:00",
"2018-11-27T00:00:00",
"2018-11-26T00:00:00",
"2018-11-25T00:00:00",
"2018-11-24T00:00:00",
"2018-11-23T00:00:00",
"2018-11-22T00:00:00",
"2018-11-21T00:00:00",
"2018-11-20T00:00:00",
"2018-11-19T00:00:00",
"2018-11-18T00:00:00",
"2018-11-17T00:00:00",
"2018-11-16T00:00:00",
"2018-11-15T00:00:00",
"2018-11-14T00:00:00",
"2018-11-13T00:00:00",
"2018-11-12T00:00:00",
"2018-11-11T00:00:00",
"2018-11-10T00:00:00",
"2018-11-09T00:00:00",
"2018-11-08T00:00:00",
"2018-11-07T00:00:00",
"2018-11-06T00:00:00",
"2018-11-05T00:00:00",
"2018-11-04T00:00:00",
"2018-11-03T00:00:00",
"2018-11-02T00:00:00",
"2018-11-01T00:00:00",
"2018-10-31T00:00:00",
"2018-10-30T00:00:00",
"2018-10-29T00:00:00",
"2018-10-28T00:00:00",
"2018-10-27T00:00:00",
"2018-10-26T00:00:00",
"2018-10-24T00:00:00",
"2018-10-25T00:00:00",
"2018-10-23T00:00:00",
"2018-10-22T00:00:00",
"2018-10-21T00:00:00",
"2018-10-20T00:00:00",
"2018-10-19T00:00:00",
"2018-10-18T00:00:00",
"2018-10-17T00:00:00",
"2018-10-16T00:00:00",
"2018-10-15T00:00:00",
"2018-10-14T00:00:00",
"2018-10-13T00:00:00",
"2018-10-12T00:00:00",
"2018-10-11T00:00:00",
"2018-10-10T00:00:00",
"2018-10-09T00:00:00",
"2018-10-08T00:00:00",
"2018-10-07T00:00:00",
"2018-10-06T00:00:00",
"2018-10-05T00:00:00",
"2018-10-04T00:00:00",
"2018-10-03T00:00:00",
"2018-10-02T00:00:00",
"2018-10-01T00:00:00",
"2018-09-30T00:00:00",
"2018-09-29T00:00:00",
"2018-09-28T00:00:00",
"2018-09-27T00:00:00",
"2018-09-26T00:00:00",
"2018-09-25T00:00:00",
"2018-09-24T00:00:00",
"2018-09-23T00:00:00",
"2018-09-22T00:00:00",
"2018-09-21T00:00:00",
"2018-09-20T00:00:00",
"2018-09-19T00:00:00",
"2018-09-18T00:00:00",
"2018-09-17T00:00:00",
"2018-09-16T00:00:00",
"2018-09-15T00:00:00",
"2018-09-14T00:00:00",
"2018-09-13T00:00:00",
"2018-09-12T00:00:00",
"2018-09-11T00:00:00",
"2018-09-10T00:00:00",
"2018-09-09T00:00:00",
"2018-09-08T00:00:00",
"2018-09-07T00:00:00",
"2018-09-06T00:00:00",
"2018-09-05T00:00:00",
"2018-09-04T00:00:00",
"2018-09-03T00:00:00",
"2018-09-02T00:00:00",
"2018-09-01T00:00:00",
"2018-08-31T00:00:00",
"2018-08-30T00:00:00",
"2018-08-29T00:00:00",
"2018-08-28T00:00:00",
"2018-08-27T00:00:00",
"2018-08-26T00:00:00",
"2018-08-25T00:00:00",
"2018-08-24T00:00:00",
"2018-08-23T00:00:00",
"2018-08-22T00:00:00",
"2018-08-21T00:00:00",
"2018-08-20T00:00:00",
"2018-08-19T00:00:00",
"2018-08-18T00:00:00",
"2018-08-17T00:00:00",
"2018-08-16T00:00:00",
"2018-08-15T00:00:00",
"2018-08-14T00:00:00"
]
},
"filter": {
"last": {
"count": 360,
"offset": 0
}
}
}
},
"instanceid": "55663-1393-65",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"parentFolder": "5d24c0371f5cfb1ad0ef75e2",
"defaultFilters": [
{
"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": [
"2019"
]
}
},
"isCascading": false,
"disabled": false
},
{
"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",
"lastBuildTime": "2019-06-06T04:37:37"
},
"filter": {
"from": "2019-07-01",
"to": "2020-06-30"
}
},
"isCascading": false,
"disabled": 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",
"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 Donation Events",
"1920 Broadway Deposit",
"1920 Choreographers' Showcase",
"1920 The Studio Series",
"1819 BLV Season Showcase",
"1819 Donation Events",
"1819 Indy Fundraiser",
"1819 Opening Night Reception",
"1819 PAH Test",
"1819 Sugar Plum Party",
"1819 The Heart of Education",
"1819 Zion's Youth Symphony 11",
"1819 Am I Enough? Find My...",
"1819 IndyForums: Question 3",
"1819 Future Dance",
"1819 Shapiro Project",
"1819 Annaleigh Ashford",
"1819 Charlie Week 2"
]
}
}
}
],
"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",
"",
"EDU Matinees"
]
}
}
},
"isCascading": false,
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE PRICING",
"column": "Price Layer Type",
"dim": "[PERFORMANCE PRICING.Price Layer Type]",
"datatype": "text",
"merged": true,
"title": "Price Layer 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-07-17T02:41:07"
},
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Facility Fee"
]
}
}
},
"isCascading": false,
"disabled": false
}
],
"isPublic": null,
"settings": {
"autoUpdateOnFiltersChange": false
},
"subscription": {
"isDataChange": true,
"type": "onUpdate",
"schedule": "* * * * * *",
"timezone": 300,
"tzName": "America/Chicago",
"context": {
"dashboardid": "5d322c971f5cfb1ad0efc79b"
},
"active": false,
"executionPerDay": 1,
"reportType": {
"inline": true
},
"emailSettings": {
"isEmail": true,
"isPdf": false
}
},
"widgets": [
{
"title": "Total by Month",
"subtype": "pivot",
"desc": null,
"source": null,
"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-08T02:43:54"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Period",
"dim": "[PERFORMANCE DATE.Fiscal Period]",
"datatype": "numeric",
"title": "Fiscal Period"
},
"field": {
"id": "[PERFORMANCE DATE.Fiscal Period]",
"index": 0
},
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Calendar Month Name",
"dim": "[PERFORMANCE DATE.Calendar Month Name]",
"datatype": "text",
"merged": true,
"title": "Month"
},
"field": {
"id": "[PERFORMANCE DATE.Calendar Month Name]",
"index": 1
},
"format": {
"subtotal": true
},
"disabled": false
},
{
"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"
],
"field": {
"index": 1
},
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"field": {
"index": 2
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "Events"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance Date and Code]_count",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B923C-1AF]),[F1691-98B])",
"context": {
"[F1691-98B]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
},
"[B923C-1AF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
}
},
"title": "Paid Ticket Count"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(sum([B923C-1AF]),[F1691-98B])",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([D9E8A-F0F])",
"context": {
"[D9E8A-F0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Total Seat Count",
"agg": "sum"
},
"[27C46-CD2]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Seat Count"
}
},
"title": "Total Capacity"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([D9E8A-F0F])",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([84ACA-D88]/[CE1A0-203])",
"context": {
"[84ACA-D88]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[CE1A0-203]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "% Sold"
},
"format": {
"mask": {
"decimals": 2,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([84ACA-D88]/[CE1A0-203])",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([F9DEC-75F]),[4DBF0-357])",
"context": {
"[F9DEC-75F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[4DBF0-357]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Ticket Revenue"
},
"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([F9DEC-75F]),[4DBF0-357])",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "(Sum([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"context": {
"[6B73F-DF3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[22514-4D5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[9AE93-DBF]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Average 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([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([A95E5-D8B])",
"context": {
"[A95E5-D8B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"title": "Attended Count"
}
},
"title": "Attendance"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([A95E5-D8B])",
"index": 8
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([9A35B-79B]/[56950-FFF])",
"context": {
"[56950-FFF]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "# of unique Performance Date and Code"
},
"[9A35B-79B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Attended Count"
}
},
"title": "Average Attendance"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"number": {
"separated": true
}
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([9A35B-79B]/[56950-FFF])",
"index": 9
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "5d322c971f5cfb1ad0efc79c",
"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": "50",
"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": "fiscal_period",
"title": "Fiscal Period",
"singular": "Fiscal Period",
"plural": "Fiscal Period"
},
{
"id": "month",
"title": "Month",
"singular": "Month",
"plural": "Month"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "CA27E-E6E4-CD",
"queryStartTime": "2019-08-06T12:52:54",
"widgetTimingLoged": false,
"drawing": true,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"realTimeRefreshing": false,
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"drilledDashboardDisplay": {},
"currentPage": 0
},
{
"title": "Total seats sold from capacity",
"subtype": "indicator/gauge",
"desc": null,
"source": null,
"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": "value",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([FFBCE-1F4]/[EC2EE-6C3])",
"context": {
"[FFBCE-1F4]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[EC2EE-6C3]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "Total seats sold"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
},
"color": {
"type": "color",
"color": "#cc5500"
}
}
}
]
},
{
"name": "secondary",
"items": []
},
{
"name": "min",
"items": [
{
"jaql": {
"formula": "0",
"title": "0 (default)"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
}
}
}
]
},
{
"name": "max",
"items": [
{
"jaql": {
"type": "measure",
"formula": "1",
"context": {},
"title": "1"
},
"format": {
"mask": {
"decimals": 0,
"percent": true
}
}
}
]
},
{
"name": "filters",
"items": []
}
]
},
"oid": "5d322c971f5cfb1ad0efc79d",
"type": "indicator",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
},
"narration": {
"labels": []
},
"indicator/numeric": {
"subtype": "simple",
"skin": "vertical",
"components": {
"title": {
"inactive": false,
"enabled": true
},
"icon": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
},
"indicator/gauge": {
"subtype": "round",
"skin": "1",
"components": {
"ticks": {
"inactive": false,
"enabled": true
},
"labels": {
"inactive": false,
"enabled": true
},
"title": {
"inactive": false,
"enabled": true
},
"secondaryTitle": {
"inactive": true,
"enabled": true
}
}
}
},
"instanceid": "6775A-9A8D-2E",
"queryStartTime": "2019-07-22T15:20:53",
"widgetTimingLoged": false,
"drawing": true,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"realTimeRefreshing": false,
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"disallowSelector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"supportsHierarchies": false
},
"viewState": {
"activeTab": "filters"
}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"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-07-19T02:42:28"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "5d322c971f5cfb1ad0efc79e",
"type": "richtexteditor",
"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": {
"content": {
"html": "This section is all shows at The Smith Center including resident companies and rentals
",
"vAlign": "valign-middle",
"bgColor": "#8b8e09",
"textAlign": "center"
}
},
"instanceid": "4B0FE-B0CE-EC",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
},
{
"title": "Total by Presenter",
"subtype": "pivot",
"desc": null,
"source": null,
"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-08T02:43:54"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type"
},
"field": {
"id": "[SEASON.Season Type]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "count([DF064-CB8])",
"context": {
"[DF064-CB8]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"title": "Performance Date And Code"
}
},
"title": "Events"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "count([DF064-CB8])",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B923C-1AF]),[F1691-98B])",
"context": {
"[F1691-98B]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
},
"[B923C-1AF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
}
},
"title": "Paid Ticket Count"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(sum([B923C-1AF]),[F1691-98B])",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([D9E8A-F0F])",
"context": {
"[D9E8A-F0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Total Seat Count",
"agg": "sum"
},
"[27C46-CD2]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Seat Count"
}
},
"title": "Total Capacity"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([D9E8A-F0F])",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([84ACA-D88]/[CE1A0-203])",
"context": {
"[84ACA-D88]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[CE1A0-203]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "% Sold"
},
"format": {
"mask": {
"decimals": 2,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([84ACA-D88]/[CE1A0-203])",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([F9DEC-75F]),[4DBF0-357])",
"context": {
"[F9DEC-75F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[4DBF0-357]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Ticket Revenue"
},
"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([F9DEC-75F]),[4DBF0-357])",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(Sum([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"context": {
"[6B73F-DF3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[22514-4D5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[9AE93-DBF]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Average 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([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([A95E5-D8B])",
"context": {
"[A95E5-D8B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"title": "Attended Count"
}
},
"title": "Attendance"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([A95E5-D8B])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([9A35B-79B]/[56950-FFF])",
"context": {
"[56950-FFF]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "# of unique Performance Date and Code"
},
"[9A35B-79B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Attended Count"
}
},
"title": "Average Attendance"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"number": {
"separated": true
}
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([9A35B-79B]/[56950-FFF])",
"index": 8
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": []
}
]
},
"oid": "5d322c971f5cfb1ad0efc79f",
"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": "50",
"automaticHeight": true,
"colors": {
"rows": true,
"columns": false,
"headers": false,
"members": false,
"totals": false
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "season_type",
"title": "Season Type",
"singular": "Season Type",
"plural": "Season Type"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "CA27E-E6E4-CD",
"queryStartTime": "2019-08-06T13:25:32",
"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,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"drilledDashboardDisplay": {},
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"drawing": true
},
{
"title": "Total by Venue",
"subtype": "pivot",
"desc": null,
"source": null,
"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-08T02:43:54"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Theater",
"dim": "[PERFORMANCE DETAIL.Theater]",
"datatype": "text",
"merged": true,
"title": "Theater"
},
"field": {
"id": "[PERFORMANCE DETAIL.Theater]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "Events"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance Date and Code]_count",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B923C-1AF]),[F1691-98B])",
"context": {
"[F1691-98B]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
},
"[B923C-1AF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
}
},
"title": "Paid Ticket Count"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(sum([B923C-1AF]),[F1691-98B])",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([D9E8A-F0F])",
"context": {
"[D9E8A-F0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Total Seat Count",
"agg": "sum"
},
"[27C46-CD2]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Seat Count"
}
},
"title": "Total Capacity"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([D9E8A-F0F])",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([84ACA-D88]/[CE1A0-203])",
"context": {
"[84ACA-D88]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[CE1A0-203]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "% Sold"
},
"format": {
"mask": {
"decimals": 2,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([84ACA-D88]/[CE1A0-203])",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([F9DEC-75F]),[4DBF0-357])",
"context": {
"[F9DEC-75F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[4DBF0-357]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Ticket Revenue"
},
"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([F9DEC-75F]),[4DBF0-357])",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(Sum([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"context": {
"[6B73F-DF3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[22514-4D5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[9AE93-DBF]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Average 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([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([A95E5-D8B])",
"context": {
"[A95E5-D8B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"title": "Attended Count"
}
},
"title": "Attendance"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([A95E5-D8B])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([9A35B-79B]/[56950-FFF])",
"context": {
"[56950-FFF]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "# of unique Performance Date and Code"
},
"[9A35B-79B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Attended Count"
}
},
"title": "Average Attendance"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"number": {
"separated": true
}
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([9A35B-79B]/[56950-FFF])",
"index": 8
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Theater",
"dim": "[PERFORMANCE DETAIL.Theater]",
"datatype": "text",
"merged": true,
"title": "Theater",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"EDU Matinees",
"Shuttle Bus",
""
]
}
},
"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-06-08T02:43:54"
}
}
}
]
}
]
},
"oid": "5d322c971f5cfb1ad0efc7a0",
"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": "50",
"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": "theater",
"title": "Theater",
"singular": "Theater",
"plural": "Theater"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "CA27E-E6E4-CD",
"queryStartTime": "2019-08-06T12:52:54",
"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,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"drilledDashboardDisplay": {},
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"desc": null,
"source": null,
"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-07-19T02:42:28"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"oid": "5d322c971f5cfb1ad0efc7a1",
"type": "richtexteditor",
"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": {
"content": {
"html": "This section is The Smith Center Presents which includes Broadway
",
"vAlign": "valign-middle",
"bgColor": "#8b8e09",
"textAlign": "center"
}
},
"instanceid": "E587C-A41A-5D",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
},
{
"title": "Total by Month",
"subtype": "pivot",
"desc": null,
"source": null,
"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-08T02:43:54"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Fiscal Period",
"dim": "[PERFORMANCE DATE.Fiscal Period]",
"datatype": "numeric",
"title": "Fiscal Period"
},
"field": {
"id": "[PERFORMANCE DATE.Fiscal Period]",
"index": 0
},
"disabled": false
},
{
"jaql": {
"table": "PERFORMANCE DATE",
"column": "Calendar Month Name",
"dim": "[PERFORMANCE DATE.Calendar Month Name]",
"datatype": "text",
"merged": true,
"title": "Month"
},
"field": {
"id": "[PERFORMANCE DATE.Calendar Month Name]",
"index": 1
},
"format": {
"subtotal": true
},
"disabled": false
},
{
"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"
],
"field": {
"index": 1
},
"disabled": true
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Production Season",
"dim": "[PERFORMANCE DETAIL.Production Season]",
"datatype": "text",
"merged": true,
"title": "Production Season"
},
"field": {
"index": 2
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "Events"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance Date and Code]_count",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B923C-1AF]),[F1691-98B])",
"context": {
"[F1691-98B]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
},
"[B923C-1AF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
}
},
"title": "Paid Ticket Count"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(sum([B923C-1AF]),[F1691-98B])",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([D9E8A-F0F])",
"context": {
"[D9E8A-F0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Total Seat Count",
"agg": "sum"
},
"[27C46-CD2]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Seat Count"
}
},
"title": "Total Capacity"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([D9E8A-F0F])",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([84ACA-D88]/[CE1A0-203])",
"context": {
"[84ACA-D88]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[CE1A0-203]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "% Sold"
},
"format": {
"mask": {
"decimals": 2,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([84ACA-D88]/[CE1A0-203])",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([F9DEC-75F]),[4DBF0-357])",
"context": {
"[F9DEC-75F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[4DBF0-357]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Ticket Revenue"
},
"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([F9DEC-75F]),[4DBF0-357])",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "(Sum([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"context": {
"[6B73F-DF3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[22514-4D5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[9AE93-DBF]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Average 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([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([A95E5-D8B])",
"context": {
"[A95E5-D8B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"title": "Attended Count"
}
},
"title": "Attendance"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([A95E5-D8B])",
"index": 8
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([9A35B-79B]/[56950-FFF])",
"context": {
"[56950-FFF]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "# of unique Performance Date and Code"
},
"[9A35B-79B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Attended Count"
}
},
"title": "Average Attendance"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"number": {
"separated": true
}
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([9A35B-79B]/[56950-FFF])",
"index": 9
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Bad Season",
"Education",
"Las Vegas Philharmonic",
"Merchandise",
"Nevada Ballet Theatre",
"Tours",
"Rentals"
]
}
},
"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-06-08T02:43:54"
}
}
}
]
}
]
},
"oid": "5d322c971f5cfb1ad0efc7a2",
"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": "50",
"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": "fiscal_period",
"title": "Fiscal Period",
"singular": "Fiscal Period",
"plural": "Fiscal Period"
},
{
"id": "month",
"title": "Month",
"singular": "Month",
"plural": "Month"
},
{
"id": "days",
"title": "days",
"singular": "days",
"plural": "days"
},
{
"id": "production_season",
"title": "Production Season",
"singular": "Production Season",
"plural": "Production Season"
},
{
"id": "season_type",
"title": "Season Type",
"singular": "Season Type",
"plural": "Season Type"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "CA27E-E6E4-CD",
"queryStartTime": "2019-08-06T12:52:54",
"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,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"drilledDashboardDisplay": {},
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"drawing": true
},
{
"title": "Total by Venue",
"subtype": "pivot",
"desc": null,
"source": null,
"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-08T02:43:54"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Theater",
"dim": "[PERFORMANCE DETAIL.Theater]",
"datatype": "text",
"merged": true,
"title": "Theater"
},
"field": {
"id": "[PERFORMANCE DETAIL.Theater]",
"index": 0
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "Events"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "[PERFORMANCE DETAIL.Performance Date and Code]_count",
"index": 1
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([B923C-1AF]),[F1691-98B])",
"context": {
"[F1691-98B]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
},
"[B923C-1AF]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Count",
"dim": "[SEAT & TICKET VALUES.Ticket Count]",
"datatype": "numeric",
"title": "Ticket Count"
}
},
"title": "Paid Ticket Count"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "(sum([B923C-1AF]),[F1691-98B])",
"index": 2
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([D9E8A-F0F])",
"context": {
"[D9E8A-F0F]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Total Seat Count",
"agg": "sum"
},
"[27C46-CD2]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"title": "Seat Count"
}
},
"title": "Total Capacity"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([D9E8A-F0F])",
"index": 3
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([84ACA-D88]/[CE1A0-203])",
"context": {
"[84ACA-D88]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[CE1A0-203]": {
"table": "SEAT & TICKET VALUES",
"column": "Seat Count",
"dim": "[SEAT & TICKET VALUES.Seat Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Seat Count"
}
},
"title": "% Sold"
},
"format": {
"mask": {
"decimals": 2,
"percent": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([84ACA-D88]/[CE1A0-203])",
"index": 4
}
},
{
"jaql": {
"type": "measure",
"formula": "(sum([F9DEC-75F]),[4DBF0-357])",
"context": {
"[F9DEC-75F]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"title": "Ticket Paid Amount"
},
"[4DBF0-357]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Ticket Revenue"
},
"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([F9DEC-75F]),[4DBF0-357])",
"index": 5
}
},
{
"jaql": {
"type": "measure",
"formula": "(Sum([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"context": {
"[6B73F-DF3]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Amount",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Amount"
},
"[22514-4D5]": {
"table": "SEAT & TICKET VALUES",
"column": "Ticket Paid Count",
"dim": "[SEAT & TICKET VALUES.Ticket Paid Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Ticket Paid Count"
},
"[9AE93-DBF]": {
"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": [
"Comp",
"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-06-08T02:43:54"
}
}
},
"title": "Average 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([6B73F-DF3]/[22514-4D5]),[9AE93-DBF])",
"index": 6
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([A95E5-D8B])",
"context": {
"[A95E5-D8B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"title": "Attended Count"
}
},
"title": "Attendance"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([A95E5-D8B])",
"index": 7
}
},
{
"jaql": {
"type": "measure",
"formula": "sum([9A35B-79B]/[56950-FFF])",
"context": {
"[56950-FFF]": {
"table": "PERFORMANCE DETAIL",
"column": "Performance Date and Code",
"dim": "[PERFORMANCE DETAIL.Performance Date and Code]",
"datatype": "text",
"merged": true,
"agg": "count",
"title": "# of unique Performance Date and Code"
},
"[9A35B-79B]": {
"table": "SEAT & TICKET VALUES",
"column": "Attended Count",
"dim": "[SEAT & TICKET VALUES.Attended Count]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Attended Count"
}
},
"title": "Average Attendance"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"number": {
"separated": true
}
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"id": "sum([9A35B-79B]/[56950-FFF])",
"index": 8
}
}
]
},
{
"name": "columns",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "SEASON",
"column": "Season Type",
"dim": "[SEASON.Season Type]",
"datatype": "text",
"merged": true,
"title": "Season Type",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Bad Season",
"Education",
"Merchandise",
"Tours",
"Las Vegas Philharmonic",
"Nevada Ballet Theatre",
"Rentals"
]
}
},
"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-08T02:43:54"
}
}
},
{
"jaql": {
"table": "PERFORMANCE DETAIL",
"column": "Theater",
"dim": "[PERFORMANCE DETAIL.Theater]",
"datatype": "text",
"merged": true,
"title": "Theater",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"EDU Matinees",
"Shuttle Bus",
""
]
}
},
"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-06-08T02:43:54"
}
}
}
]
}
]
},
"oid": "5d322c971f5cfb1ad0efc7a3",
"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": "50",
"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": "theater",
"title": "Theater",
"singular": "Theater",
"plural": "Theater"
},
{
"id": "season_type",
"title": "Season Type",
"singular": "Season Type",
"plural": "Season Type"
}
]
},
"rowsGrandTotal": true
},
"instanceid": "CA27E-E6E4-CD",
"queryStartTime": "2019-08-06T12:52:54",
"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,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"drilledDashboardDisplay": {},
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5d361bd21f5cfb1ad0efcf3f",
"desc": null,
"source": null,
"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-07-22T03:13:05"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [],
"all": false
},
"panels": []
},
"type": "richtexteditor",
"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": {
"content": {
"html": "All data in this dashboard is for all shows that have happened to date
",
"vAlign": "valign-middle",
"bgColor": "#8b8e09",
"textAlign": "center"
}
},
"instanceid": "98F14-AEB4-C2",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5d322c971f5cfb1ad0efc79b",
"options": {
"triggersDomready": true,
"hideFromWidgetList": true,
"disableExportToCSV": true,
"disableExportToImage": true,
"toolbarButton": {
"css": "add-rich-text",
"tooltip": "RICHTEXT_MAIN.TOOLBAR_BUTTON"
},
"selector": false,
"disallowSelector": true,
"disallowWidgetTitle": true,
"supportsHierarchies": false,
"dashboardFiltersMode": "filter"
}
}
],
"hierarchies": []
}