Estoy escribiendo aquí por primera vez, y me dieron el siguiente problema. Por ejemplo, tengo la siguiente matriz:
const input = [ { id: 1, date: "01-01-2021", source: "TT", metrics: { conversions: 10, cpl: 3 }, }, { id: 2, date: "01-01-2021", source: "TT", metrics: { conversions: 15, cpl: 3 }, }, { id: 3, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 4, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 5, date: "02-01-2021", source: "TT", metrics: { conversions: 5, cpl: 2 }, }, { id: 6, date: "02-01-2021", source: "TT", metrics: { conversions: 15, cpl: 2 }, }, { id: 7, date: "02-01-2021", source: "FB", metrics: { conversions: 25, cpl: 1 }, }, { id: 8, date: "02-01-2021", source: "FB", metrics: { conversions: 30, cpl: 1 }, }, ];Y necesito obtener una matriz agrupada por fecha y fuente y el valor será la suma de todos sus valores para una fecha específica, por ejemplo, como el resultado a continuación:
const output = [ { date: "01-01-2021", TT: 25, FB: 30, }, { date: "02-01-2021", TT: 20, FB: 55, }, ];En mi solución, encuentro claves y fechas únicas, pero no entiendo qué hacer a continuación. ¿Me puedes ayudar? Código de muestra:
const result = input.reduce((acc, current) => { const dateItem = acc.find((item) => item.date === current.date); const sources = input.map((item) => item.source).filter((value, index, self) => self.indexOf(value) === index); if (dateItem) { return [...acc.filter((i) => i.date !== current.date), { ...dateItem }]; } return [...acc, { date: current.date }]; }, []);Bucle de reducción simple usando la fecha como clave. Después de combinarlo todo, puede usar valores para obtener la matriz.
const input = [{ id: 1, date: "01-01-2021", source: "TT", metrics: { conversions: 10, cpl: 3 }, }, { id: 2, date: "01-01-2021", source: "TT", metrics: { conversions: 15, cpl: 3 }, }, { id: 3, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 4, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 5, date: "02-01-2021", source: "TT", metrics: { conversions: 5, cpl: 2 }, }, { id: 6, date: "02-01-2021", source: "TT", metrics: { conversions: 15, cpl: 2 }, }, { id: 7, date: "02-01-2021", source: "FB", metrics: { conversions: 25, cpl: 1 }, }, { id: 8, date: "02-01-2021", source: "FB", metrics: { conversions: 30, cpl: 1 }, }, ]; const results = Object.values(input.reduce((o, data) => { o[data.date] = o[data.date] || { date: data.date }; o[data.date][data.source] = (o[data.date][data.source] || 0) + data.metrics.conversions; return o; }, {})); console.log(results);Array.reduce con Object.values dará el resultado.
const input = [ { id: 1, date: "01-01-2021", source: "TT", metrics: { conversions: 10, cpl: 3 }, }, { id: 2, date: "01-01-2021", source: "TT", metrics: { conversions: 15, cpl: 3 }, }, { id: 3, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 4, date: "01-01-2021", source: "FB", metrics: { conversions: 15, cpl: 4 }, }, { id: 5, date: "02-01-2021", source: "TT", metrics: { conversions: 5, cpl: 2 }, }, { id: 6, date: "02-01-2021", source: "TT", metrics: { conversions: 15, cpl: 2 }, }, { id: 7, date: "02-01-2021", source: "FB", metrics: { conversions: 25, cpl: 1 }, }, { id: 8, date: "02-01-2021", source: "FB", metrics: { conversions: 30, cpl: 1 }, }, ]; const output = input.reduce((acc, curr) => { if (acc[curr.date]) { acc[curr.date][curr.source] = (acc[curr.date][curr.source] || 0) + curr.metrics.conversions; } else { acc[curr.date] = { date: curr.date, [curr.source]: curr.metrics.conversions } } return acc; }, {}); console.log(Object.values(output));