Hi i'm very confused foreach array to array but this 1 index,I already did a lot of research about foreach object in Javascript and I tried many ways but nothing works. let me clarify what json what i want achieve :
[
{
"name": "Data1",
"color" : "#4473C2",
"data": [
{
"y": 10,
"total":100,
"md": "1",
"name": "Region 1",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 20,
"total":100,
"md": "1",
"name": "Region 2",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 10,
"total":100,
"md": "1",
"name": "Region 3",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 30,
"total":100,
"md": "1",
"name": "Region 4",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
}
]
}
,{
"name": "Data2",
"color" : "#EB7D30",
"data": [
{
"y": 95,
"total":100,
"md": "1",
"name": "Region 1",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 95,
"total":100,
"md": "1",
"name": "Region 2",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 95,
"total":100,
"md": "1",
"name": "Region 3",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
},{
"y": 95,
"total":100,
"md": "1",
"name": "Region 4",
"drillup" : 'level2',
"drilldown" : "3",
"next" : "level3"
}
]
}
]
and I tried to do foreach based on some finding of my research but the result wasn't like what I want or like what I'm try to achieve .. and here is the script that I tried :
and this output json from my code =>
[
{
"name": "Data 1",
"color": "#4473C2",
"data": [
{
"y": 23.89,
"total": 124,
"name": "Region 1",
"next": "level_3",
"drilldown": 22
}
]
},
{
"name": "Data 1",
"color": "#EB7D30",
"data": [
{
"y": 18.52,
"total": 40,
"name": "Region 2",
"next": "level_3",
"drilldown": 16
}
]
},
{
"name": "Data 1",
"data": [
{
"y": 12.88,
"total": 51,
"name": "Region 3",
"next": "level_3",
"drilldown": 10
}
]
},
{
"name": "Data 1",
"data":[
{
"y": 7.12,
"total": 28,
"name": "Region 4",
"next": "level_3",
"drilldown": 14
}
]
},
{
"name": "Data 2",
"data": [
{
"y": 94.44,
"total": 17,
"name": "Region 1",
"next": "level_3",
"drilldown": 22
}
]
},
{
"name": "Data 2",
"data": [
{
"y": 100,
"total": 11,
"name": "Region 2",
"next": "level_3",
"drilldown": 16
}
]
},
{
"name": "Data 2",
"data": [
{
"y": 90.91,
"total": 10,
"name": "Region 3",
"next": "level_3",
"drilldown": 10
}
]
},
{
"name": "Data 2",
"data": [
{
"y": 100,
"total": 2,
"name": "Region 4",
"next": "level_3",
"drilldown": 14
},
]
},]
can some one help me to achieve the data that i want ? thanks