Hi all I have following code
[
{service: { name: "Home" },status: "Generated", feeCharged:{id:1,fee:2},
{service: { name: " Photography" },status: "requested",feeCharged:{id:2,fee:24}},
{service: { name: "Electrical" },status: "requested",feeCharged:{id:6,fee:42}},
{service: { name: "Electrical" },status: "Completed",feeCharged:{id:66,fee:23} },
{service: { name: " Photography" },status: "Completed",feeCharged:{id:78,fee:11}},
{service: { name: "Home" },status: "Generated",feeCharged:{id:45,fee:234}},
{service: { name: "Electrical" }, status: "requested",feeCharged:{id:77,fee:3} },
{service: { name: "Electrical" }, status: "requested",feeCharged:{id:4,fee:33} }
]
Now I am trying to filter them in new array by service.name and by status and add count.
The final result should be:
[
{ name: "Home", status: "Generated", count: 2 },
{ name: "Photography", status: "requested", count: 1 },
{ name: "Photography", status: "Completed", count: 1 },
{ name: "Electrical", status: "requested", count: 3 },
{ name: "Electrical", status: "Completed", count: 1 }
]
So as you see in my final result if there are same service.name and status I am merging them into one object and setting count.
For filtering I try this, but it not working as I expected:
let answer = [];
data.forEach((x) => {
if (!answer.some((y) => y.name === x.service.name)) {
let newAnswer = {};
newAnswer.name = x.service.name;
newAnswer.value = 1;
answer.push(newAnswer);
} else {
let existAnswer = answer.find((y) => y.name === x.service.name);
existAnswer.value++;
}
});
Please help me to achieve that result, thanks.
Maybe this will be helpful for you?
const data = [{ service: { name: "Home" }, status: "Generated", feeCharged: { id: 1, fee: 2 }},{ service: { name: " Photography" }, status: "requested", feeCharged: { id: 2, fee: 24 } }, { service: { name: "Electrical" }, status: "requested", feeCharged: { id: 6, fee: 42 } }, { service: { name: "Electrical" }, status: "Completed", feeCharged: { id: 66, fee: 23 } }, { service: { name: " Photography" }, status: "Completed", feeCharged: { id: 78, fee: 11 } }, { service: { name: "Home" }, status: "Generated", feeCharged: { id: 45, fee: 234 } }, { service: { name: "Electrical" }, status: "requested", feeCharged: { id: 77, fee: 3 } }, { service: { name: "Electrical" }, status: "requested", feeCharged: { id: 4, fee: 33 } }];
const res = Object.entries(data.reduce((a, e, nam) => { // get counts of name/status combinations
nam = e.service.name + "|" + e.status;
a[nam] = (a[nam] ?? 0) + 1;
return a;
}, {})).map(([k, n], t) =>{ // separate name/status key values again ...
t = k.split("|");
return {name: t[0],status: t[1],count: n};
})
console.log(res)(The current implementation uses | as a delimiter between the name and status value. Therefore it will fail if a name or status value contains this character.)