{ "title": "Revenue Breakdown-May2021 (1)", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "_id": "5c8a922a57e0998fbff7950b", "colors": [ "#A3D6AC", "#DFE47B", "#99C75C", "#359575", "#008066", "#4189A5", "#76BDD0", "#A1CFD5", "#889BA3", "#EE6F5C", "#EE995C", "#EED75C", "#B9D7B6" ], "name": "Meadow", "isDefault": false, "sortOrder": 20, "isSystem": true } }, "layout": { "instanceid": "E2FEC-9B91-A4", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "60c285adf7fb0b32a84d6144" } ], "width": 100, "stretchable": false, "pxlWidth": 1107, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "60c285adf7fb0b32a84d614b" } ], "width": 50, "stretchable": false, "pxlWidth": 554, "index": 0 }, { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": 384, "defaultWidth": 512, "widgetid": "60c286a5f7fb0b32a84d6195" } ], "width": 50, "stretchable": false, "pxlWidth": 553, "index": 1 } ] } ], "pxlWidth": 1107, "index": 0 } ], "container": {} }, "original": null, "oid": "60c285adf7fb0b32a84d613b", "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "editing": true, "filters": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "collapsed": true, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-05-06T02:41:22" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "2021 Zoo Admissions", "2021 Zoo Admissions Advanced", "2020 Zoo Admissions Advanced", "2020 Zoo Admissions", "2019 Zoo Admissions", "2019 Zoo Admissions Advanced", "2018 Zoo Admissions Advanced", "2018 Zoo Admissions" ] } }, "instanceid": "E1D6C-7D24-62", "isCascading": false, "disabled": false }, { "jaql": { "datatype": "datetime", "dim": "[ORDER DATE.Date (Calendar)]", "title": "Years in Date", "level": "years", "column": "Date", "table": "ORDER DATE", "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "collapsed": true, "merged": true, "filter": { "explicit": true, "multiSelection": true, "members": [ "2021-01-01T00:00:00" ] } }, "instanceid": "27AD9-825A-9F", "isCascading": false, "disabled": false }, { "jaql": { "datatype": "numeric", "dim": "[TICKET.Calendar Year1]", "title": "Calendar Year", "column": "Calendar Year", "table": "ORDER DATE", "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-05-06T02:41:22" }, "collapsed": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "A44A4-3E7E-0B", "isCascading": false, "disabled": false }, { "jaql": { "datatype": "text", "dim": "[ORDER DATE.Calendar Month Sort]", "title": "Calendar Month Sort", "column": "Calendar Month Sort", "table": "ORDER DATE", "collapsed": true, "merged": true, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets", "lastBuildTime": "2021-05-06T02:41:22" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "04 April", "05 May" ], "filter": { "turnedOff": true, "exclude": { "members": [ "04 April" ] } } } }, "instanceid": "1CDA6-F869-B4", "isCascading": false, "disabled": false } ], "filterToDatasourceMapping": {}, "isPublic": null, "parentFolder": null, "widgets": [ { "title": "Revenue Breakdown", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Group", "dim": "[PERFORMANCE PRICING.Price Type Group]", "datatype": "text", "merged": true, "title": "Category", "sortDetails": { "field": 0, "dir": "desc", "sortingLastDimension": false, "measurePath": null, "initialized": true }, "sort": "desc" }, "field": { "id": "[PERFORMANCE PRICING.Price Type Group]", "index": 0 }, "format": { "subtotal": true, "width": 144 } }, { "jaql": { "table": "PRICING RULE", "column": "Pricing Rule", "dim": "[PRICING.Pricing Rule1]", "datatype": "text", "merged": true, "title": "Pricing Rule" }, "field": { "id": "[PRICING.Pricing Rule1]", "index": 1 } }, { "jaql": { "table": "ZONE", "column": "Zone", "dim": "[ZONE.Zone]", "datatype": "text", "merged": true, "title": "Zone" }, "field": { "index": 2 }, "disabled": true }, { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type", "dim": "[PERFORMANCE PRICING.Price Type]", "datatype": "text", "merged": true, "title": "Price Type" }, "field": { "id": "[PERFORMANCE PRICING.Price Type]", "index": 2 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "sum([F48B7-5E4])", "context": { "[9A056-4E0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } }, "[F48B7-5E4]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "Tickets Sold" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([F48B7-5E4])", "index": 3 } }, { "jaql": { "type": "measure", "formula": "[DA8CD-C81]/[82035-A21]", "context": { "[DA8CD-C81]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Home Value", "dim": "[SEAT & TICKET VALUES.Ticket Home Value]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Home Value" }, "[82035-A21]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "Undiscounted Price" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" }, "width": 121 }, "field": { "id": "[DA8CD-C81]/[82035-A21]", "index": 4 } }, { "jaql": { "type": "measure", "formula": "(([D0926-4E7]/[FC0B2-8A6]) -([B1709-86B]/[60E8C-AA0]))/([B1709-86B]/[60E8C-AA0])", "context": { "[D0926-4E7]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[B1709-86B]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Home Value", "dim": "[SEAT & TICKET VALUES.Ticket Home Value]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Home Value" }, "[FC0B2-8A6]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" }, "[60E8C-AA0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Count" } }, "title": "Discount" }, "format": { "mask": { "decimals": 0, "percent": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(([D0926-4E7]/[FC0B2-8A6]) -([B1709-86B]/[60E8C-AA0]))/([B1709-86B]/[60E8C-AA0])", "index": 5 } }, { "jaql": { "type": "measure", "formula": "[B93FD-037]/[DAC1B-4CB]", "context": { "[B93FD-037]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "[DAC1B-4CB]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Count", "dim": "[SEAT & TICKET VALUES.Ticket Paid Count]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Count" } }, "title": "Effetive Price" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[B93FD-037]/[DAC1B-4CB]", "index": 6 } }, { "jaql": { "type": "measure", "formula": "sum([EE296-C1F])", "context": { "[FB842-3C0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" }, "[EE296-C1F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "Revenue" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "sum([EE296-C1F])", "index": 7 } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Variance to Ticket Home Value", "dim": "[SEAT & TICKET VALUES.Variance to Ticket Home Value]", "datatype": "numeric", "agg": "sum", "title": "Loss To Discount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Variance to Ticket Home Value]_sum", "index": 8 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE PRICING", "column": "Price Type Group", "dim": "[PERFORMANCE PRICING.Price Type Group]", "datatype": "text", "merged": true, "title": "Price Type Group", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } }, "title": "Price Type Group" }, { "jaql": { "type": "measure", "formula": "sum([AE440-6F8])", "context": { "[FA71D-5CC]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } }, "[AE440-6F8]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "sum([Ticket Count1])", "filter": { "fromNotEqual": "1" }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } }, { "jaql": { "type": "measure", "formula": "sum([F48B7-5E4])", "context": { "[9A056-4E0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } }, "[F48B7-5E4]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Count", "dim": "[SEAT & TICKET VALUES.Ticket Count]", "datatype": "numeric", "title": "Ticket Count", "filter": { "explicit": false, "multiSelection": true, "all": true }, "collapsed": false, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "sum([Ticket Count1])", "filter": { "fromNotEqual": 0 }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } }, { "jaql": { "type": "measure", "formula": "sum([EE296-C1F])", "context": { "[FB842-3C0]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount" }, "[EE296-C1F]": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" } } }, "title": "sum([Ticket Paid Amount])", "filter": { "fromNotEqual": "1" }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "collapsed": false }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true } } }, { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "title": "Ticket Paid Amount", "filter": { "explicit": false, "multiSelection": true, "exclude": { "members": [ "0" ] } }, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "collapsed": true } } ] } ] }, "oid": "60c285adf7fb0b32a84d6144", "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": false, "columns": true, "headers": true, "members": false, "totals": true }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "category", "title": "Category", "singular": "Category", "plural": "Category" }, { "id": "pricing_rule", "title": "Pricing Rule", "singular": "Pricing Rule", "plural": "Pricing Rule" }, { "id": "zone", "title": "Zone", "singular": "Zone", "plural": "Zone" }, { "id": "price_type", "title": "Price Type", "singular": "Price Type", "plural": "Price Type" }, { "id": "price_type_group", "title": "Price Type Group", "singular": "Price Type Group", "plural": "Price Type Group" }, { "id": "ticket_paid_amount", "title": "Ticket Paid Amount", "singular": "Ticket Paid Amount", "plural": "Ticket Paid Amount" } ] }, "rowsGrandTotal": true }, "instanceid": "AF062-783E-C0", "queryStartTime": "2021-06-09T16:31:40", "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 }, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "dashboardid": "60c285adf7fb0b32a84d613b", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "canEditFilters": true }, { "title": "", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "Finance", "fullname": "owl.calgaryzoo.ab.ca/Finance", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aFINANCE", "address": "owl.calgaryzoo.ab.ca", "database": "aFinance", "lastBuildTime": "2021-06-10T02:27:40" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": true }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "TRANSACTION CREATE DATE", "column": "Date", "dim": "[TRANSACTION CREATE 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": { "id": "[TRANSACTION CREATE DATE.Date (Calendar)]_days", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "FINANCE VALUES", "column": "Ticket Paid Amount", "dim": "[FINANCE VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[FINANCE VALUES.Ticket Paid Amount]_sum", "index": 1 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "PERFORMANCE DETAIL", "column": "Production Season", "dim": "[PERFORMANCE DETAIL.Production Season]", "datatype": "text", "merged": true, "title": "Production Season", "filter": { "explicit": true, "multiSelection": true, "members": [ "2021 Zoo Admissions", "2021 Zoo Admissions Advanced" ] }, "datasource": { "title": "Finance", "fullname": "owl.calgaryzoo.ab.ca/Finance", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aFINANCE", "address": "owl.calgaryzoo.ab.ca", "database": "aFinance" }, "collapsed": true } }, { "jaql": { "table": "TRANSACTION CREATE DATE", "column": "Date", "dim": "[TRANSACTION CREATE DATE.Date (Calendar)]", "datatype": "datetime", "merged": true, "title": "Date", "level": "days", "filter": { "from": "2021-05-01", "to": "2021-05-31" }, "collapsed": true, "datasource": { "title": "Finance", "fullname": "owl.calgaryzoo.ab.ca/Finance", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aFINANCE", "address": "owl.calgaryzoo.ab.ca", "database": "aFinance", "lastBuildTime": "2021-06-10T02:27:40" } }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "isdefault": true } } } ] } ] }, "oid": "60c285adf7fb0b32a84d614b", "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": 32, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days", "title": "days", "singular": "days", "plural": "days" }, { "id": "production_season", "title": "Production Season", "singular": "Production Season", "plural": "Production Season" } ] }, "rowsGrandTotal": true }, "instanceid": "D1443-295A-DC", "queryStartTime": "2021-06-10T15:38:14", "drawing": true, "canEditFilters": true, "widgetTimingLoged": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": false, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": false, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true }, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "dashboardid": "60c285adf7fb0b32a84d613b", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true } }, { "title": "", "subtype": "pivot", "oid": "60c286a5f7fb0b32a84d6195", "desc": null, "source": null, "datasource": { "title": "Seats and Tickets", "fullname": "owl.calgaryzoo.ab.ca/Seats and Tickets", "id": "aOWLLgAaCALGARYZOOLgAaABLgAaCA_aSEATSIAAaANDIAAaTICKETS", "address": "owl.calgaryzoo.ab.ca", "database": "aSeatsIAAaandIAAaTickets" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "ORDER DATE", "column": "Date", "dim": "[ORDER 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": { "id": "[ORDER DATE.Date (Calendar)]_days", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "SEAT & TICKET VALUES", "column": "Ticket Paid Amount", "dim": "[SEAT & TICKET VALUES.Ticket Paid Amount]", "datatype": "numeric", "agg": "sum", "title": "Total Ticket Paid Amount" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[SEAT & TICKET VALUES.Ticket Paid Amount]_sum", "index": 1 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 33, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "days", "title": "days", "singular": "days", "plural": "days" } ] }, "rowsGrandTotal": true }, "instanceid": "EBA81-16E9-55", "queryStartTime": "2021-06-10T15:39:43", "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": "60c285adf7fb0b32a84d613b", "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true } } ], "hierarchies": [] }