{
"title": "December Sales - Gift Vouchers",
"oid": "5dea57d9cff61223a896562b",
"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": "2B0A4-5B6F-D3",
"type": "columnar",
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": "48px",
"defaultWidth": 128,
"widgetid": "5dee30f887cef707f87dc870"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1199,
"index": 0
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dea6720cff61223a896570a",
"height": "368px"
}
],
"width": 31.6930775646372,
"stretchable": false,
"pxlWidth": 380,
"index": 0
},
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dee3a2e87cef707f87dc8fa",
"height": "368px"
}
],
"width": 39.03252710592161,
"stretchable": false,
"pxlWidth": 468,
"index": 1
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dee487d87cef707f87dc9dd",
"height": "368px"
}
],
"width": 29.274395329441198,
"stretchable": false,
"pxlWidth": 351,
"index": 2
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dea65becff61223a89656f1",
"height": "816px"
}
],
"width": 49.3744787322769,
"stretchable": false,
"pxlWidth": 588,
"index": 0
},
{
"elements": [
{
"minHeight": 96,
"maxHeight": 2048,
"minWidth": 128,
"maxWidth": 2048,
"defaultWidth": 512,
"widgetid": "5dee4cf287cef707f87dca50",
"height": "816px"
}
],
"width": 50.6255212677231,
"stretchable": false,
"pxlWidth": 607,
"index": 1
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 2048,
"minWidth": 64,
"maxWidth": 2048,
"height": 128,
"defaultWidth": 128,
"widgetid": "5dee50a487cef707f87dcac7"
}
],
"width": 100,
"stretchable": false,
"pxlWidth": 1199,
"index": 0
}
]
}
],
"pxlWidth": 1199,
"index": 0
}
],
"container": {}
},
"original": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance"
},
"editing": true,
"parentFolder": "5cd4040e12ee411fe48d3666",
"filters": [
{
"jaql": {
"table": "POST DATE",
"column": "Date",
"dim": "[POST.Date1 (Calendar)]",
"datatype": "datetime",
"merged": true,
"title": "Years in Date",
"level": "years",
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"collapsed": true,
"filter": {
"last": {
"count": 1,
"offset": 0
}
}
},
"instanceid": "DA640-0D65-55",
"isCascading": false,
"locked": true
},
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Month Name",
"dim": "[TRANSACTION DATE.Calendar Month Name]",
"datatype": "text",
"merged": true,
"title": "Calendar Month Name",
"collapsed": true,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-09T01:23:27"
},
"filter": {
"explicit": false,
"multiSelection": true,
"all": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"December"
]
}
}
},
"instanceid": "CA6BF-F375-59",
"isCascading": false,
"disabled": false,
"locked": true
},
{
"jaql": {
"datatype": "text",
"dim": "[FINANCE DETAILS.Mode of Sale Category]",
"title": "Mode of Sale Category",
"column": "Mode of Sale Category",
"table": "FINANCE DETAILS",
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"collapsed": true,
"merged": true,
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
}
},
"instanceid": "D19F8-55F5-3F",
"isCascading": false,
"disabled": false
},
{
"jaql": {
"datatype": "numeric",
"dim": "[TRANSACTION.Calendar Year1]",
"title": "Calendar Year",
"column": "Calendar Year",
"table": "TRANSACTION DATE",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"collapsed": true
},
"instanceid": "E7796-1FFB-3A",
"isCascading": false
},
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type",
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-17T00:27:44"
},
"filter": {
"explicit": false,
"multiSelection": true,
"all": true,
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"Gift Voucher"
]
}
}
},
"instanceid": "2C2F2-F9C3-09",
"isCascading": false,
"disabled": false
}
],
"filterToDatasourceMapping": {},
"previewLayout": [
{
"type": "previewLayout",
"format": "A4",
"orientation": "landscape",
"layout": "asis",
"headerSize": "compact",
"title": true,
"elasticubeBuilt": true,
"elasticubeName": true,
"filters": true,
"logo": false,
"pageNumbers": true,
"pages": [
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 127,
"widgetid": "5dee30f887cef707f87dc870"
}
],
"width": 100
}
]
},
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 1024,
"height": 484,
"widgetid": "5dea6720cff61223a896570a"
}
],
"width": 31.6930775646372
},
{
"elements": [
{
"minHeight": 128,
"maxHeight": 1024,
"height": 484,
"widgetid": "5dee3a2e87cef707f87dc8fa"
}
],
"width": 39.03252710592161
},
{
"elements": [
{
"minHeight": 128,
"maxHeight": 1024,
"height": 484,
"widgetid": "5dee487d87cef707f87dc9dd"
}
],
"width": 29.274395329441198
}
]
}
]
}
]
},
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 128,
"maxHeight": 1024,
"height": 624.6299212598425,
"widgetid": "5dea65becff61223a89656f1"
}
],
"width": 49.3744787322769
},
{
"elements": [
{
"minHeight": 128,
"maxHeight": 1024,
"height": 624.6299212598425,
"widgetid": "5dee4cf287cef707f87dca50"
}
],
"width": 50.6255212677231
}
]
}
]
}
]
},
{
"columns": [
{
"width": 100,
"cells": [
{
"subcells": [
{
"elements": [
{
"minHeight": 64,
"maxHeight": 1024,
"height": 179,
"widgetid": "5dee50a487cef707f87dcac7"
}
],
"width": 100
}
]
}
]
}
]
}
],
"savedByButton": "Export",
"openPath": "PDF Settings"
}
],
"subscription": {
"isDataChange": true,
"type": "onUpdate",
"schedule": "* * * * * *",
"timezone": 0,
"tzName": "Europe/Dublin",
"context": {
"dashboardid": "5dea57d9cff61223a896562b"
},
"active": false,
"executionPerDay": 1,
"reportType": {
"inline": true
},
"emailSettings": {
"isEmail": true,
"isPdf": false
}
},
"isPublic": null,
"widgets": [
{
"title": "Day by Day Totals",
"subtype": "pivot",
"oid": "5dea65becff61223a89656f1",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[POST.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "rows",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"field": {
"index": 0
},
"disabled": true
},
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Day Of Month",
"dim": "[TRANSACTION DATE.Calendar Day Of Month]",
"datatype": "numeric",
"title": "Day Of Month"
},
"field": {
"id": "[TRANSACTION DATE.Calendar Day Of Month]",
"index": 0
}
},
{
"jaql": {
"table": "CONSTITUENT",
"column": "Constituent Display Name Short",
"dim": "[CONSTITUENT.Constituent Display Name Short]",
"datatype": "text",
"merged": true,
"title": "Constituent Display Name Short"
},
"field": {
"index": 2
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"agg": "sum",
"title": "Total Credit Amount"
},
"format": {
"mask": {
"type": "number",
"t": true,
"b": true,
"separated": true,
"decimals": "auto",
"isdefault": true
},
"color": {
"type": "color",
"color": "transparent"
}
},
"field": {
"index": 4
},
"disabled": true
},
{
"jaql": {
"type": "measure",
"formula": "sum([E5FF9-310])*-1",
"context": {
"[E5FF9-310]": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount"
}
},
"title": "sum([Transaction Amount])*-1"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color": {
"type": "color",
"color": "transparent"
},
"databars": true
},
"field": {
"id": "sum([E5FF9-310])*-1",
"index": 2,
"min": 100,
"max": 6886
}
}
]
},
{
"name": "columns",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year"
},
"field": {
"id": "[TRANSACTION.Calendar Year1]",
"index": 1
},
"format": {
"width": 124
}
}
]
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year",
"filter": {
"fromNotEqual": "2016"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"title": "Calendar Year"
},
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount",
"filter": {
"toNotEqual": "0"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"disabled": false
}
]
}
]
},
"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": "35",
"automaticHeight": true,
"colors": {
"rows": true,
"columns": false,
"headers": true,
"members": false,
"totals": true
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
},
{
"id": "day_of_month",
"title": "Day Of Month",
"singular": "Day Of Month",
"plural": "Day Of Month"
},
{
"id": "constituent_display_name_short",
"title": "Constituent Display Name Short",
"singular": "Constituent Display Name Short",
"plural": "Constituent Display Name Short"
},
{
"id": "calendar_year",
"title": "Calendar Year",
"singular": "Calendar Year",
"plural": "Calendar Year"
},
{
"id": "transaction_amount",
"title": "Transaction Amount",
"singular": "Transaction Amount",
"plural": "Transaction Amount"
}
]
},
"columnsGrandTotal": false,
"rowsGrandTotal": true
},
"instanceid": "464D3-AC37-FA",
"queryStartTime": "2019-12-17T16:07:45",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"realTimeRefreshing": false,
"viewState": {
"activeTab": "filters"
},
"dashboardid": "5dea57d9cff61223a896562b",
"options": {
"dashboardFiltersMode": "filter",
"selector": false,
"triggersDomready": true,
"drillToAnywhere": true,
"autoUpdateOnEveryChange": true
},
"canEditFilters": true,
"drawing": true
},
{
"title": "Full Month",
"subtype": "column/classic",
"oid": "5dea6720cff61223a896570a",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[POST.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year"
},
"field": {
"id": "[TRANSACTION.Calendar Year1]",
"index": 2
},
"disabled": false
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "sum([E5FF9-310])*-1",
"context": {
"[E5FF9-310]": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount"
}
},
"title": "sum([Transaction Amount])*-1"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "sum([E5FF9-310])*-1",
"index": 3
}
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "BATCH CLOSE DATE",
"column": "Calendar Month",
"dim": "[BATCH.Calendar Month]",
"datatype": "numeric",
"title": "Calendar Month",
"filter": {
"explicit": false,
"multiSelection": true,
"all": true
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year",
"filter": {
"fromNotEqual": "2016"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"title": "Calendar Year"
},
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount",
"filter": {
"toNotEqual": "0"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"disabled": false
}
]
}
]
},
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": -45
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"isIntervalEnabled": true,
"hideMinMax": false
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"lineWidth": {
"width": "bold"
},
"markers": {
"enabled": false,
"fill": "filled",
"size": "small"
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "calendar_year",
"title": "Calendar Year",
"singular": "Calendar Year",
"plural": "Calendar Year"
},
{
"id": "calendar_month",
"title": "Calendar Month",
"singular": "Calendar Month",
"plural": "Calendar Month"
},
{
"id": "transaction_amount",
"title": "Transaction Amount",
"singular": "Transaction Amount",
"plural": "Transaction Amount"
}
]
}
},
"instanceid": "5454F-06E5-DC",
"queryStartTime": "2019-12-17T16:06:48",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"realTimeRefreshing": false,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"dashboardid": "5dea57d9cff61223a896562b",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5dee30f887cef707f87dc870",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-09T01:23:27"
},
"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": "Gift Vouchers - December Sales Race
Data will automatically update each year, but will need to update labels on YTD charts each year.",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "C261F-85CD-FC",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5dea57d9cff61223a896562b",
"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": "Month to Date",
"subtype": "column/classic",
"oid": "5dee3a2e87cef707f87dc8fa",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[POST.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"field": {
"id": "[PAYMENT.Payment Method Type1]",
"index": 0
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "( sum( [74271-9AA] ) , [24CC4-284] )",
"context": {
"[74271-9AA]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[2D718-EAB]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 723
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[24CC4-284]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 731
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2017"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color": {
"color": "#DB4935",
"type": "color"
}
},
"field": {
"id": "( sum( [74271-9AA] ) , [24CC4-284] )",
"index": 3
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "( sum( [D9745-5B7] ) , [6A65D-8FE] )",
"context": {
"[D9745-5B7]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[31BFF-9D5]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 30,
"offset": 0
}
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[6A65D-8FE]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 366
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2018"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color": {
"color": "#F48E06",
"type": "color"
}
},
"field": {
"id": "( sum( [D9745-5B7] ) , [6A65D-8FE] )",
"index": 2
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"context": {
"[2FE62-F41]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[EED68-C91]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 0
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[E3015-9A6]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 1
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2019"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"index": 1
},
"disabled": false
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year",
"filter": {
"fromNotEqual": "2016"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"title": "Calendar Year"
},
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount",
"filter": {
"toNotEqual": "0"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"disabled": false
}
]
}
]
},
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": false,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": -45
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
},
{
"id": "calendar_year",
"title": "Calendar Year",
"singular": "Calendar Year",
"plural": "Calendar Year"
},
{
"id": "transaction_amount",
"title": "Transaction Amount",
"singular": "Transaction Amount",
"plural": "Transaction Amount"
}
]
}
},
"instanceid": "4AA59-B544-1D",
"queryStartTime": "2019-12-17T16:07:09",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"realTimeRefreshing": false,
"viewState": {
"activeTab": "filters"
},
"canEditFilters": true,
"dashboardid": "5dea57d9cff61223a896562b",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"drawing": true
},
{
"title": "Month to Date by MOS",
"subtype": "column/classic",
"oid": "5dee487d87cef707f87dc9dd",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[POST.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "FINANCE DETAILS",
"column": "Mode of Sale Category",
"dim": "[FINANCE DETAILS.Mode of Sale Category]",
"datatype": "text",
"merged": true,
"title": "Mode of Sale Category"
},
"format": {
"members": {
"Box Office": {
"color": "#547A94",
"title": "Box Office",
"sortData": "Box Office",
"inResultset": true
},
"Online": {
"color": "#F48E06",
"title": "Online",
"sortData": "Online",
"inResultset": true
},
"Door Sales": {
"color": "#DB4935",
"title": "Door Sales",
"sortData": "Door Sales"
},
"Gift Voucher": {
"color": "#333333",
"title": "Gift Voucher",
"sortData": "Gift Voucher"
}
}
}
},
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"field": {
"id": "[PAYMENT.Payment Method Type1]",
"index": 0
},
"disabled": true
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "( sum( [74271-9AA] ) , [24CC4-284] )",
"context": {
"[74271-9AA]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[2D718-EAB]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 723
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[24CC4-284]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 731
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2017"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color_bkp": {
"color": "#DB4935",
"type": "color"
},
"color": {
"color": "#DB4935",
"type": "color"
}
},
"field": {
"id": "( sum( [74271-9AA] ) , [24CC4-284] )",
"index": 3
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "( sum( [D9745-5B7] ) , [6A65D-8FE] )",
"context": {
"[D9745-5B7]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[31BFF-9D5]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 30,
"offset": 0
}
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[6A65D-8FE]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 366
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2018"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color_bkp": {
"color": "#F48E06",
"type": "color"
},
"color": {
"color": "#F48E06",
"type": "color"
}
},
"field": {
"id": "( sum( [D9745-5B7] ) , [6A65D-8FE] )",
"index": 2
},
"disabled": false
},
{
"jaql": {
"type": "measure",
"formula": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"context": {
"[2FE62-F41]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[EED68-C91]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 0
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[E3015-9A6]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 1
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "YTD 2019"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color_bkp": {
"color": "#547A94",
"type": "color"
},
"color": {
"color": "#547A94",
"type": "color"
}
},
"field": {
"id": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"index": 1
},
"disabled": false
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year",
"filter": {
"fromNotEqual": "2016"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"title": "Calendar Year"
},
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount",
"filter": {
"toNotEqual": "0"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"disabled": false
},
{
"jaql": {
"table": "FINANCE DETAILS",
"column": "Mode of Sale Category",
"dim": "[FINANCE DETAILS.Mode of Sale Category]",
"datatype": "text",
"merged": true,
"title": "Mode of Sale Category",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"Door Sales",
"Development"
]
}
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
}
]
}
]
},
"type": "chart/column",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": -45
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"navigator": {
"enabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "mode_of_sale_category",
"title": "Mode of Sale Category",
"singular": "Mode of Sale Category",
"plural": "Mode of Sale Category"
},
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
},
{
"id": "calendar_year",
"title": "Calendar Year",
"singular": "Calendar Year",
"plural": "Calendar Year"
},
{
"id": "transaction_amount",
"title": "Transaction Amount",
"singular": "Transaction Amount",
"plural": "Transaction Amount"
}
]
}
},
"instanceid": "3C61A-4888-46",
"queryStartTime": "2019-12-17T16:07:28",
"disableSelctor": false,
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"viewState": {
"activeTab": "filters"
},
"realTimeRefreshing": false,
"dashboardid": "5dea57d9cff61223a896562b",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
},
"selectorLocked": false
},
"drawing": true,
"canEditFilters": true
},
{
"title": "This Month, This Year, by Operator",
"subtype": "bar/classic",
"oid": "5dee4cf287cef707f87dca50",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"selection": null,
"metadata": {
"ignore": {
"dimensions": [
"[POST.Date1 (Calendar)]"
],
"all": false
},
"panels": [
{
"name": "categories",
"items": [
{
"jaql": {
"table": "PAYMENT METHOD",
"column": "Payment Method Type",
"dim": "[PAYMENT.Payment Method Type1]",
"datatype": "text",
"merged": true,
"title": "Payment Method Type"
},
"field": {
"id": "[PAYMENT.Payment Method Type1]",
"index": 0
},
"disabled": true
},
{
"jaql": {
"table": "FINANCE DETAILS",
"column": "Created By",
"dim": "[FINANCE DETAILS.Created By]",
"datatype": "text",
"merged": true,
"title": "Created By"
}
}
]
},
{
"name": "values",
"items": [
{
"jaql": {
"type": "measure",
"formula": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"context": {
"[2FE62-F41]": {
"table": "FINANCE VALUES",
"column": "Credit Amount",
"dim": "[FINANCE VALUES.Credit Amount]",
"datatype": "numeric",
"title": "Credit Amount"
},
"[EED68-C91]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 0
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"[E3015-9A6]": {
"table": "TRANSACTION DATE",
"column": "Date",
"dim": "[TRANSACTION DATE.Date (Calendar)]",
"datatype": "datetime",
"merged": true,
"level": "days",
"title": "Days in Date",
"filter": {
"last": {
"count": 35,
"offset": 1
},
"custom": true
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
}
},
"title": "This December Voucher Sales",
"sort": "desc"
},
"format": {
"mask": {
"abbreviations": {
"t": false,
"b": false,
"m": false,
"k": false
},
"decimals": 0,
"currency": {
"symbol": "€",
"position": "pre"
}
},
"color_bkp": {
"color": "#547A94",
"type": "color"
},
"color": {
"type": "color",
"color": "#ffab03"
}
},
"field": {
"id": "( sum( [2FE62-F41] ) , [E3015-9A6] )",
"index": 1
},
"disabled": false
}
]
},
{
"name": "break by",
"items": []
},
{
"name": "filters",
"items": [
{
"jaql": {
"table": "TRANSACTION DATE",
"column": "Calendar Year",
"dim": "[TRANSACTION.Calendar Year1]",
"datatype": "numeric",
"title": "Calendar Year",
"filter": {
"fromNotEqual": "2016"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"title": "Calendar Year"
},
{
"jaql": {
"table": "FINANCE VALUES",
"column": "Transaction Amount",
"dim": "[FINANCE VALUES.Transaction Amount]",
"datatype": "numeric",
"title": "Transaction Amount",
"filter": {
"toNotEqual": "0"
},
"collapsed": false,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
}
},
"disabled": false
},
{
"jaql": {
"table": "FINANCE DETAILS",
"column": "Created By",
"dim": "[FINANCE DETAILS.Created By]",
"datatype": "text",
"merged": true,
"title": "Created By",
"filter": {
"explicit": false,
"multiSelection": true,
"exclude": {
"members": [
"webapi"
]
}
},
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-06T00:30:50"
},
"collapsed": true
}
}
]
}
]
},
"type": "chart/bar",
"iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC",
"style": {
"legend": {
"enabled": true,
"position": "bottom"
},
"seriesLabels": {
"enabled": true,
"rotation": 0
},
"xAxis": {
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"x2Title": {
"enabled": false
},
"gridLines": true,
"isIntervalEnabled": false
},
"yAxis": {
"inactive": false,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": true,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"y2Axis": {
"inactive": true,
"enabled": true,
"ticks": true,
"labels": {
"enabled": true,
"rotation": 0
},
"title": {
"enabled": false
},
"gridLines": false,
"logarithmic": false,
"hideMinMax": false,
"isIntervalEnabled": true
},
"dataLimits": {
"seriesCapacity": 50,
"categoriesCapacity": 100000
},
"navigator": {
"enabled": true
},
"narration": {
"enabled": false,
"display": "above",
"format": "bullets",
"verbosity": "medium",
"up_sentiment": "good",
"aggregation": "sum",
"labels": [
{
"id": "payment_method_type",
"title": "Payment Method Type",
"singular": "Payment Method Type",
"plural": "Payment Method Type"
},
{
"id": "created_by",
"title": "Created By",
"singular": "Created By",
"plural": "Created By"
},
{
"id": "calendar_year",
"title": "Calendar Year",
"singular": "Calendar Year",
"plural": "Calendar Year"
},
{
"id": "transaction_amount",
"title": "Transaction Amount",
"singular": "Transaction Amount",
"plural": "Transaction Amount"
}
]
}
},
"instanceid": "B7213-8503-63",
"widgetTimingLoged": false,
"continuousDates": false,
"nullAsZero": false,
"forcedRedraw": false,
"disableSelctor": false,
"drillToDashboardConfig": {
"drilledDashboardPrefix": "_",
"drilledDashboardsFolderPrefix": "",
"displayFilterPane": true,
"displayDashboardsPane": false,
"displayToolbarRow": true,
"displayHeaderRow": true,
"volatile": false,
"hideDrilledDashboards": false,
"drillToDashboardMenuCaption": "Jump to dashboard",
"drillToDashboardRightMenuCaption": "Jump to ",
"drillToDashboardNavigateType": 1,
"drillToDashboardNavigateTypePivot": 2,
"drillToDashboardNavigateTypeCharts": 1,
"drillToDashboardNavigateTypeOthers": 3,
"excludeFilterDims": [],
"includeFilterDims": [],
"drilledDashboardDisplayType": 2,
"dashboardIds": [],
"modalWindowResize": false,
"showFolderNameOnMenuSelection": false,
"resetDashFiltersAfterJTD": false,
"sameCubeRestriction": true,
"showJTDIcon": true
},
"chart": {
"0": {},
"context": {},
"length": 1
},
"realTimeRefreshing": false,
"dashboardid": "5dea57d9cff61223a896562b",
"options": {
"dashboardFiltersMode": "select",
"selector": true,
"triggersDomready": true,
"autoUpdateOnEveryChange": true,
"drillToAnywhere": true,
"previousScrollerLocation": {
"min": null,
"max": null
}
},
"queryStartTime": "2019-12-17T16:08:16",
"drawing": true,
"canEditFilters": true,
"viewState": {
"activeTab": "filters"
}
},
{
"title": "RICHTEXT_MAIN.TITLE",
"subtype": "richtexteditor",
"oid": "5dee50a487cef707f87dcac7",
"desc": null,
"source": null,
"datasource": {
"title": "Finance",
"fullname": "abbeyvanalytics01.abbeytheatre.inet/Finance",
"id": "aABBEYVANALYTICS01LgAaABBEYTHEATRELgAaINET_aFINANCE",
"address": "abbeyvanalytics01.abbeytheatre.inet",
"database": "aFinance",
"lastBuildTime": "2019-12-09T01:23:27"
},
"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": "",
"vAlign": "valign-middle",
"bgColor": "#FFFFFF",
"textAlign": "center"
}
},
"instanceid": "45D6E-95C9-51",
"widgetTimingLoged": false,
"drawing": true,
"realTimeRefreshing": false,
"dashboardid": "5dea57d9cff61223a896562b",
"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": []
}