You need to sign in to do that
Don't have an account?
Kanus wave
Working on toggle in wave Analytics,,,While am uploading json file for sum of amount(measure) in opportunities..It throws an error of Indexof of Undefined
Code:
{
"label": "toggle1",
"state": {
"steps": {
"step_date_static_with_start": {
"type": "static",
"values": [
{
"display": "-6 years",
"value": [
[
[
"year",
-6
],
[
"year",
0
]
]
]
},
{
"display": "-5 years",
"value": [
[
[
"year",
-5
],
[
"year",
0
]
]
]
},
{
"display": "-4 years",
"value": [
[
[
"year",
-4
],
[
"year",
0
]
]
]
}
],
"selectMode": "singlerequired",
"start": [
[
[
[
"year",
-5
],
[
"year",
0
]
]
]
],
"isGlobal": false,
"isFacet": false,
"useGlobal": false
},
"Sum_of_Amount": {
"type": "static",
"values": [
{
"display": "Amount",
"value": [
[
[
"sum",
"Amount"
]
]
]
},
{
"display": "Quantity",
"value": [
[
[
"sum",
"Quantity"
]
]
]
},
{
"display": "Probability",
"value": [
[
[
"avg",
"probability"
]
]
]
}
],
"selectMode": "singlerequired",
"start": [
[
[
[
"sum",
"Amount"
]
]
]
],
"isGlobal": false,
"isFacet": false,
"useGlobal": false
},
"Amount_1": {
"isFacet": true,
"isGlobal": false,
"query": {
"measures": "{{selection(Sum_of_Amount)}}"
},
"selectMode": "single",
"type": "aggregate",
"useGlobal": true,
"start": null,
"datasets": [
{
"name": "Opportunity_1_taconic"
}
],
"visualizationParameters": {
"visualizationType": "hbar"
}
}
},
"widgets": {
"number_1": {
"type": "number",
"position": {
"zIndex": 0,
"x": 0,
"y": 0,
"w": 300
},
"parameters": {
"step": "Amount_1",
"measureField": "sum_Amount",
"textColor": "rgb(246, 10, 10)"
}
},
"buttongroup_1": {
"type": "pillbox",
"position": {
"zIndex": 1,
"x": 410,
"y": 20,
"w": 480
},
"parameters": {
"step": "step_date_static_with_start",
"measureField": "",
"selectModeOverride": "singlerequired"
}
},
"buttongroup_2": {
"type": "pillbox",
"position": {
"zIndex": 2,
"x": 0,
"y": 110,
"w": 480
},
"parameters": {
"step": "Sum_of_Amount",
"measureField": "",
"selectModeOverride": "singlerequired"
}
}
},
"layouts": []
},
"datasets": [
{
"id": "0Fb28000000L2YKCA0",
"name": "Opportunity_1_taconic"
}
]
}
thanks in Advance
{
"label": "toggle1",
"state": {
"steps": {
"step_date_static_with_start": {
"type": "static",
"values": [
{
"display": "-6 years",
"value": [
[
[
"year",
-6
],
[
"year",
0
]
]
]
},
{
"display": "-5 years",
"value": [
[
[
"year",
-5
],
[
"year",
0
]
]
]
},
{
"display": "-4 years",
"value": [
[
[
"year",
-4
],
[
"year",
0
]
]
]
}
],
"selectMode": "singlerequired",
"start": [
[
[
[
"year",
-5
],
[
"year",
0
]
]
]
],
"isGlobal": false,
"isFacet": false,
"useGlobal": false
},
"Sum_of_Amount": {
"type": "static",
"values": [
{
"display": "Amount",
"value": [
[
[
"sum",
"Amount"
]
]
]
},
{
"display": "Quantity",
"value": [
[
[
"sum",
"Quantity"
]
]
]
},
{
"display": "Probability",
"value": [
[
[
"avg",
"probability"
]
]
]
}
],
"selectMode": "singlerequired",
"start": [
[
[
[
"sum",
"Amount"
]
]
]
],
"isGlobal": false,
"isFacet": false,
"useGlobal": false
},
"Amount_1": {
"isFacet": true,
"isGlobal": false,
"query": {
"measures": "{{selection(Sum_of_Amount)}}"
},
"selectMode": "single",
"type": "aggregate",
"useGlobal": true,
"start": null,
"datasets": [
{
"name": "Opportunity_1_taconic"
}
],
"visualizationParameters": {
"visualizationType": "hbar"
}
}
},
"widgets": {
"number_1": {
"type": "number",
"position": {
"zIndex": 0,
"x": 0,
"y": 0,
"w": 300
},
"parameters": {
"step": "Amount_1",
"measureField": "sum_Amount",
"textColor": "rgb(246, 10, 10)"
}
},
"buttongroup_1": {
"type": "pillbox",
"position": {
"zIndex": 1,
"x": 410,
"y": 20,
"w": 480
},
"parameters": {
"step": "step_date_static_with_start",
"measureField": "",
"selectModeOverride": "singlerequired"
}
},
"buttongroup_2": {
"type": "pillbox",
"position": {
"zIndex": 2,
"x": 0,
"y": 110,
"w": 480
},
"parameters": {
"step": "Sum_of_Amount",
"measureField": "",
"selectModeOverride": "singlerequired"
}
}
},
"layouts": []
},
"datasets": [
{
"id": "0Fb28000000L2YKCA0",
"name": "Opportunity_1_taconic"
}
]
}
thanks in Advance