I have an original array deptWiseAlerts
, I am trying to bring out an output array graphData3
as below
[
{
“name”: “0-3 Days”,
“data”: [
{
“x”: “SME”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 175000
}
]
},
{
“x”: “FD”,
“y”: 3,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 3
},
{
“name”: “Value:”,
“value”: -234000
}
]
},
{
“x”: “CBOD”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 5849
}
]
},
{
“x”: “DC”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 1500
}
]
},
{
“x”: “GOD”,
“y”: 3,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_16”
},
{
“name”: “Count:”,
“value”: 3
},
{
“name”: “Value:”,
“value”: 49876.0
}
]
},
{
“x”: “GB”,
“y”: 18,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 18
},
{
“name”: “Value:”,
“value”: 109916
}
]
},
{
“x”: “DBD”,
“y”: 2,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 2
},
{
“name”: “Value:”,
“value”: 107960.99
}
]
},
{
“x”: “GB”,
“y”: 18,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_16”
},
{
“name”: “Count:”,
“value”: 18
},
{
“name”: “Value:”,
“value”: 3651521
}
]
},
{
“x”: “GOD”,
“y”: 128,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 128
},
{
“name”: “Value:”,
“value”: 903633072.58
}
]
},
{
“x”: “ARD”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 70000
}
]
},
{
“x”: “EP”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 249000
}
]
},
{
“x”: “HR”,
“y”: 3,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 3
},
{
“name”: “Value:”,
“value”: -1383000
}
]
},
{
“x”: “GOD”,
“y”: 135,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 135
},
{
“name”: “Value:”,
“value”: -5621075.36
}
]
},
{
“x”: “TDS”,
“y”: 2,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 2
},
{
“name”: “Value:”,
“value”: 2952
}
]
},
{
“x”: “CID”,
“y”: 3,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 3
},
{
“name”: “Value:”,
“value”: -9000
}
]
},
{
“x”: “PPRD”,
“y”: 3,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_17”
},
{
“name”: “Count:”,
“value”: 3
},
{
“name”: “Value:”,
“value”: -7716864
}
]
},
{
“x”: “GB”,
“y”: 1,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 1
},
{
“name”: “Value:”,
“value”: 15000
}
]
},
{
“x”: “RMD”,
“y”: 2,
“goals”: [
{
“name”: “Rule:”,
“value”: “Rule_32”
},
{
“name”: “Count:”,
“value”: 2
},
{
“name”: “Value:”,
“value”: 80000000
}
]
}
]
},
{
“name”: “4-7 Days”,
“data”: […]
},
{
“name”: “8-12 Days”,
“data”: […]
},
{
“name”: “>12 Days”,
“data”: […]
}
]
Here I have given example of only “0-3 Days”, but the same should apply for “4-7 Days”, “8-12 Days”, “>12 Days”
I have tried the code “https://jsfiddle.net/qd6bsocL/”, but it is removing the duplicates while pushing the formatted array to graphData3. The duplicates should not be removed.
please help
1