Skip to content

Instantly share code, notes, and snippets.

@sebge2emasphere
Created May 8, 2018 11:58
Show Gist options
  • Save sebge2emasphere/35566386cbb6ba8d1c7ac3a4606270c7 to your computer and use it in GitHub Desktop.
Save sebge2emasphere/35566386cbb6ba8d1c7ac3a4606270c7 to your computer and use it in GitHub Desktop.
{
"id": "9a09dd5c-b009-42dc-9667-89bcea2de1dc",
"type": "stacked-column-chart",
"details": {
"id": "1b64d829-6410-40b5-8ca8-26047d895df0",
"type": "PIVOT"
},
"xAxis": {
"dimension": "h",
"title": {
"text": "Case"
},
"coordinates": [
{
"valueReference": {
"code": "h",
"defaultLabel": "Case"
},
"value": {
"value": "Budget-CY",
"type": "TEXT"
},
"dimensionName": "h",
"label": {
"value": "Budget-CY",
"type": "TEXT"
},
"type": "SIMPLE_VALUE"
},
{
"valueReference": {
"code": "h",
"defaultLabel": "Case"
},
"value": {
"value": "Actual-LY",
"type": "TEXT"
},
"dimensionName": "h",
"label": {
"value": "Actual-LY",
"type": "TEXT"
},
"type": "SIMPLE_VALUE"
},
{
"valueReference": {
"code": "h",
"defaultLabel": "Case"
},
"value": {
"value": "Actual-CY",
"type": "TEXT"
},
"dimensionName": "h",
"label": {
"value": "Actual-CY",
"type": "TEXT"
},
"type": "SIMPLE_VALUE"
}
]
},
"yAxis": {
"title": {
"text": "Amount"
}
},
"summaries": {
"dimensions": [
{
"name": "Name",
"values": [
{
"value": {
"value": "Recurrent",
"type": "TEXT"
},
"series": [
{
"name": "Min of amount",
"value": 450
},
{
"name": "Max of amount",
"value": 459
}
]
},
{
"value": {
"value": "Non-Recurrent",
"type": "TEXT"
},
"series": [
{
"name": "Min of amount",
"value": 440
},
{
"name": "Max of amount",
"value": 479
}
]
}
]
},
{
"name": "h",
"values": [
{
"value": "Budget-CY",
"series": [
{
"name": "Min of amount",
"value": 410
},
{
"name": "Max of amount",
"value": 429
}
]
},
{
"value": "Actual-LY",
"series": [
{
"name": "Min of amount",
"value": 450
},
{
"name": "Max of amount",
"value": 459
}
]
},
{
"value": "Actual-CY",
"series": [
{
"name": "Min of amount",
"value": 450
},
{
"name": "Max of amount",
"value": 459
}
]
}
]
}
],
"series": [
{
"name": "Min of amount",
"value": 450
},
{
"name": "Max of amount",
"value": 461
}
]
},
"series": [
{
"type": null,
"name": {
"value": "Recurrent",
"type": "TEXT"
},
"coordinate": {
"dimensionName": "b",
"group": {
"type": "SIMPLE_EXPRESSION",
"name": "Recurrent",
"values": [
"* Recu*"
]
},
"label": {
"value": "Recurrent",
"type": "TEXT"
},
"type": "TEXT_RANGE"
},
"summaries": [
{
"name": "name of summary",
"value": 45498
}
],
"data": [
902761.68,
943551.81,
861664.22
]
},
{
"type": null,
"name": {
"value": "Non Recurrent",
"type": "TEXT"
},
"coordinate": {
"dimensionName": "b",
"group": {
"type": "SIMPLE_EXPRESSION",
"name": "Non Recurrent",
"values": [
"*Non-*"
]
},
"label": {
"value": "Non Recurrent",
"type": "TEXT"
},
"type": "TEXT_RANGE"
},
"data": [
-32047.92,
-56922.81,
-41147.36
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment