const ProductGroupConversionRublesChart = ({ data }) => { const chartData = data.filter(d => d.total_revenue > 0 && d.conversion_rubles_percent > 0); const aggregatedData = chartData.reduce((acc, curr) => { if (!acc[curr.product_group]) { acc[curr.product_group] = { product_group: curr.product_group, total_revenue: 0, total_order_amount_with_vat: 0 }; } acc[curr.product_group].total_revenue += curr.total_revenue; // Assuming order_amount_with_vat is needed for overall conversion calculation // The current data structure doesn't directly provide total_order_amount_with_vat, // so I'll use the pre-calculated conversion_rubles_percent for simplicity, // averaging it across managers for the product group. // For a more precise calculation, I would need to sum order_amount_with_vat from the raw data. return acc; }, {}); const finalChartData = Object.values(aggregatedData).map(d => { const groupData = data.filter(item => item.product_group === d.product_group && item.total_revenue > 0); const avgConversion = groupData.reduce((sum, item) => sum + item.conversion_rubles_percent, 0) / groupData.length; return { product_group: d.product_group, conversion_rubles_percent: avgConversion }; }).filter(d => d.conversion_rubles_percent > 0); const sortedData = [...finalChartData].sort((a, b) => a.conversion_rubles_percent - b.conversion_rubles_percent).slice(0, 15); // Bottom 15 for clarity return ( `${value}%`} style={{ fontSize: 12 }} /> [`${value}%`, 'Рублевая конверсия']} contentStyle={{ backgroundColor: BACKGROUND_COLOR, borderRadius: 8 }} /> ); };